Example File Listing
This page contains several helpful example files and templates. Many of them go along with the blog articles and videos, and links to those articles are included in the description.
| File | Description |
| Navigation Shortcuts | Contains example of using Table of Contents XLEV8 macro to help navigate workbooks. See the related article and video. |
| Extreme Shortcuts | Contains examples of using Create Subfolders and Create Shortcuts macros. See the related article and video. |
| Dynamic Hyperlinks | Contains examples of using the Excel HYPERLINK formula to create dynamic shortcuts and hyperlinks. |
| Ribbon/QAT Customizations | Compressed folder that contains example QAT and ribbon customization files that can be imported into Excel, Word, and PowerPoint. See the related article and video. |
| Named Ranges | Contains examples of using named ranges, set up with the Add Named Ranges From List XLEV8 macro. See the related article and video. |
| Absolute and Relative References | Contains examples of using different reference types in Excel. See the related article and video. |
| INDIRECT Formula – Delete Replace Sheet | Contains an example of using the INDIRECT formula to reference sheets that can be deleted and replaced without breaking links. See the related article and video. |
| INDIRECT Formula – Sheet References | Contains an example of using the INDIRECT formula to quickly, easily, and dynamically reference the same cells in multiple sheets within the same file. See the related article and video. |
| INDIRECT Formula – External References | Contains a zipped folder with a workbook containing an example of using the INDIRECT formula to quickly, easily, and dynamically reference external files, as well as the referenced source files. See the related article and video. |
| Data Validation | Contains examples of using dynamic data validation lists in Excel using Add Dynamic Named Range and Add Data Validation From Named Range XLEV8 macros. See the related article and video. |
| Conditional Formating | Contains examples of using conditional formatting in Excel, including the CF highlight Blanks, Add Banding, and Red Green CF Variance XLEV8 macros. See the related article and video. |
| PivotTables and PivotCharts | Contains examples of using PivotTables and PivotCharts, including using the Add Routine Pivot XLEV8 macro to quickly and easily insert recurring PivotTables/PivotCharts. See the related article and video. |
| PivotChart Template | Great example of template file for quickly updating routine PivotCharts. |
| Revenue Center Template | Great example of a template file that contains Instructions, Inputs, Checks, Report Summaries, Calculations, Lookups, and Data Sources sheets to efficiently update each period. See the related article and video. |
| P&L Review Template | Great example of a template file that includes helpful review summaries and views. See the related article and video. |
| PL Distribution Template | Template related to the P&L Review Template above that pulls in and formats source data sheets, among other steps. |
| Popular XLEV8 Macros | Contains examples of several popular XLEV8 macros. See the related article and video. |
| XLEV8 Custom Macros | Compressed folder that contains example custom macro files for Excel, Word, and PowerPoint that can be used to add up to 20 of your own macros that can be run via the XLEV8 ribbon, keyboard shortcuts, or the Search Macros box. See the related article. |
| CPE Listing | Helpful template for tracing CPE courses planned and completd. |
| Vacation Tracker | Template that contains unique calendar-list view to show team member different color-coded categorical vacation and other out-of-office dates. |
| SQL Database Management Template | File that helps streamline SQL tasks related to inserting and updating tables and fields and serves as a backup or reference of table structures. |
| PivotChart Multiple Stores YoY Comparison | Example of PivotChart showing year-over-year guest satisfaction scores for multiple stores. |
| PivotChart Store Sales Trend Dual Axis | Example of PivotChart showing sales trend with % change on secondary axis. |
| Excel Function Examples | Contains several common Excel formula function examples. |
| XLEV8 Crash Course Files – Before | Contains example files used in the XLEV8 Crash Course before running any macros. |
| XLEV8 Crash Course Files – After | Contains example files used in the XLEV8 Crash Course after running macros covered during the course. |
| Loan Amortization Schedule | This is an example of a loan amortization schedule that can be quickly updated and tweaked to show different scenarios of paying off a loan. |
| Bingo Generator | Contains two macro-driven Excel files – one to generate a BINGO game for the host and one to generate BINGO cards for the participants. Great for virtual happy hours! |
| Automated Expense Report Template | Great template for automating the population of a web-based expense report. Uses references and lookups to build the steps that can be automated using the Run Browser Steps macro. See the related article and video |
| Time Tracker Template | Template for tracking the time you spend servicing clients across multiple projects. Includes a macro that will export time detail lines to a separate file that can be used to support invoices, if desired. |
