GET STARTED
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
Requirements:Â
- 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
Related Courses
Great instruction!
The course is well structured, good pace, good test review at end of each session.
Excellent
This course was good in dealing with formulas and how to apply them.