Protect an Excel worksheet and use the auto filter. A how to guide.
Add a count formula across multiple sheets in Excel.
Excel VBA to select sheets and print out the selected sheets using PDF.
A Power BI Desktop example using Power BI
This is a list of Excel dashboards - the best I have produced to date. These are time saving Excel tools.
This post is about financial modelling, how to do it and what is important when it comes to manipulating Excel data.
In Excel you may wish to drill down on a range which has a header value not already contained in the rows. The following article shows a practical example of how to generate a unique row name based on the heading in a specific place. The procedure is in VBA.
This is a social media dashboard created in Excel. It is free to download and has all of the graphs and source formula in the file.
Trap a range area with VBA and loop to next range area. This little used Excel VBA technique is awesome and a real win when you learn the mechanics of it.
No Spaces in Excel sheet names is a good habit to get into.