Free Excel templates and practice files
Free templates and practice files for the apps we teach. Download a file, open it in Excel, and follow its step-by-step guide.
8templates
48practice files
Freeno sign-up
How every template works
- Pale-yellow cells are yoursType your own data here. Everything else updates from it.
- Green cells calculateFormulas fill these in. Leave them as they are.
- Dropdowns keep data tidyPick categories and statuses from a list instead of typing them.
- Start Here and ChecksA one-page dashboard up front and a Checks tab that flags problems.
Excel
Ready-made workbooks for money, business, projects, people and school, plus the practice file for every Excel tutorial.
Templates
8 workbooksPersonal finance
2 templatesSmall business
1 templateOperations
1 templateProject management
1 templateReal estate
1 templateHR and scheduling
1 templateSchool and college
1 templatePractice files
One workbook for each of the 48 tutorialsBeginner12
- Excel Basics: Workbooks, Cells and Ranges.xlsx 6 KB
- Excel Navigation and Keyboard Shortcuts.xlsx 7 KB
- How to Format Cells in Excel.xlsx 7 KB
- Number and Date Formats in Excel.xlsx 7 KB
- How to Write Basic Formulas in Excel.xlsx 7 KB
- Essential Excel Functions: SUM, AVERAGE, COUNT, MIN and MAX.xlsx 7 KB
- Copying Formulas and Cell References in Excel.xlsx 7 KB
- How to Write IF Statements in Excel.xlsx 7 KB
- How to Sort and Filter Data in Excel.xlsx 7 KB
- How to Use Excel Tables.xlsx 8 KB
- How to Clean Up Data in Excel.xlsx 7 KB
- How to Create a Chart in Excel.xlsx 9 KB
Intermediate12
- How to Use Conditional Formatting in Excel.xlsx 7 KB
- Relative, Absolute and Mixed References in Excel.xlsx 7 KB
- Logic Formulas in Excel: IF with AND, OR and IFS.xlsx 7 KB
- Lookup Formulas in Excel: XLOOKUP, VLOOKUP and INDEX/MATCH.xlsx 7 KB
- Text and Date Functions in Excel.xlsx 7 KB
- Turn Messy Data into a Clean Excel Table.xlsx 8 KB
- How to Use Data Validation in Excel.xlsx 7 KB
- Importing and Cleaning Data in Excel.xlsx 7 KB
- PivotCharts, Slicers and Simple Dashboards in Excel.xlsx 9 KB
- How to Create a PivotTable in Excel.xlsx 7 KB
- Organize and Protect an Excel Workbook.xlsx 7 KB
- Productivity and Formula Auditing in Excel.xlsx 7 KB
Advanced12
- Dynamic Array Formulas in Excel: FILTER, SORT and UNIQUE.xlsx 7 KB
- Cleaner Formulas with LET in Excel.xlsx 7 KB
- Advanced Lookups in Excel: Multiple Criteria and Approximate Match.xlsx 7 KB
- Designing an Excel Dashboard.xlsx 9 KB
- Advanced PivotTables in Excel.xlsx 7 KB
- Power Query Basics: Combine and Clean Data in Excel.xlsx 8 KB
- Excel Data Model and Power Pivot Basics.xlsx 7 KB
- What-If Analysis in Excel: Goal Seek, Scenarios and Data Tables.xlsx 7 KB
- Workbook Architecture: Structuring Excel Models.xlsx 7 KB
- Error Checking and Controls in Excel.xlsx 7 KB
- Making Excel Workbooks Faster and Easier to Maintain.xlsx 7 KB
- How to Record a Macro in Excel.xlsx 7 KB
Expert12
- Reusable Formulas with LAMBDA and Dynamic Arrays.xlsx 7 KB
- Building Interactive Dashboards in Excel.xlsx 9 KB
- Power Query Engineering: Parameters, Staging and Refresh.xlsx 7 KB
- Data Modeling and DAX Measures in Excel.xlsx 7 KB
- Solver, Forecasting and Statistics Tools in Excel.xlsx 7 KB
- Planning an Excel Solution: Requirements and Design.xlsx 7 KB
- Testing Excel Models and Keeping Audit Trails.xlsx 7 KB
- Excel Performance at Scale.xlsx 7 KB
- Securing and Deploying Excel Workbooks.xlsx 7 KB
- Excel Capstone Project: Build a Complete Solution.xlsx 7 KB
- Automating Excel with VBA.xlsx 7 KB
- Office Scripts and Power Automate for Excel.xlsx 7 KB
PowerPoint
Slide templates and practice decks for the PowerPoint tutorials.
PowerPoint templates are on the way
We're preparing slide templates to go with the PowerPoint tutorials. Until then, these lessons show you how to set up a reusable theme and template of your own.
More apps
Resources for Word and Google Workspace apps will be added here as their tutorials go live.
WordGoogle SheetsGoogle DocsGoogle Slides