Excel Level 2: Beyond The Basics

This Excel Level 2 training course aims to build on the knowledge gained using Excel (self-taught users) or users who have completed the Excel Level 1: The Fundamentals course.

Excel Level 2 delegates will go “Beyond the Basics” to learn about formula syntax, creating charts, using new functions and learning the secrets of building effective tables in Excel.

To avoid booking a course that is either too hard or too easy, too fast or too slow, we ask that all delegates complete a pre-course checklist to assess their current level of Excel knowledge. This will enable us to ensure that all delegates are on the right course and able to follow the training at a similar pace:

Excel Assessment: Are you a beginner or a pro? Find out here

If we feel that you are “beyond” the elements and concepts discussed in this course – we will recommend which level we feel would most benefit you. This assessment can save both time and money!

What we will cover:

Review of Excel fundamentals
Working with Worksheets
Using Formulas in Excel
- Use the Excel ‘Functions’ (SUM, MIN, MAX, AVERAGE, COUNT, COUNTA)
- Understanding formula syntax
- Understanding and using ‘arguments’ in functions
- Using brackets in formulas
- Correcting errors in Formulas
- Relative and Absolute Cell References
- Using Auto-sum and Auto-calculate
Creating effective Data Lists (Tables)
Formatting Tables and ranges
Sorting and Filtering of data tables
Using Format painter
Printing options – set print area
Introduction to Charts

This course is Live online and instructor-led and involves useful examples and exercises in a workshop environment to enable delegates to work ‘smarter’ with Excel and learn useful techniques, tips, and tricks.

Please Note: Delegates should bring/have a laptop with Excel 2016 or newer installed (unfortunately not an Apple laptop or a ‘web-based’ version of Excel). Whilst not essential, the laptop should have a mouse attached as this can be quicker for users during the course.