Excel Guidance Videos & Articles

Starting at £0/mo
Learn more Join now
Click PREVIEW below to view our library of free Excel learning resources comprising 100s of videos, download files and other resources.  WANT MORE? Check out our Membership plans (below) for unique communities, learning resources and exclusive sessions with Chris. Select our FREE blog membership to get email notifications of new articles and videos.
Chris Mortimer
Oct 11, 2021

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

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


Conditional statements allow us t...
No comments 2 likes Read post…
Chris Mortimer
Sep 10, 2021

Beginner Survival Guide To Working With Dates And Times In Excel

Beginner Survival Guide To Working With Dates And Times In Excel
For me, working with dates and times is the most frustra...
No comments 2 likes Read post…
Chris Mortimer
Sep 7, 2021

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

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

 
A combo chart is one of the coolest things in Excel: a visual t...
No comments 1 like Read post…
Chris Mortimer
Sep 3, 2021

My No1 Excel VBA Technique Explained In 10 Minutes

My No1 Excel VBA Technique Explained In 10 Minutes

 
Yes!  I’ve been looking forward to this one – a beginner Excel VBA tu...
No comments 1 like Read post…
Chris Mortimer
Aug 26, 2021

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

The BEST Way To Move Sheets Between Files In Excel (MM LITE #2)
 
Moving data between files is something people do in Exce...
No comments 1 like Read post…
Chris Mortimer
Aug 20, 2021

Master Excel's 11 Logical Formulae

Master Excel's 11 Logical Formulae


Yes, knowing more formulae doesn’t make you better at Excel.  The fact is that Excel ...
No comments 1 like Read post…
Chris Mortimer
Aug 10, 2021

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

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


How can Excel VBA help you do a typical manual task at the c...
No comments 1 like Read post…
Chris Mortimer
Aug 6, 2021

I Tried To Learn 500 Excel Formulae

I Tried To Learn 500 Excel Formulae (TAKE THE TEST!)


With the new Excel formula releases coming soon, there will be more ...
No comments 1 like Read post…
Chris Mortimer
Jul 30, 2021

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

Get Started With Loops In Excel VBA


Loops in Excel VBA are, quite simply, the best way of taking your coding to the next ...
No comments 1 like Read post…
Chris Mortimer
Jul 13, 2021

Beginner Introduction To Variables In Excel VBA

Beginner Introduction To Variables In Excel VBA


If you’re a beginner in Excel VBA, you may be wondering: What’s An Excel ...
No comments 2 likes Read post…