Shopping Cart
4-Excel-Automation-800

MS Excel Automation Course

By combining Excels Advanced Tools of Power Query, Power Pivot and Macros (VBA), this course will expose you to the time saving world of Excel Automation. Course Length: 80 Lessons “The team are totally pumped at what they learnt and are already putting it into practice which is saving them hours if not days of […]

Summit Solutions MS Excel Advanced Training Online Course

MS Excel Advanced Course

From Goal Seek to Advanced Formulas to Pivot Tables and Recording a Macro, the objective of this course is to expose you to the many powerful Advanced Features that Excel has to offer, as well as cover some key principles that ensure good practice when working with data. Course Length: 79 Lessons | 7.5  Hours […]

Summit Solutions MS Excel Intermediate Training Online Course

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 […]

Summit Solutions MS Excel Beginner Training Online Course

MS Excel Beginner Course

Grasp the key components that make Excel tick, reduce your Excel frustrations and become a lot more efficient when working with Spreadsheets! Course Length: 56 Lessons | 4 Hours of Videos. Total course duration: 6 to 8 hours Skills Level: No prior knowledge of Excel is required, but a basic understanding of computers is expected.

MS Excel Foundation Course

This Course covers all the foundational skills that you need to Excel! Course Length: 17 Lessons | 2.5 Hours of Videos. Total course duration: 3 hours Skills Level: No Excel skills are required, but basic Keyboard and Mouse Skills will be needed.

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