Please ensure Javascript is enabled for purposes of website accessibility

About This Course

Who this course is for:

  • Excel users
  • Accountants
  • Data analysts

What you’ll learn: 

  • The Formula Bootcamp: Excel beginners will learn the fundamental formulas and IF clauses to have a firm grip on Excel
  • Excel Text Manipulator: Know exactly how to manipulate any Excel text string
  • Excel Pro Formulas: Master the more complex excel functionalities which will completely transform your efficiency in Excel


  • No prior knowledge is required to take this course

Software version used in the course:

  • Microsoft Excel

What if you mastered Excel formulas to the point where you could create Investment Banking quality spreadsheets that are efficient, automated and easy to maintain?

Here’s the blunt truth: I can’t give you a magic pill to learn Excel overnight. What I can do is show you the fastest way to master formulas if you are willing to take action.

Instead of cramming useless Excel theory during 8 boring and confusing hours, why not apply the formulas that you will use on a daily basis whilst also have the spreadsheets in front of you?

This course will allow you to hack over 40 Excel Formulas. Take this course today and improve your Excel skills.

Our Promise to You

By the end of this course, you will have learned how to improve your Excel skills.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn how to improve your Excel skills!

Course Curriculum

2h 30m

Section 1 - Introduction To This Course
Welcome To This Course! 00:00:00
Quick Win: The Excel Shortcuts You Need To Know 00:00:00
Downloadable Resources 00:00:00
Section 2 - Introduction To Formulas - Syntax Basics
Introduction 00:00:00
Beginner’s Guide: Writing Simple Formulas In Excel 00:00:00
Master These 2 Essential Excel Functionalities 00:00:00
Ultimate Guide To Absolute & Relative Referencing 00:00:00
How To Make Sense Of Unfamiliar Formulas 00:00:00
ACTION: Section 2 Class Test 00:00:00
XLS: Section 2 Solution 00:00:00
Section 3 - Beginners' Guide To Excel Formulas
Introduction 00:00:00
Fundamental Excel Formatting Principles You Need To Know 00:00:00
How To Count & Perform Averages In Excel 00:00:00
Why You Should Use These 2 Variations Of Count 00:00:00
Understanding Minimum & Maximum Values 00:00:00
ACTION: Section 3 Class Test 00:00:00
XLS: Section 3 Solution 00:00:00
Section 4 - IF Functions & Variations
Introduction 00:00:00
The IF Function Blueprint 00:00:00
Use These 3 Operators To Add Variety To Your IF Clauses 00:00:00
Hack: Write & Understand Formulas Better By Using This Nifty Trick 00:00:00
Ultimate Guide To Using Nested IFs 00:00:00
Formula Combo: The 3 Formulas That Use IF Clauses 00:00:00
ACTION: Section 4 Class Test 00:00:00
XLS: Section 4 Solution 00:00:00
Section 5 - Excel Text String Manipulator
Introduction 00:00:00
Ensure Proper Text Formatting 00:00:00
The 2 Approaches To Joining Text Strings Together 00:00:00
Use These 4 Formulas To Extract Any Piece Of Text 00:00:00
Here’s How To Ensure Text Accuracy 00:00:00
ACTION: Section 5 Class Test 00:00:00
XLS: Section 5 Solution 00:00:00
Section 6 - The Ultimate Guide To LOOKUP Formulas
Introduction 00:00:00
The 2 Formulas To Search Horizontally OR Vertically In A Spreadsheet 00:00:00
Avoid These Most Common Lookup Mistakes 00:00:00
Here’s How To Approach Nested Lookups 00:00:00
Formula Combo: Using VLookup & Choose 00:00:00
The MATCH Function & Why I Use It All The Time 00:00:00
ACTION: Section 6 Class Test 00:00:00
XLS: Section 6 Solution 00:00:00
Section 7 - Advanced Excel Formulas
Introduction 00:00:00
Match + Index: The Formula Combo That Changed The Way I Worked In Excel 00:00:00
Using Indirect + Address For Accurate Data 00:00:00
The Ultimate Guide To 2 Way Lookups 00:00:00
A Guide To The SumProduct Formula 00:00:00
Dealing With Errors In Excel 00:00:00

Course Reviews


2 ratings
  1. Anonymous

    Great instruction!


    The course is well structured, good pace, good test review at end of each session.

  2. Anonymous



    This course was good in dealing with formulas and how to apply them.