On this page you'll find various workbooks containing examples to accompany our blog posts. Links to the posts are provided so so you can read up on the topic.
You can also find other files like eBooks available for free download.
Click on the icon to download the file.
Please enter your email address below to access the files.
Use Slicers to filter data in PivotTables, PivotCharts, Excel Tables and CUBE functions. This workbook contains a number of examples.
Learn Excel Dashboards in Mynda's comprehensive online course.
Use Power Query’s Unpivot tool to fix 3 common data layout problems.
Use ASCII and Unicode ALT Codes in Excel to display symbols and special characters like superscripts, subscripts, Greek letters, mathematical symbols and many more.
Power BI Desktop Files
Power BI brings your data to life in interactive visualizations. Download this file with working Power BI report examples.
eBooks & PDF
These are some of our favourite tips and power features that’ll get you well on your way to 'Excel Guru Status' giving you not only the recognition you deserve, but also making your work more enjoyable.
30 easy to action tips on how to create better charts in Excel and the common pitfalls to avoid.
Knowing the best chart for your message is essential if you are to produce effective dashboard reports that clearly and succinctly convey your message.
A PDF version of the official Microsoft help file for Excel 4 macros.
Work faster and more efficiently with our list of Excel shortcuts.
Everything you need to know about working with dates and time in Excel.
This is the mscomct2.cab file. Can be used to install the MonthView control if you are using Excel forms.
TIP: Right click the links with your mouse and choose 'Save as', 'Save target as' or 'Save link as'