Month: September 2018
Setting Box gives you 51 tips to get more out of Excel. A lot of great features here!
JKP gives you some VBA code to synchronize slicers for your pivot tables.
Excel is Fun goes into detail on Data Analysis, explaining many of Microsoft’s power tools.
Not Just Numbers shows you how to evaluate a small piece of a formula. This is a useful tip for auditing!
You may know how to create a graph from existing data… but can you extract the data from a graph? Engineer Excel shows you a tool that does just that!
Excel Charts shares 10 reasons why you should take Excel Dashboards seriously
George J Mount takes you step by step through the process of creating a pivot table of every player who has won a baseball award since the 1870s!