Excel Tips
July 3, 2017
Tip #1 from the MrExcel XL book - fast ways to copy a formula down a column.
Split Workbook by Worksheets »
July 1, 2017
You have a workbook with many worksheets. You want to send each worksheet to a different person. Today, a macro to split that data out.
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.