FREE EXCEL VBA TUTORIALS FROM TIGER

Use the below index to help you navigate the free Excel (VBA) tutorial content on the website.

Each article is listed below.  Just click the link (eg. 'Article 1') to go to the article.

The articles come with videos, text-based explanations and download files.  Use them to build your skills and confidence in Excel, and as an ongoing reference through your career.

Article 165

4 Ways To Get Better At Excel Today! (THE EXCEL METASKILLS)

Article 164

Excel VBA To Move Data Between Files (BEGINNER TO PRO) Part 1/2

Article 163

STOP PAYING! Use EXCEL Instead For These 7 Software Tasks

Article 162

Excel Forms Beginner Tutorial

Article 161

MIC'D UP: EXCEL DEVELOPER TAKES ON THE EXCEL WORLD CUP

Article 160

THE 5 LEVELS OF EXCEL AUTOMATION

Article 159

How To Automate Powerpoint Creation With Excel VBA (INSTANT PRESENTATIONS!)

Article 158

Excel Office Script for Beginners - Part 3 of 3: Create A Loop In Excel Office Script

Article 157

Excel Office Script for Beginners - Part 2 of 3: Manipulate Cells With Office Script

Article 156

EXCEL VBA MASTER TIP: The Best Way To Copy / Paste Data From One Sheet To Another In Excel?

Article 155

Stop Obsessing Over Excel Formulas! YOU'RE MISSING THIS ...

Article 154

Excel VBA To Copy Data From One File To Another (BEGINNER TO PRO!)

Article 153

Don't Copy / Paste Data In Excel! Use These 5 Alternatives Instead ...

Article 152

Excel VLOOKUP Formula For Beginners

Article 151

Excel Dashboards For Beginners

Article 150

25 Powerful Excel VBA Techniques For 2025

Article 149

The Excel Mistake That KILLS Small Businesses

Article 148

Excel Office Script For Beginners (AND VBA ADDICTS!) Part 1/3

Article 147

3 Excel Calamities (FROM THE TIMES!) And How To Avoid Them

Article 146

RIP: MY EXCEL VBA CAREER (2008-2024)

Article 145

AVOID This Excel Formatting Mistake (DO THIS INSTEAD!)

Article 144

INSANELY Simple Excel Formatting Trick That Works EVERY Time

Article 143

THE ONE FORMULA I WISH EXCEL HAD (+How To Build It Yourself!)

Article 142

The 30 Excel Formulae You Must Know In 2024 (1-HOUR MASTERCLASS!)

Article 141

Power Automate For BEGINNERS

Article 140

Learn Macros In 19 Minutes (Microsoft Excel)

Article 139

Learn Excel's BEST Automation Tool In 15 Minutes!

Article 138

Become An Excel Analyst In 30 Days (COMPLETE COURSE!)

Article 137

Learn The Easy Way To Transfer Data With Excel VBA In Around 5 Minutes! (WITH DOWNLOAD FILES)

Article 136

How To Do What VLOOKUP Can't Do With OFFSET and MATCH

Article 135

How To Categorise Numbers In Excel Using VLOOKUP

Article 134

When You SHOULD Use INDIRECT

Article 133
How To Remove Spaces in Excel (When TRIM Doesn’t Work!)

Article 132
Complete Manual Excel Tasks In Seconds With THIS Excel Formula

Article 131
Learn This Powerful Excel Formula Combination In Just 5 Minutes!

Article 130
How To Model Winning And Losing Streaks In Excel

Article 129
Beyond the macro recorder

Article 128
Why Short Excel Formulae Are Better Than Long Excel Formulae (WITH PRACTICAL DEMO)

Article 127
17 Excel Beginner Formatting Mistakes (AND HOW TO FIX THEM!)

Article 126
How To Format Your Excel Spreadsheet Quickly And Professionally With 26 Excel Keyboard Shortcuts

Article 125
Excel Conditional Formatting Tutorial (FROM BEGINNER TO PRO!)

Article 124
How Excel Knows If You're Working On Mac Or PC

Article 123
14 MORE Excel Formatting Tips (Make Excel Beautiful AGAIN)

Article 122
Excel's Most Powerful Data Analysis Formula Explained In 5 Minutes

Article 121
How To Use Conditional (IF) Statements In Excel VBA (Real-World VBA Task S3 P6)

Article 120
Get Started With Position Control In Excel VBA (Real-World VBA Task S3 P5)

Article 119
How To Combine Two Loop Types In Excel VBA (Real-World VBA Task S3 P4) 

Article 118
How To Build A Loop Within Loop In Excel VBA (Real-World VBA Task S3 P3)

Article 117
How To Build A Loop In Excel VBA (Real-World VBA Task S3 P2)

Article 116
How To Start An Excel VBA Macro (Real-World VBA Task S3 P1)

Article 115
How To Analyse Goal Distribution In Excel (BEGINNER EXCEL DATA ANALYSIS!)

Article 114
3 Alternatives To SUBTOTAL To Analyse Football Data In Excel (PLEASE STOP!)

Article 113
Complete Guide To Excel For Football Traders

Article 112
Two-Hour Excel VBA Absolute Beginner Course (Part 3/2)

Article 111
Two-Hour Excel VBA Absolute Beginner Course (Part 2/2)

Article 110
Two-Hour Excel VBA Absolute Beginner Course (Part 1/2)

Article 109
Why I Don't Use Excel Tables

Article 108
Don’t Just Use =AVERAGE In Your Excel Data Analysis! Do This Instead

Article 107
14 Excel Formatting Tips (Make Excel BEAUTIFUL!)

Article 106
How To Automate VLOOKUP With Excel VBA

Article 105
Can We Get Excel To Play Chess With Excel VBA? (INFINITY PROJECT)

Article 104
How To Analyse Bitcoin ($BTC) Price In Excel

Article 103
10 Ways My Excel VBA Has Improved In 10 Years (BEGINNER TO PRO!)

Article 102
Make Excel VBA Loops EASY With The Loop Blueprints (MM LITE #5)

Article 101
Excel VBA Arrays For Beginners

Article 100
The 3 Excel Superpowers

Article 99
Even Beginners Can Learn Loops In Excel VBA ... (MM LITE #4)

Article 98

The Only 3 IF Statements You Need In Excel VBA - Excel VBA Beginner Fundamentals (6/6)


Article 97

Beginner Survival Guide To Working With Dates And Times In Excel

Article 96

Create An Excel Combo Chart In 7 Easy Steps (MM LITE #3)

Article 95

My No1 Excel VBA Technique Explained In 10 Minutes 


Article 94

The BEST Way To Move Sheets Between Files In Excel (MM LITE #2) 


Article 93

Master Excel's 11 Logical Formulae

Article 92

How To Create A Loop Within A Loop In Excel VBA (MM LITE #1)

Article 91

I Tried To Learn 500 Excel Formulae


Article 90

Get Started With Loops In Excel VBA- For each object in a collection 


Article 89

Beginner Introduction To Variables In Excel VBA


Article 88

10 Popular Excel Formulae: OVERRATED / UNDERRATED? 


Article 87

How To Work With Cells With Excel VBA

Article 86

Excel VBA Beginner Fundamentals


Article 85

10 Excel Formula Building Tips (Windows PC)


Article 84

7 Useful Excel Formulae You've Never Heard Of

Article 83

What's The Best Excel Chart For Beginners?


Article 82

Excel Data Analysis For Beginners: Learn This Formula FIRST

Article 81

Why I Don't Use Pivot Tables In Excel

Article 80

The ONE Excel Beginner Formula That Does ALL This


Article 79

The 72 Things You Need To Know In Excel In 7 Minutes 2 Seconds 


Article 78

Let's Fix 5 Shocking Excel Pie Charts (SAVE A FRIEND!)


Article 77

Should You Learn Excel VBA In 2021? 
7 Questions To Answer 


Article 76

Excel VBA To Copy Data From One Sheet To Another
(BEGINNER TO PRO!)

Article 75

XLOOKUP For Beginners
(And Why I'm Sceptical About New Excel Formulae ...)

Article 74

Can’t Do Data Analysis In Excel? Just Do This!

Article 73

Make Your Excel Data Chartable With This EPIC Excel Formula

Article 72

Replace Excel Filtering ... With An Excel FORMULA?

Article 71

The Best Alternative To Excel Filters?

Article 70

Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...

Article 69

How To Validate Userform Inputs With Excel VBA

Article 68

3 Ways To Insert A Reference No. Using An Excel Userform

Article 67

3 Excel Data Analysis Techniques You Should Be Using

Article 66

Excel VBA For Beginners: 30 Real-World Problems And Solutions


Article 65

How To Make Money From Excel


Article 64

Excel VBA Absolute Beginner Course 30 For 30


Article 63

Excel VBA Position Control Mastery


Article 62

9 Reasons (NOT) To Do An MBA

Article 61

Suffering From Excel Ennui? Why It's Not (All) Your Fault

Article 60

How To Use Excel VBA Code – Real Example S2

Article 59

How To Get Better At Excel: The Excel Meta skills

Article 58

Excel Dashboards For Beginners

Article 57

7 Essential Excel VBA Beginner Techniques

Article 56

17 Things You Must Know About The Excel VBA Editor


Article 55

How to Change Grades to Numbers in Excel


Article 54

How To Match A Number To A Range in Excel


Article 53

How To Use Excel VBA Code – Real Example


Article 52

Excel Indirect Function Tutorial


Article 51

Excel Data Table Tutorial


Article 50

Excel VBA to Move Data Around a File – My Approach


Article 49

Your Weird Skillset is Your Best Asset


Article 48

.Cells For Beginners


Article 47

Your First Pivot Table


Article 46

19 Excel Beginner Shortcuts for 2019


Article 45

Understand an Excel File in 3 Steps


Article 44

Most Important Skill in Excel VBA


Article 43

VLOOKUP Formula Problems / Fixes


Article 42

Excel VBA to Copy Data to Sheets


Article 41

Excel Frequency Formula: Common Problems / Fixes


Article 40

Excel VBA to Convert Minutes to Decimals


Article 39

What are Excel VBA Variables?


Article 38

Use Excel VBA to Separate Worksheets to Files


Article 37

Working with Excel VBA Message Boxes


Article 36

Excel VBA IF Conditional Statements for Beginners


Article 35

Excel Learning Tips: My Story


Article 34

Excel Database Formulae For Beginners


Article 33

Spreadsheet Skunkworks! Excel VBA Chess Challenge


Article 32

Excel Userforms for Beginners


Article 31

Use Excel VBA to Create Spin Buttons – Really Precisely!


Article 30

Use Excel VBA to Create Buttons For Super Fast Data Input!


Article 29

How to Collate Sports Fixtures Results into a League Table in Excel


Article 28

Excel Custom Navigation: Excel VBA for Beginners


Article 27

Excel Game – Do You Know the Offside Rule?!


Article 26

Rich Picturing: Six Tips for Getting Started


Article 25

Excel VBA for Beginners – Use Excel VBA to Cleanse a Dataset


Article 24

Excel Offset Function – Give It Some Love!


Article 23

Excel Visual Basic (VBA) for Post-Beginners


Article 22

Generate Random Data in Excel


Article 21

Combining VLOOKUP and MATCH


Article 20

Dynamic Dropdown Menus in Excel


Article 19

Excel for Teachers: Create A Student Progress Tracker


Article 18

Excel Visual Basic (VBA) for Beginners


Article 17

Create A League Table in an Excel Spreadsheet


Article 16

What is Excel Spreadsheet Development?


Article 15

Rank Things and Create A League Table in Excel


Article 14

Finding Things in Lists of Data in Excel


Article 13

#ExcelRevolution Manifesto


Article 12

Cool Excel Formatting: Font Size and Colour


Article 11

#ExcelRevolution Introduction


Article 10

Combining MATCH and OFFSET


Article 9

Cool Excel Formulae: COUNTIF


Article 8

Cool Excel Formatting: Dynamic Headers


Article 7

Cool Excel Formulae: IF


Article 6

Cool Excel Formatting: Cell Borders


Article 5

Cool Excel Formulae: VLOOKUP


Article 4

Cool Excel Formulae: MATCH


Article 3

Cool Excel Formulae: OFFSET


Article 2

Cool Excel Formulae: COUNTA


Article 1

Cool Excel Formulae: IFERROR