MS Excel Intermediate Course
* Live Training is for groups of 6 or more - Prices Ex. Vat
Course Overview
This Intermediate course builds on the Basic Functions and Formulas covered in our Excel Beginner Course and introduces you to new concepts such as Non-standard Series Generation, Absolute Cell References, Excel Tables and Charts.
A common thread throughout is an emphasis on best practices to Store, Organise and Manipulate your data, plus we look at the two popular advanced features of VLOOKUP and Pivot Tables.
Course Content
Emphasizing the importance of storing your data in a Tabular Range and some Tips and Tricks on how to fix incorrectly stored Data.
Sorting: The difference between Quick and Multi Level sorting.
Filtering: We’ll recap the basics and then look at some Advanced Data Type Filters including filtering by Date component, Numerical Thresholds and even filtering by Colour.
Simple ways to Create and Edit Graphs. Which Graph Types to use for which Data; Adding / Editing Graph components; creating Multiple Series Graphs, plus some fundamental Do’s and Don’ts when creating Graphs.
An introduction to Conditional Formatting as an alternative to graphs. Plus, the additional benefits such as picking out Duplicates or highlighting Values above or below a specific threshold.
The many advantages of converting an Excel Range to a Table. Once you’ve seen this you will never look back.
The most effective way to analyse data in Excel. We show you the basics and the key things to be aware of when working with them.
An Advanced function but only second to AutoSum in popularity. We show you the basics and the most efficient way to use it.
Using Basic Text Formulas, Flash Fill and Text-to-Columns to Split and Merge Data. Plus, some key guidelines as to when best to use which method.
Over 40 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
Next Step ...
For further specific information for our various training options use the links below; or alternatively contact us on hello@summitsolutionstraining.co.za or 086 167 3923.
Excel Intermediate Course Reviews
Concise, well laid out, valuable
Kayla Rautenbach – Versofy Solar
Very good and thorough
learned a lot especially shortcuts
CRIZILLE LAMPREC – PLASSON SA
nice overview on all the aspects of excel
very well presented and explained
Empowering
Annalien Willemse – Plasson SA
Enjoyed the way the course was structured, gain a lot of knowledge.
The course was highly informative and interactive
Cherelle Taytim Barbeau – Kerry Ingredients
The course was highly informative and interactive. The material was well-paced, ensuring a smooth learning experience. Our instructor ,Mark, was patient and actively engaged with the team, making sure that we gained the necessary skills to meet both individual and team needs.
A new path has been tread.
Tanita Gowrisunker – Kerry Ingredients
I have finished this course feeling much more self confident in my excel skills. I have walked out with the answers to the questions I have entered with. Definitely will be back for advanced learning course.
Awesomeness
Siyabonga Hadebe – Kerry Ingredients
Course was great, I figured I've been living a taught life when it comes to excel. After Mark's sessions, it all became clear. Thanks dude
Amazing
sandiselwe Maphumulo – Kerry
Very informative, we learned a lot as a team
Insightful
Eustacia Lalla – Kerry Ingredients
Very informative and great tips to make working much easier
