July 18, 2019
There are 400+ functions in Excel. Instead of taking 450 pages to describe every function, I am going to teach you how to find the function that you need.
July 17, 2019
Inquire was developed by a company called Prodiance that offered the slick Spreadsheet Compare tool for $145 per person per year. The Excel team liked it so much that Microsoft bought out Prodiance and gave the tool for free to anyone who is on Pro Plus, Professional Plus, or Enterprise Level E3.
July 15, 2019
I previously explained how to Trace Precedents to See What Cells Flow into a Formula. Sometimes you have the opposite problem: You want to see which cells rely on the value in the current cell.
July 11, 2019
If you need to see which cells flow into a formula, you can use the Trace Precedents command in the Formula Auditing group on the Formulas tab.
July 10, 2019
If you are going to be auditing the worksheet, it would help to mark all of the formula cells.
July 8, 2019
You inherit a spreadsheet from a former co-worker and you need to figure out how the calculations work. You could visit each cell, one at a time, and look at the formula in the formula bar. Or you could quickly toggle between pressing F2 and Esc to see the formula right in the cell.
July 4, 2019
A mysterious part of the Paste Special dialog is the Skip Blanks feature. What does it do? Say that you have a list of existing values. In another column, you have updates for some of those values but not all of them.
July 3, 2019
I always say there are five ways to do anything in Excel. Converting live formulas to values is a task that has far more than five ways. But I will bet that I can teach you two ways that are faster than what you are using now.
July 1, 2019
If you want to avoid using $ in references to make them absolute, you can use named ranges instead.
June 27, 2019
The mighty F4 key should be in your Excel arsenal for two completely different reasons.
June 26, 2019
Say that you have two different data sets. You want a pivot table from each data set and you want those two pivot tables to react to one slicer.
June 24, 2019
Another amazing use for a measure in a Data Model pivot table is to use the CONCATENATEX function to move text into the values area of a pivot table.