Excel Tips
September 6, 2017
Excel usually shows you the results of your formulas. What if you would rather see all of the formulas? This article will show you the simple Show Formulas mode.
September 6, 2017
Some of the most-used keys in Excel are the Ctrl keys that you know from other Windows programs. Today, we take a look at the top keys.
September 5, 2017
How to quickly convert formulas to Values. Everyone has a favorite way to do this, but my method is faster than yours.
Excel Shortcut - Freeze Panes + More »
September 5, 2017
Excel has a lot of keyboard shortcuts. This article will show you how to find the shortcut for any command that your frequently use. Also - a look at Freeze Panes in Excel.
September 4, 2017
Today, the secret double-life of the F4 key. Yes, F4 adds the $ to a formula to make it absolute. But the F4 key has a whole other set of skills when you are not in Formula Edit mode.
Excel Shortcuts - Ditto Cell Above »
September 4, 2017
The Ditto Key in Excel. This great shortcut can copy a formula down one cell, whilst keeping the cell references pointing at the original cells. Why is this useful? Read on.
Power Pivot Portable Formulas »
September 1, 2017
Once you define a new measure in Power Pivot, that formula can be used in subsequent formulas.
Excel Shortcut - AutoFit Column Width »
September 1, 2017
Excel keyboard shortcut to make all columns wide enough for the values in the column.
August 31, 2017
Excel Data Model (Power Pivot) allows you to connect a large detailed data set of actuals to a top-level budget by using joiner tables.