Microsoft Excel: Beginner to Advanced

  • 14 - 15 hours
  • Magic Lantern

Course overview

Our Microsoft Excel bundle is designed to get you up to speed with everything there is to know about Excel, taking you from complete novice to Excel master. When signing up, you will get access to all three of our Microsoft Excel courses: Beginner, Intermediate and Advanced – inclusive of various useful tips and exercises. From basic formulas to solving complex business problems, these courses will equip you with practical, in-depth skills and knowledge to master Excel. If you are looking for an engaging, hands-on, and self-paced approach to learning all things Microsoft Excel, then this bundle is perfect for you.


  • Getting started on Excel
  • Working with formulas and functions
  • Formatting data and modifying worksheets
  • Inserting images, shapes and charts into worksheets
  • Printing a worksheet
  • Working with templates
  • Single- and multi-level data sorting
  • Apply built-in functions to perform calculations and return information about data lists.
  • Apply data validation and create validation lists.
  • Import and export data from and to text files.
  • Apply PivotTables to Excel worksheets.
  • Apply the Power Query tool to model and shape data.
  • Apply various tools to work with large sets of data.
  • Apply logical and mathematical functions.
  • Use Lookup and reference functions.
  • Apply text functions.
  • Understand and apply Excel’s auditing tools.
  • Understand and apply security and protection.
  • Navigate and apply Excel’s What-if Analysis and Solver tools.
  • Understand and use macros.

R 1 360.00

/ Learner

Are you ready to take your employees' training to the next level? Indicate how many employees you would like to enrol in this course, and we'll get back to you.

Estimated cost

R 0.00

Similar courses