Excel MBA

Course Curriculum

  • 1
    Getting Started
    • Welcome To The Excel MBA
  • 2
    Beginner Excel
    • Introduction to Beginner to Intermediate Excel 2016
    • Module 1 Practice Workbook
    • 1. Navigating in Excel
    • 2. Entering Information
    • 3. Navigating without the mouse
    • 4. Basic Formatting
    • 5. Dragging & Autofill
    • 6. Copy & Paste
    • 7. Clearing Cells
    • 8. Inserting & Deleting
    • 9. Date Basics
    • 10. Introduction to Formulas
    • 11. Introduction to Formulas: Part 2
    • 12. Introduction to Formulas: Autosum
  • 3
    Intermediate Excel
    • The 80:20 principle
    • Finding Information: VLOOKUP
    • Rule building with IF
    • Working with Text
    • Text Functions: PROPER, TRIM & CLEAN
    • Text Functions: LEN & SEARCH
    • Introduction to Summarising
    • Summing
  • 4
    Advanced Excel & Intro To VBA
    • Introduction to Array Formulas
    • Introduction to VBA & Macros
    • 1. Cells and Ranges
    • 2. Copy and Paste
    • 3. Controlling Fonts and Colouring Cells
    • 4. Multiple Lines, Clearing and Column Widths
    • 5. Building Logic with IF
    • 6. Building Logic with Select Case
  • 5
    Data: Pivot Tables, Power Query & PowerPivot
    • Introduction To Pivot Tables
    • Workbook for Pivot Tables Lessons
    • Introduction to Pivot Tables
    • Pivot Cache
    • Alltering the Data Source
    • Summarise Value By
    • What is Power Query
    • Unpivot Data To A Long Boring List
    • Turning useless Data into something useful
    • Combining Data with a join
    • Introduction to PowerPivot
    • Importing Data in to PowerPivot
    • Create your first Data Model
  • 6
    Career, Mindset & Productivity Insights Of A Six-Figure Professional
    • Managing Your career in the 21st Century
    • How Excel fits in with your overall career
    • See my Salary over my career and how Excel skills improved it
    • Excel careers that can earn you a six figure salary
    • Interviews: Three things you MUST do
    • How Value Networking will define your success
    • Why Motivation will kill your success
    • A System for Growth of the ‘You’ Business

* We will only ever email you about this training, other other free lessons and our premium training