Advanced  Microsoft Excel Training Course

Become a Microsoft Excel Guru

Want to become an Excel Guru? Sign up for our MS Excel Advanced course.

From Goal Seek and Defined Names to Advanced Excel Formulas and Pivot tables, the objective of this course is to expose you to the many powerful advanced functions that Excel has to offer, as well as cover some key principles that ensure good practice while avoiding common pitfalls when working with data. Not forgetting all those useful tips and tricks to help maximize efficiencies and impress your colleagues!

 

View our Course calendar to see when our next Public Advanced MS Excel course will be held near you or contact us should you wish to organize Onsite training for the whole team.

Public Course: R1 990 per person

Corporate Course: from R13 250 per day

*Prices are exclusive of VAT

Comments from Attendees

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

- Devesh, Africa Sun Oil

“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

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

- Savahar, VNA Consulting

What you'll learn:

1-Day Advanced MS Excel Training Course 

Key Essentials Recap

  • Data Types default behaviour

  • Number façades & Auto-formats

Spreadsheet Integrity

  • Partial Dates

  • Formula Auditing

  • Empty cells vs Zero values

  • Excels Golden Rules

  • Running Totals

  • Audit Trails

  • Data Ranges

 

Cell References

  • Absolute - $A$2

  • Relative - A2

  • Mixed - $A2 or A$2

 

Forecasting

  • Goal Seek

 

CSV Import

  • Regional Settings

  • Import Wizards

  • Data Connections

Merging and Splitting Data

  • Basic Text Formula

  • Flash Fill

  • Text-to-Columns

Formula

  • Text - CONCAT, PROPER, UPPER, LEFT, RIGHT, MID, TRIM + Nested Formula

  • Logical - IF, IFERROR, AND, OR

  • Lookup – INDEX, MATCH plus the INDEX-MATCH lookup combination.

  • Using Defined Names and Tables

 

Data Validation & Worksheet Protection

  • Data Type Validation

  • In cell Dropdowns

  • Unlocking cells & Protecting Sheets

 

Pivot Tables & Charts

  • Pivot Table basics recap

  • Pivot Table Layout & Design

  • Filters, Slicers and Timelines

  • Value Field Settings & Calculated Values

  • Multiple Pivot Dashboards

Excel Automation Intro

  • Recording a Macro

Not sure where to start ?

Make use of our Free 

Pre-Assessment. 

Public Courses

Gauteng: 08h30 - 16h30

KwaZulu Natal: 08h30 - 16h30

Sandton

  • ​22 Oct '20

Durban

  • 15 Oct '20

Pietermaritzburg

  • 08 Oct '20

Due to Covid-19, and the safety of our clients, we have postponed public training for August & September 2020, and will instead offer Online Training, with E-Classroom sessions, over this period.

Included in the course is a free Flash Drive that contains a follow along Excel Workbook with detailed notes on each Section. A tear-off summary Recap Sheet will help remind you of all the key concepts.

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions