Microsoft Excel Tips & Tricks

How to show formulas or calculations in a Microsoft Excel worksheet

One of the fundamental features of Microsoft Excel is we can build formulas and functions and then see the results in our worksheet. But sometimes, it would be helpful to see what’s behind these results. And we don’t want to…

Do You Want to Flip Excel Data? Don’t Retype. Use Transpose.

Microsoft Excel Tips & Tricks

Excel shortcuts, Excel Tips & Tricks

What do you do when you have Microsoft Excel data that you want to flip? That is, to switch the columns to rows? Or rows to columns? Perhaps the data is from a download from another system, or you’ve received…

Excel 3D formula, image of the characters 3D, how to create 3D formulas in Microsoft Excel

How to Summarize Excel Data with 3D Formulas

Microsoft Excel Tips & Tricks

Excel formulas, Excel Tips & Tricks

If you’ve ever needed to summarize the same cell or the same type of data on multiple Excel worksheets, you’ll know this can be quite a tedious process. For instance, to add the values in cell B5 from a series…

Microsoft Excel: Easy Data Analysis with the IF Function

Microsoft Excel Tips & Tricks

Excel formulas, Excel functions, Excel Tips & Tricks

Although SUM is the most frequently used function in Excel, the IF function should also be in your Excel bag of workbook tricks. The IF function tests whether a condition is true or false and then performs an action such…

Microsoft Excel AutoCalculate; automation tools in Excel

Easy Auditing in Microsoft Excel with AutoCalculate

Microsoft Excel Tips & Tricks

Excel formulas, Excel shortcuts, Excel Tips & Tricks

AutoCalculate is a handy Excel feature that lets you quickly check totals, averages, and much more. Although it doesn’t actually build calculations or formulas, it can be a quick auditing tool and an easy way to double-check your worksheets. Read…

Microsoft Excel Tips & Tricks

Microsoft Excel: How to Show Formulas in a Worksheet

Do You Want to Flip Excel Data? Don’t Retype. Use Transpose.

How to Summarize Excel Data with 3D Formulas

Microsoft Excel: Easy Data Analysis with the IF Function

Easy Auditing in Microsoft Excel with AutoCalculate

TRAINING

TIPS

THE PRO SHOP

SPEAKER