Shopping Cart
Current Status
Not Enrolled
Price
R1150
Get Started

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.

Course Content

Introduction
Section 1 - Excel Overview
Section 2 - Key Essentials
Section 3 - Data Input
Section 4 - Autofill
Section 5 - Formatting Cells
Section 6 - Formatting Worksheets
Task 1
Section 7 - Number Formatting
Section 8 - Formulas
Section 9 - Printing
Task 2 - Stationary Invoice
Section 10 - Sort and Filter
Section 11 - Data Visualisation
Section 12 - Excels Golden Rules
Section 13 - Pivot Tables
Section 14 - 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