Beginner to Advanced Excel Expert

‘Find out how our students are gaining an unfair advantage at work with our Online Beginner To Advanced Excel Expert Course’

SIGN UP

About this course

Excel skills are no longer ‘optional’ at work so if you consider yourself a beginner or intermediate user of Excel this course will cut through the Excel overwhelm and confusion and have you producing work in Excel that will get you noticed by your line manager, colleagues and the executives in your company.

This is the only Excel course on the market purpose built to transform the Excel skills of corporate professionals or aspiring professionals including Analysts, Accountants, Controllers, PMO’s, Project Managers, Management Consultants And Other Corporate Professionals.

If that includes you then read on to find out how this course will transform your Excel skills.

WE DON’T TEACH YOU EXCEL THE WAY OTHER COURSES DO

Our course has beencarefully crafted by professionals who have spent decades solving hundreds of Excel related problems in dozens of global companies

From solving hundreds of Excel problems, we have seen that every business scenario needing Excel can be boiled down to three types problems (Storing Data, Analysis and Insights) and four possible ways to solve problems (Finding Information, Using Logic, Manipulating Text and Data Summary) aka our proprietary 4:3 Excel framework.

It’s within this framework that we will teach you the best way to use Formulas, Charts, Conditional Formatting, Pivot Tables, Shortcuts and Other Functions.

No longer will you be scrambling for random tips, ninja tricks and shortcuts. You can say goodbye to googling for answers to Excel questions after everyone else has gone home because your report is due in the morning.

This framework is a strategic Excel system that will guide you in your work and will have you producing outstanding quality analysis and reporting in a quick time frame.

What you get in this Training Course

  • 10 hours of training split in to 68 Video Lessons
  • 12 months of support from Excel experts via e-mails, discussions and VIDEO RESPONSES!
  • Compatible with Excel Office 365, Excel 2019/2016/2013/2010/2007
  • Download videos to your device and watch offline (see FAQ for more details)
  • Excel files with exercises that help you to learn the lessons with ease
  • Track your progress and take your own notes
  • Get a certificate of completion that you can display on LinkedIn
  • 30-day money back guarantee

Course Content

1. Navigating around Excel 2.17
2. Entering Information 2.58
3. Navigating without the Mouse 2.53
4. Basic Formatting 4.19
5. Dragging & Autofill 4.14
6. Copy & Paste 4.52
7. Clearing cells 2.26
8. Inserting & Deleting 4.12
9. Date Basics 2.57
10. Introduction to Formulas
11. Introduction to Formulas: Part 2 4.22
12. Introduction to Formulas: Autosum 2.25
13. More on Worksheets 6.36
14. More Borders 4.51
15. Printing considerations 6.31
16. Conditional Formatting 8.32
17. Charts 9.43
18. Autofilter 6.04
19. Sorting Data 2.16
20. Introduction to Text Data 3.57
21. Named Ranges 2.42
22. Data Validation 5.27
23. Advanced Data Formatting 5.25
1. The 80:20 principle & the paradox of choice 16.15
2. Introduction to Excel for professionals 7.59
3. Performance of Excel 4.37
4. Long boring lists 7.12
5. Long boring lists: Monthly Data 11.39
6. Small, Mid and Large Data sets 12.03
7. Locking down cells 6.13
8. Finding Information: VLOOKUP 19.46
9. Finding Information: INDEX & MATCH 20.2
10. OPTIONAL: Excel Tables & Slicers 6.43
1. Finding Information: Limit formulas 14.48
2. Getting Advanced with Lookups 15.4
3. Finding Information: putting it all together 17.5
4. Rule building with IF 13.38
5. More advanced logic building 17.37
1. Working with Text 5.33
2. Text Functions: PROPER, TRIM & CLEAN 5.31
3. Text Functions: LEN & SEARCH 7.18
4. Text Functions: LEFT, MID, RIGHT 2.23
5. Flash Fill 1.04
6. Text functions: Advanced Text analysis by building formulas 19.58
7. Text functions: Creating email addresses to build distribution lists 7.25
8. : Creating character and word count limits 6.43

4. SUBTOTAL function4.48

1. Introduction to summarising 2.32
2. Counting 13.52
3. Summing 14.01
5. Analysis walkthrough with summing and counting 5.58
6. Everything you need to know about Pivot Tables in under 15 minutes 14.48
7. Advanced list analysis: understanding Array formulas 11.58
8. OPTIONAL: Introduction to Array Formulas 18.05
9. OPTIONAL: Array Formulas for Multiple Criteria 6.44
10. OPTIONAL: Array Formulas for Multiple Occurrences 18.22
11. Advanced Modelling with Array formula lookups 10.00
12. Dashboard and reporting practice for professionals 12.52
13. Advanced Conditional formatting: Using formulas 21.12
14. Advanced Conditional formatting: Beyond Highlighting 11.27
1. Resource Analysis: Good practice for managing data 15.25
2. Dynamic Charts 15.36
3. Charting Actual vs Forecast 7.33
4. Segmenting for deeper MI 6.41
5. Meaningful Resource Analysis 8.55

SAMPLE LESSON

Here is a sample introductory VBA lesson