About This Course

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 including:

  • 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

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.

30 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

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
Section 2 - Introduction To Formulas - Syntax Basics
Introduction (Spreadsheet Attached) 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 (Spreadsheet Attached) 00:00:00
XLS: Section 2 Solution (Spreadsheet Attached) 00:00:00
Section 3 - Beginners' Guide To Excel Formulas
Introduction (Spreadsheet Attached) 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 (Spreadsheet Attached) 00:00:00
XLS: Section 3 Solution (Spreadsheet Attached) 00:00:00
Section 4 - IF Functions & Variations
Introduction (Spreadsheet Attached) 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 (Spreadsheet Attached) 00:00:00
XLS: Section 4 Solution (Spreadsheet Attached) 00:00:00
Section 5 - Excel Text String Manipulator
Introduction (Spreadsheet Attached) 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 (Spreadsheet Attached) 00:00:00
XLS: Section 5 Solution (Spreadsheet Attached) 00:00:00
Section 6 - The Ultimate Guide To LOOKUP Formulas
Introduction (Spreadsheet Attached) 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 (Spreadsheet Attached) 00:00:00
XLS: Section 6 Solution (Spreadsheet Attached) 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

5

5
2 ratings
  1. Great instruction!

    5

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

  2. Excellent

    5

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

Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel