Shopping Cart
Current Status
Not Enrolled
Price
R1350
Get Started

MS Excel Intermediate Course

This MS Excel course builds on the Basic Functions and Formulas covered in our Beginner Course and introduces new concepts that will take your skills to the next level.

Course Length: 55 Lessons | 5.5 Hours of Videos.

Total course duration: 8 to 10 hours

Skills Level: To take this course, we recommend that you have completed our Excel Beginner Course or you are familiar with the Beginner course content.

Course Content

Introduction
Section 1 - A Quick Test
Section 2 - Key Essentials
Section 3 - Non Standard Series Generation
Section 4 - Advanced Copy and Paste
Section 5 - Formulas
Section 6 - Cell Referencing
Section 7 - Rounding
Section 8 - View Optimisation
Section 9 - Find and Replace
Section 10 - Sort and Filter
Section 11 - Graphs
Section 12 - Conditional Formatting
Section 13 - Ranges vs. Tables
Section 14 - Pivot Tables
Section 15 - VLOOKUP
Section 16 - Data Manipulation
Section 17 - Wrap up Exercises
Section 18 - Course Evaluation

MS Excel Advanced Course

R 1,550

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 1,150

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks