Intermediate  Microsoft Excel Training Course

Learn how to grow your Excel Skills!

Want to grow your Excel Skills? Extend your MS Excel skill set with our Microsoft Excel Intermediate course.

This MS Excel course builds on the Basic Functions and Formulas covered in our Beginner Course and introduces new concepts such as Non-standard Series Generation, Data Manipulation and Conditional Formatting. We will also look at ways and means of handling larger spreadsheets and take a sneak peek at the Advanced MS Excel course content of Pivot Tables and the VLOOKUP formula.

Even though the content of this course is pitched at the Intermediate Level, there are some Key Essentials covered that even many Advanced Users are not aware of. So, if you don’t know how to change Excels’ default Decimal symbol, or why 21-07-2019 can display as 43667, or what $A$2 is, then we would strongly recommend that this is the course for you.

Course Cost: R1 575 (excl. VAT)

Comments from Attendees

“The intermediate course was excellent with the amount of detail covered. Extensive skills transfer, broad knowledge base (and) excellent assistance where and when required.”

-  Sarvhar, VNA Consulting

“The facilitator was well informed and could answer all questions. The course was very well structured and logically presented. It created an appetite for the advanced course.”

 

-  Mbali, Spoormaker & Partners

“Informative, value for money and useful to use personally and at work. Excellent Training, Professional.”

 

- Audrey, Global Collateral Control

“Was extremely informative and once used in the workplace will definitely assist in doing things quicker.”

 

- Karon, Energy Partners Hvac & R (Pty) Ltd

“As per yesterday’s beginner course, I have taken a lot from the day. Very happy with the course and it fulfilled all my expectations. The facilitator was brilliant. Mark has the ability to get information through to you individually and explains each section thoroughly.”

 

– Diana, Individual

What you'll learn: 1-Day Intermediate MS Excel Training Course

Excel Key Essentials 

  • Difference between Data Types

  • Influence of Regional Settings

  • Data Formats

Non-standard Series Generation

  • Using Autofill-handle

  • Using Formula

  • Advantages & Disadvantages

Advanced Copy & Paste

  • Values or Formulas

  • Number Formats

  • Column Widths

  • Transposing data

View Optimization

  • Freeze Panes

  • Collapse / Pin Ribbon

  • Hide / Show Formula Bar / Headers

  • Data Grouping

  • Zoom options

  • Split screen

  • View Worksheets Side by Side

Formula

  • Common Formula (SUM, AVERAGE, COUNT, MAX and MIN)

  • IF statement

  • ROUND function

  • Formula best practices

Cell Referencing

  • Excels Golden Rule(s)

  • Absolute Cell References - $A$2

  • Replicating Formula

  • Referencing cells in diff. Worksheets

  • Using Named Cells

  • Linking to diff. Workbooks

  • Editing and Maintaining Links

 

Data Manipulation

  • Merging & Splitting

  • Flash Fill

  • Text Formulas (CONCAT)

  • Text-to-Columns

Excel Graphs

  • Simple Creation and Editing methods

  • Different Graph Types

  • Adding / Editing Graph components

  • Multiple Series Graphs

Conditional Formatting

  • Data Bars, Colour Scales etc

  • Highlighting Duplicates

Sorting

  • Quick & Multi-Level Sorting

  • The NB of Data Ranges

Filtering

  • Basic Filtering Recap

  • Advanced Data Type Filters

  • Using Filters to extract specific Data

Find and Replace

  • Power of Mass Edits

  • Hidden Dangers

 

Printing

  • Page Layout vs. Print Preview

  • Custom Headers / Footers

  • Repeating Header Rows

  • Printing gridlines

  • Page Numbers

  • Print Scaling

​​

Tables

  • Converting Ranges to Tables

  • Table Formatting

  • Structured Cell References

  • The Totals Row

Intro to Advanced Features

  • Pivot Tables and Charts

  • VLOOKUP formula

 

Excel Keyboard Shortcuts

  • Over 40 Excel Keyboard shortcuts to maximize your efficiency

Public Courses

Johannesburg:​​​​

  • 20 Nov '19

  • 23 Jan '20

  • 12 Feb '20

Durban: ​​

  • 13 Nov '19

  • 04 Dec '19

  • 22 Jan '20

Pietermaritzburg:​​

  • 07 Nov '19

  • 11 Mar '20

Course Cost: R1 575 (excl. VAT)

Courses Available:  

Not sure which course

to start with?

Make use of our Free 

Pre-Assessment. 

Click here to find out more.

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. A Course Attendance Certificate will be presented on the completion of the course.

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