2-Day Advanced  Microsoft Excel Training Course

Become the Microsoft Excel Guru in your Office

Our 1-day Advanced course continues to be very popular, however, one comment that we often get is that “It’s a lot to take in, in one day!”

 

In addition, there are a number of other cool Advanced Functions and Features that we would love to add to our Advanced course which we simply just don’t have the time for over one day.

 

This 2-day course addresses both of these issues, plus also gives you an opportunity to put your newly acquired skills to the test with some more hands-on practical examples.

There is also the option to bolt on our 1-Day Excel Automation Course to make this a 3-Day all-inclusive Excel Guru Course!

What you'll learn: 2-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

 

Forecasting

  • Goal Seek

  • Solver

CSV Export and Import

  • Regional Settings

  • Import Wizards

  • Data Connections

Merging and Splitting Data

  • Basic Text Formula

  • Flash Fill

  • Text-to-Columns

Data Validation & Worksheet Protection

  • Data Type Validation

  • In cell Dropdowns

  • Unlocking cells & Protecting Sheets

Formula

  • Text - CONCAT, PROPER, UPPER, LEFT, RIGHT, MID, TRIM, LEN, REPT, SEARCH, FIND, NUMBERVALUE

  • Logical - IF, IFERROR, AND, OR

  • Date - YEAR, MONTH, DAY, WEEKDAY, WEEKNUM, EDATE, EOMONTH, TODAY, YEARFRAC, NETWORKDAYS

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

  • Lookup – VLOOKUP (Exact and Approx. Match), INDEX, MATCH plus the INDEX-MATCH lookup combination.

  • Defined Names

  • Structured cell references (Tables)

  • Nested Formula

 

Conditional Formatting

  • Basics Recap

  • Using Formula

  • Multiple Formats on the same Range

 

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

  • Power Query Basics

NB: All underlined items are exclusive

to the 2-Day Advanced Course.

Public Courses

2020 Course dates to be confirmed 

Course Costs (excl. VAT):

2-Day Advanced: R3 980 

3-Day Advanced & Automation: R6 250

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