Shopping Cart

MS Excel Automation Course

Current Status
Not Enrolled
Price
R2150
Get Started

Course Overview

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.
4-Excel-Automation-800
Current Status
Not Enrolled
Price
R2150
Get Started

Course Content

Section 1 - Automation Introduction
Section 2 - Source-to-Report
Section 3 - Source-to-report - Recorded Macro
Section 4 - Source-to-Report - Power Query
Section 5 - Power Query Basics
Section 6 - The Transform Toolset
Section 7 - Different Data Sources
Section 8 - Matching Data
Section 9 - Power Pivot
Section 10 - Integrating with Word and Point
Section 11 - VBA
Section 12 - Course Evaluation

Want to learn more?

Receive our Excel tips and news to your inbox!

"*" indicates required fields

Choices*
This field is for validation purposes and should be left unchanged.

Request a Consultation

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