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.

Course Cost: R1 990 (excl. VAT)

Comments from Attendees

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

 

- Savahar, VNA Consulting

“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 the summary of the course content is very helpful.”

 

- Saeedah, IDP

“Brilliant and very worth it. Excellent teacher!!!” 

 

- Ingrid, Raydian (Pty) ltd

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

  • Rounding

 

Cell references

  • Absolute - $A$2

  • Relative - A2

  • Mixed - $A2 or A$2

CSV Export and Import

  • Regional Settings

  • Import Wizards

  • Data Connections

Merging and Splitting Data

  • Basic Text Formula

  • Flash Fill

  • Text-to-Columns

Forecasting

  • Goal Seek

  • Solver (brief intro)

 

Formula

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

  • Logical - IF, IFERROR, AND, OR

  • Maths – SUM, COUNT, COUNTA, SUMIF, COUNTIF, SUMIFS, COUNTIFS

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

  • Defined Names

 

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

  • Pivots vs Formula – Pros & Cons

  • Multiple Pivot Dashboards

Excel Automation Intro

  • Recording a Macro

Included in the course is a free Flash Drive that contains a follow along Excel Workbook with detailed notes on each Section. A comprehensive Video Files Library of “you-tube” like mp4 files will also enable you to revisit any of the content covered, plus a tear-off summary Recap Sheet will help remind you of all the key concepts.

Public Courses

Johannesburg:​​​​

  • 21 Nov '19

  • 24 Jan '20

  • 13 Feb '20

Durban: ​​​

  • 14 Nov '19

  • 05 Dec '19

  • 23 Jan '20

Pietermaritzburg:​​

  • 8 Nov '19

  • 12 Mar '20

Course Cost: R1 990 (excl. VAT)

Courses Available:  

Not sure which course to start with? Make use of our Free  Pre-Assessment. Click here to find out more

FLEXIBLE

PUBLIC & CORPORATE ONSITE EXCEL TRAINING

18 YEARS

DATA ANALYSIS, REPORTING  & EXCEL SPECIALISTS

COMPREHENSIVE

DEMO VIDEOS & RECAP SHEETS SUPPLIED

SUPPORT

ACCESS TO WEBINAR'S

& EXCEL TIPS

RELEVANT

SOLUTIONS BASED TRAINING WITH REAL LIFE EXAMPLES

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • improve my skills on microsoft excel
  • excel training for businesses
  • excel training help in Durban
  • learn the features of excel

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

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

MS Office Courses

2019 | Copyright | Summit Solutions