Excel Tips
June 30, 2017
Regular pivot table filters offer the Show All Report Filter pages, but Slicers do not support this functionality. Today, some VBA to loop through all possible slicer combinations.
Learn Excel Conditional Format Mixed References »
June 29, 2017
Setting up a conditional formatting formula that uses a mixed reference. Most conditional formatting formulas require an absolute reference. But this spreadsheet to track trucks in a yard requires
Sync Slicers from Different Data Sets »
June 22, 2017
Slicers are awesome for pivot tables because you can control multiple pivot tables from one set of slicers. But - that is sort of a lie. You can control multiple pivot tables that came from the same data set. When you have pivot tables that came from two different data sets, it is pretty tricky. I will show you some VBA that will let you pull this off.
June 20, 2017
Searching Comments! Yes - I am talking about those tiny little post-it note comments that you get when you go to the Review tab and click New Comment.
June 19, 2017
Pivot tables are great for creating frequency distributions. But the built-in functionality assumes that each bin or bucket is an identical size. What if you have uneven bins?
June 18, 2017
How many small orders do you process each month? How much revenue is associated with those small orders. Pivot tables make this easy.
June 12, 2017
Awesome trick for interpolation in Excel. If you need 10 values between 117 and 235, you can have Excel calculate this without a formula.
June 9, 2017
You need to reduce every number in an Excel column by 3 or 7 or 22 or 12%. Here are several ways that you can quickly solve this problem.
May 28, 2017
I love custom lists in Excel. They are great for the fill handle and for sorting data into a different sequence. Custom Lists should allow 254 items. But for some reason, a reader is encountering a situation where Excel is only keeping the first 38 items! We will get to the bottom of this mystery.