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