Excel Macro Email





Categories: Excel®, Macros

Among the many little-known and perhaps even-less-used hacks one could exploit via Microsoft Office, an Excel macro email can save precious hours on a weekly basis. As a bonus, understanding the nature of these handy little “cheats” provides an incidental beginner’s introduction to some very basic principles of coding. This handy VBA code will send […]

Read More

Save Time With Our Excel Formulas Cheat Sheet





Categories: Excel®, Formulas, Functions

Syntax, Operators and Functions…Oh My! Do you speak Excel? Are you just starting out and trying to remember the go-to lingo? Well, today’s blog post is a snapshot of helpful cheat sheet material to help you build your Excel skills. Advanced Filter Criteria Popular Excel Functions and Descriptions Next Steps As you continue working in […]

Read More

Highlight Valuable Data With Excel Conditional Formulas





Categories: Excel®

You can conditionally format your data in order to draw attention to outliers and quickly assess how significant your data points are. Conditional formatting can be used to highlight interesting cells, emphasize unusual values, and visualize data using data bars, color scales, and icon sets based on specific criteria. Excel has several built in conditions […]

Read More

Excel Formula Syntax – The Language of Formulas and Functions





Categories: Excel®

Excel makes it a simple task to perform mathematical operations. Using Excel formula syntax, you can calculate and analyze data in your worksheet. As a reminder: Formulas are equations that combine values and cell references with operators to calculate a result. Functions are prebuilt formulas that can be quickly fed values without the need to write the […]

Read More