Shopping Cart

Microsoft Excel Advanced Online Training

Summit-Solutions-Training-Excel-Advanced-Banner

Download Details

Price

R 1,550

Get Started

4.7/5

4.7/5

43 Reviews

Course Overview

Course Length: 79 Lessons | 7.5 hours of Videos.

Total course duration: 9 – 11 hours

Picking up from where the Intermediate Course left off, the objective of this course is to expose you to the many powerful advanced functions that Excel has to offer.

Topics covered include: Data Modelling, Advanced Formula, Pivot Table Dashboards, Data Validation and Automating processes… not forgetting all those useful tips and tricks to help maximize efficiencies and impress your colleagues!

Summit Solutions MS Excel Advanced Training Online Course

Course Content

Brief Recap on some Key Principles that are often overlooked such as the default behaviour of Text, Numbers & Dates, Auto-formats and Number façades.

Looking at all the key aspects to ensure Data Integrity. Using some neat Excel tools to check, troubleshoot, verify and validate data within your spreadsheet.

Points covered include: Verifying numerical content, Formula auditing, Empty cells vs Zero values, Excels Golden Rule, Running Totals, Audit Trails and Data Ranges.

The difference between Absolute, Relative and Mixed cell referencing. Using Mixed cell references to create a 2-dimentional formula array.
Using Goal Seek to take out the guess work of finding input values for a desired formula result.

Highlighting the importance of one’s current List Separator, Decimal symbol, Thousand Separator and Date formats when working with CSV files.

Explaining the difference between the New and Legacy Import Wizards within Excel and then using the Legacy Wizard to import a CSV file; highlighting the importance of the resultant Data Connection and how to use it to one’s advantage.

Using Formulas, Flash Fill and Text-to-Columns (Delimited and Fixed Width) to Split and Merge Data. Highlighting the pros and cons and when to use what.
Taking formulas to the next level…
  • Text Formulas
    Using Text Formulas to dynamically manipulate and extract data while introducing the concept of nested formulas. CONCAT, PROPER, UPPER, LEFT, RIGHT, MID & TRIM.
  • Date Formulas
    Understanding that Dates are – or should be – stored as a numerical value. This opens up a whole new world when working with Dates. Date Functions such as WEEKNUM, EOMONTH, TODAY and NETWORKDAYS help us to take this to the next level.
  • Logical Formulas
    Introduction to the AND & OR functions in conjunction with IF to cater for multiple conditions, as well as the use of IFERROR to hide known errors.
  • Lookup Formulas
    Explore the many different variations of the VLOOKUP function and their advantages and disadvantages. Plus, the introduction to INDEX-MATCH and the all new XLOOKUP as better alternatives to VLOOKUP.
  • Maths Formulas
    Taking your basic SUM and COUNT functions to the next level with SUMIF(S) and COUNTIF(S). Building 2-dimentional formula arrays with these functions to create Data Summary Tables. Comparing these to Pivot Tables and exploring the advantages and disadvantages of both.

Best methods to prevent incorrect data entry, including lookup lists and in cell dropdowns.

Includes a brief recap on Pivot Table basics and the Key Features and Layouts to be aware of.

Best Practices of creating multiple Pivot Tables and Charts off the same data and how to combine these into a multi-pivot Dashboard by linking Slicers and Timelines; plus a really neat trick on how best to add additional records to your source data.

Introduction to the timesaving world of Recording a Macro for repeatable tasks. A clear explanation of the different options available to save your Macro and some really clever Tips and Tricks to ensure that your Macro works on different datasets.

Over 50 Keyboard Shortcuts covered throughout the course to increase those efficiencies.
A printable 1-pager, of all these shortcuts and more, is provided with the follow-along Workbook.

What's Included?

  • A detailed follow-along Excel Workbook with Summary Notes
  • Self-marking quick questions to test your progress as you learn
  • Practical Tasks that will enable you to put your newly acquired Excel Skills into practice
  • Course completion Certificates
  • Lifetime access to course material and updates

Course Reviews

Absolutely brilliant! Learnt a lot in the advanced level Excel Course that I can use every day. Mark is excellent! Absolutely clear and concise training. Completely impactful.

REBECCA, KERRY GROUP

Very evenly spread of sections with time, compact & relevant. Mike has excellent communication skills, very fluent & audible. Great Impact!

DEVESH, AFRICA SUN OIL

Excellent course, content simple and easy to follow. Receiving the booklet with an exercise and flash drive with access to the course videos is very helpful.

SAEEDAH, IDP

Super detailed and extensive. Extremely informative and Valuable!! Highly informed on Excel!! Will definitely recommend Mark!

SAVAHAR, VNA CONSULTING

Brilliant and very worth it. Excellent teacher!!!

INGRID, RAYDIAN (PTY) LTD

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

This draw is closed. Keep checking back, for the next draw.