Download Sample Files
Every practice file from my YouTube tutorials, newest first. Type the code from the video description (like EC0076) or a word from the title.
Code | Tutorial | File |
|---|---|---|
EC0080 | 99% of Excel Users Don’t Know These 7 Shortcuts | |
EC0079 | 7 Mind-Blowing Excel Formulas I Wish I’d Learned Sooner | |
EC0078 | I Stopped Copy-Pasting Between Excel Sheets (Found This) | |
EC0077 | 10 Excel Formula Symbols You Wish You Knew years Ago | |
EC0076 | This Hidden Userform is an Ultimate Excel Trick | |
EC0075 | This is Excel's New Feature (Lists) | |
EC0074 | 10 Excel Tricks I Wish I Knew Before | |
EC0073 | 7 Pivot Table Tricks I Wish I Knew Sooner | Excel | |
EC0072 | This Excel Trick is A Game Changer | Tables | |
EC0071 | These 7 Rarest Excel Keyboard Shortcuts Will Blow Your Mind | |
EC0070 | 3 Mind Blowing Excel Tricks I Wish I Knew Years Ago | |
EC0069 | Report Connections in Pivot Table | |
EC0068 | XLOOKUP Tricks | |
EC0067 | 5 Excel Tricks I Bet You Don't Know | |
EC0066 | XLOOKUP(1) for Case Sensitive Match | |
EC0065 | Excel # Hash Operator | |
EC0064 | Excel DOT Operator | |
EC0063 | REGEX Excel Trick | |
EC0062 | This Mind Blowing Excel Trick is Still Hidden | |
EC0061 | This Secret Excel Trick is a Game Changer | |
EC0060 | Master Pivot Tables in Excel | |
EC0059 | 10 Mind Blowing Excel Tricks I Wish I Knew Earlier | |
EC0058 | I Stopped Using XLOOKUP After Discovering This (You Should Too) | |
EC0057 | AI Dashboard | |
EC0056 | Power Query Masterclass | |
EC0055 | Excel Automation | |
EC0054 | Excel Formula Course | |
EC0053 | These 10 Modern Excel Formulas Will Make You a Power User | |
EC0052 | Why It's Super Easy to Build Fully Automated Excel Userform | |
EC0051 | Build this Stunning Excel Dashboard in 3 Steps (File Included) | |
EC0050 | Claude in Excel (Workbook + Prompts) | |
EC0049 | Checkboxes to Filter | |
EC0048 | ChatGPT with Excel | |
EC0047 | Highlight Table Code | |
EC0046 | Multi Selection Drop Downs | |
EC0046 | Code To Highlight Tables: MAX & MIN | |
EC0045 | Checkboxes to Filter Inventory Data | |
EC0044 | Get Max Values using a Condition | |
EC0043 | Get the EXACT MATCH LOOKUP with XLOOKUP (CASE Sensitive) | |
EC0041 | Get Unique Values from Multiple Ranges | |
EC0039 | Combine Values in Excel Based on a Condition | |
EC0038 | Remove Duplicates from within a Cell | |
EC0036 | STOP using SUBSTITUTE to Replace Values, Move to This NEW Function | |
EC0034 | Free Course: Getting Started with Co-Pilot in Excel | |
EC0031 | Add Conditional Ranking in Excel | |
EC0030 | Average Last N Non Blank Cells Excluding the Current Day | |
EC0029 | Use this "POWERFUL" Formula to Count Sales Target-Achievement in Excel | |
EC0026 | Super Method to Split Data into Worksheets in Excel (Save Hours) | |
EC0025 | Extract Outlook Emails to Excel | |
EC0024 | Sum Values based on Years | |
EC0023 | 30 Excel Tips in 15 Minutes | |
EC0022 | XLOOKUP Can't Return All Matches | |
EC0021 | Combine Multiple Columns into Single Column | |
EC0020 | Pivot from Multiple Tables or Worksheets | |
EC0019 | Compare Two Tables with Power Query | |
EC0018 | Top 10 / Bottom 10 Chart with ONE Powerful Formula | |
EC0017 | An Awesome Animated Line Chart | |
EC0016 | 7 Excel Tips that You Can't Afford to Miss in 2025 | |
EC0015 | Count Cells with Bold, Italic, Underlined, and Strikethrough | |
EC0014 | Perform VLOOKUP in Power Query | |
EC0013 | Connect Google Drive File with Excel Workbook using Power Query | |
EC0012 | 7 Game-Changer Excel Functions | |
EC0011 | DGET Function in Excel | |
EC0010 | VBA to Create PIVOT Tables | |
EC0009 | Rename Files in Folder | |
EC0008 | Count Colored Cells in Excel | |
EC0007 | Create a Star Rating System in Excel (With Ready Template) | |
EC0006 | Split Data into Multiple Worksheets | |
EC0005 | Create a Waffle Chart in Excel | |
EC0004 | VBA Code to Auto Sort Data in Excel | |
EC0003 | Ratio Chart in Excel | |
EC0002 | Animated Toggle Button in Excel | |
EC0001 | Create Multiple Folders, Workbooks, and Worksheets |