Free Excel (VBA) Tutorials
- Buy now
- Learn more
Become An Excel Analyst In 30 Days (COMPLETE COURSE!)

4 Ways To Get Better At Excel Today! (THE EXCEL METASKILLS)
How Do Companies ACTUALLY Use Excel In 2023?
Excel Simplified: The Things You NEED To Know In Excel (and what you can ignore)
How To Collect Data With Excel In 2023 (Without Annoying Your Coworkers!)
Power Query For Beginners
STOP Fixing Data In Excel! START Using Excel Data Validation Like A Pro ...
Top 10 Excel Formulae For Cleansing Your Data QUICKLY And EFFICENTLY In Excel
How To Do A Basic Data Analysis In Excel (CHART INCLUDED!)
My QUICK And EASY Method For Building An Interactive Dashboard In Excel
Why You Should Learn Excel’s Data Analysis Formulae (EXCEL PIVOT TABLE ALTERNATIVE!)
How To Create BEAUTIFUL Charts In Excel
What's An Excel 'Model'? (AND 5 EXCEL MODEL-BUILDING FORMULAE!)
The Secret To Smooth Formula-Building In Excel (EXCEL MODELLING FOR BEGINNERS!)
Build This BEGINNER EXCEL MODEL With Me In Around 15 Minutes!
How To Create BEAUTIFUL Visualisations For Excel Models
THE BASICS OF EXCEL VBA EXPLAINED (For Beginners!)
Frustrated With Recorded Macros In Excel VBA? HERE'S HOW TO IMPROVE THEM
5 ESSENTIAL Excel VBA Beginner Techniques
How Automate Manual Work In Excel With Loops In Excel VBA
How To Generate UNLIMITED Random Data In Excel (CLICK OF A BUTTON!)
SAVE TIME IN EXCEL With These 23 Excel Keyboard Shortcuts (WINDOWS PC)
5 Formatting Principles For Better Excel Spreadsheets
4 Worksheets To Include In ALL Your Excel Files (GENERIC EXCEL SHEET ROLES!)
What's The Difference Between An ANALYST And A CONSULTANT? And Why Does It Matter For YOUR Career?
4 NON-EXCEL Tools To Help You Create Better Spreadsheets
How Can DRAWING Help You Create Better Excel Spreadsheets?
How Should You Manage An Excel Development Project? (4 STEPS!)
How To Make Excel Your Career (IN FOUR STEPS!)
Can You Become An Excel Analyst In 30 Days? (COURSE OVERVIEW)
Articles topics

EXCEL VBA MASTER TIP: The Best Way To Copy / Paste Data From One Sheet To Another In Excel?
Stop Obsessing Over Excel Formulas! YOU'RE MISSING THIS ...
Excel VBA To Copy Data From One File To Another (BEGINNER TO PRO!)
Don't Copy / Paste Data In Excel! Use These 5 Alternatives Instead ...
Excel VLOOKUP Formula For Beginners
Excel Dashboards For Beginners
25 Powerful Excel VBA Techniques For 2025
The Excel Mistake That KILLS Small Businesses
Excel Office Script For Beginners (AND VBA ADDICTS!) Part 1/3
3 Excel Calamities (FROM THE TIMES!) And How To Avoid Them
RIP: MY EXCEL VBA CAREER (2008-2024)
AVOID This Excel Formatting Mistake (DO THIS INSTEAD!)
INSANELY Simple Excel Formatting Trick That Works EVERY Time
THE ONE FORMULA I WISH EXCEL HAD (+How To Build It Yourself!)
The 30 Excel Formulae You Must Know In 2024 (1-HOUR MASTERCLASS!)
Power Automate For BEGINNERS
Learn Macros In 19 Minutes (Microsoft Excel)
Learn Excel's BEST Automation Tool In 15 Minutes!
Learn The Easy Way To Transfer Data With Excel VBA In Around 5 Minutes! (WITH DOWNLOAD FILES)
How To Do What VLOOKUP Can't Do With OFFSET and MATCH
How To Categorise Numbers In Excel Using VLOOKUP
When You SHOULD Use INDIRECT
How To Remove Spaces in Excel (When TRIM Doesn’t Work!)
Complete Manual Excel Tasks In Seconds With THIS Excel Formula
Learn This Powerful Excel Formula Combination In Just 5 Minutes!
How To Model Winning And Losing Streaks In Excel
BEYOND THE MACRO RECORDER
Why Short Excel Formulae Are Better Than Long Excel Formulae (WITH PRACTICAL DEMO)
17 Excel Beginner Formatting Mistakes (AND HOW TO FIX THEM!)
How To Format Your Excel Spreadsheet Quickly And Professionally With 26 Excel Keyboard Shortcuts
Excel Conditional Formatting Tutorial (FROM BEGINNER TO PRO!)
How Excel Knows If You're Working On Mac Or PC
14 MORE Excel Formatting Tips (Make Excel Beautiful AGAIN)
Excel's Most Powerful Data Analysis Formula Explained In 5 Minutes
How To Use Conditional (IF) Statements In Excel VBA (Real-World VBA Task S3 P6)
Get Started With Position Control In Excel VBA (Real-World VBA Task S3 P5)
How To Combine Two Loop Types In Excel VBA (Real-World VBA Task S3 P4)
How To Build A Loop Within Loop In Excel VBA (Real-World VBA Task S3 P3)
How To Build A Loop In Excel VBA (Real-World VBA Task S3 P2)
How To Start An Excel VBA Macro (Real-World VBA Task S3 P1)
How To Analyse Goal Distribution In Excel (BEGINNER EXCEL DATA ANALYSIS!)
3 Alternatives To SUBTOTAL To Analyse Football Data In Excel (PLEASE STOP!)
Complete Guide To Excel For Football Traders
Why I Don't Use Excel Tables
Don’t Just Use =AVERAGE In Your Excel Data Analysis! Do This Instead
14 Excel Formatting Tips (Make Excel BEAUTIFUL!)
How To Automate VLOOKUP With Excel VBA
Can We Get Excel To Play Chess With Excel VBA? (INFINITY PROJECT)
How To Analyse Bitcoin ($BTC) Price In Excel
10 Ways My Excel VBA Has Improved In 10 Years (BEGINNER TO PRO!)
Make Excel VBA Loops EASY With The Loop Blueprints (MM LITE #5)
Excel VBA Arrays For Beginners
The 3 Excel Superpowers
Even Beginners Can Learn Loops In Excel VBA ... (MM LITE #4)
The Only 3 IF Statements You Need In Excel VBA - Excel VBA Beginner Fundamentals (6/6)
Beginner Survival Guide To Working With Dates And Times In Excel
Create An Excel Combo Chart In 7 Easy Steps (MM LITE #3)
My No1 Excel VBA Technique Explained In 10 Minutes
The BEST Way To Move Sheets Between Files In Excel (MM LITE #2)
Master Excel's 11 Logical Formulae
How To Create A Loop Within A Loop In Excel VBA (MM LITE #1)
I Tried To Learn 500 Excel Formulae
Get Started With Loops In Excel VBA
Beginner Introduction To Variables In Excel VBA
10 Popular Excel Formulae: OVERRATED / UNDERRATED?
How To Work With Cells With Excel VBA
Excel VBA Beginner Fundamentals
10 Excel Formula Building Tips (Windows PC)
7 Useful Excel Formulae You've Never Heard Of
What's The Best Excel Chart For Beginners?
Excel Data Analysis For Beginners: Learn This Formula FIRST
Why I Don't Use Pivot Tables In Excel
The ONE Excel Beginner Formula That Does ALL This
The 72 Things You Need To Know In Excel In 7 Minutes 2 Seconds
Let's Fix 5 Shocking Excel Pie Charts (SAVE A FRIEND!)
Should You Learn Excel VBA In 2021? 7 Questions To Answer
Excel VBA To Copy Data From One Sheet To Another (BEGINNER TO PRO!)
XLOOKUP For Beginners (And Why I'm Sceptical About New Excel Formulae ...)
Can’t Do Data Analysis In Excel? Just Do This!
Make Your Excel Data Chartable With This EPIC Excel Formula
Replace Excel Filtering ... With An Excel FORMULA?
The Best Alternative To Excel Filters?
Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...
How To Validate Userform Inputs With Excel VBA
3 Ways To Insert A Reference No. Using An Excel Userform
3 Excel Data Analysis Techniques You Should Be Using
Excel VBA For Beginners: 30 Real World Problems And Solutions
How To Make Money From Excel
Excel VBA Absolute Beginner Course 30 For 30
Excel VBA Position Control Mastery
9 Reasons (NOT) To Do An MBA
Suffering From Excel Ennui? Why It's Not (All) Your Fault
How To Use Excel VBA Code – Real Example S2
How To Get Better At Excel: The Excel Metaskills
Excel Dashboards For Beginners
7 Essential Excel VBA Beginner Techniques
17 Things You Must Know About The Excel VBA Editor
How to Change Grades to Numbers in Excel
How To Match A Number To A Range in Excel
How To Use Excel VBA Code – Real Example
Excel Indirect Function Tutorial
Excel Data Table Tutorial
Excel VBA to Move Data Around a File – My Approach
Your Weird Skillset is Your Best Asset
.Cells For Beginners
Your First Pivot Table
19 Excel Beginner Shortcuts for 2019
Understand an Excel File in 3 Steps
Most Important Skill in Excel VBA
VLOOKUP Formula Problems / Fixes
Excel VBA to Copy Data to Sheets
Excel Frequency Formula: Common Problems / Fixes
Excel VBA to Convert Minutes to Decimals
What are Excel VBA Variables?
Use Excel VBA to Separate Worksheets to Files
Working with Excel VBA Message Boxes
Excel VBA IF Conditional Statements for Beginners
Excel Learning Tips: My Story
Excel Database Formulae For Beginners
Spreadsheet Skunkworks! Excel VBA Chess Challenge
Excel Userforms for Beginners
Use Excel VBA to Create Spin Buttons – Really Precisely!
Use Excel VBA to Create Buttons For Super Fast Data Input!
How to Collate Sports Fixtures Results into a League Table in Excel
Excel Custom Navigation: Excel VBA for Beginners
Excel Game – Do You Know the Offside Rule?!
Rich Picturing: Six Tips for Getting Started
Excel VBA for Beginners – Use Excel VBA to Cleanse a Dataset
Excel Offset Function – Give It Some Love!
Excel Visual Basic (VBA) for Post-Beginners
Generate Random Data in Excel
Combining VLOOKUP and MATCH
Dynamic Dropdown Menus in Excel
Excel for Teachers: Create A Student Progress Tracker
Excel Visual Basic (VBA) for Beginners
Create A League Table in an Excel Spreadsheet
What is Excel Spreadsheet Development?
Rank Things and Create A League Table in Excel
Finding Things in Lists of Data in Excel
#ExcelRevolution Manifesto
Cool Excel Formatting: Font Size and Colour
#ExcelRevolution Introduction
Combining MATCH and OFFSET
Cool Excel Formulae: COUNTIF
Cool Excel Formatting: Dynamic Headers
Cool Excel Formulae: IF
Cool Excel Formatting: Cell Borders
Cool Excel Formulae: VLOOKUP
Cool Excel Formulae: MATCH
Cool Excel Formulae: OFFSET
Cool Excel Formulae: COUNTA
Cool Excel Formulae: IFERROR

Cool Excel Formulae: OFFSET

Learn to save time, stress and impress your colleagues / classmates with the OFFSET formula. Practise!

Download the file used in the video here.