Article Index - START HERE

Chris Mortimer
Nov 10, 2020

WELCOME TO THE ARTICLE INDEX


The purpose of this post is 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.

I would be very happy to answer your questions about any of the articles, just leave a comment below the post and I will get back to you there.

Have fun and let me know how you get on,
Chris

 

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
Like 11
aa aa
Dec 30, 2020
Hi Team, I noticed in the Excel Userforms for Beginners series Chris has an automatically updating and counting Reference column that increases automatically with each entry. Is there a tutorial or code you can provide for how to acomplish that? Thank you for all of your help!
Show 2 more...
Chris Mortimer
Jan 2, 2021
Great to hear and happy new year to you too!
Akif Kırış
May 3, 2021
Hi Chris, First, I want to thank you all. I have in chapter 11 of Excel Chess and error on the VLOOKUP line. Dia_Poss = Application.WorksheetFunction.VLookup(Piece_Name, Sheets("Engine").Range("E_Moves_Table"), 5, 0) (all codes are in one line) error is: Run-time error '1004' Unable to get the VLookup property of the WorksheetFunctions class What is wrong with code, I didn’t understand. (I have double checked so) Could you please help on?
Chris Mortimer
May 4, 2021
Hi there and thanks for the comment. With application.worksheetfunction, I always advise setting up the formula in the worksheet first. There is a problem with VLOOKUP which is likely to be Excel cannot find the value you are trying to look up in the table. Set up the formula in the worksheet to understand what the problem might be - good luck!
Bjarne Dreier
Mar 25, 2022
Hi Chris

I have become a bit rusty in Excel over the last 16 months, so I am a bit confused on how I should start this task.
The task is to "filter" to find combinations of Customer/Agent and if there are more then 3 occurrences of a combination, the print them in a new list, sorted with the most frequent first.
Which videos should I start with for inspiration?

The list looks like this

Customer  Agent
123            AB
123            AB
2134          BD
445            BP
123            AB
445            BP
445            BP
445            BP

So my output should like this

Customer  Agent  Occurrences
445            BP        4
123             AB        3

Please inspire me :)
Chris Mortimer
Mar 28, 2022
Hi Bjarne

- check out the =FILTER formula in Excel 365
- see videos on data analysis formulae
- see videos on custom report building with Excel VBA - but you might not need that
- see our 'stop filtering Excel' YouTube playlist

Good luck!

Chris