November 3, 2021 from 10:00 am to 4:00 pm
Please Note: This course requires a basic knowledge of Windows and a PC laptop/ mouse with Excel 2016 installed – we do have a few laptops that can be hired for use during the course but should be arranged in advance due to limited numbers.
This Excel Training course is designed for experienced and highly proficient users of the software who seek to move beyond intermediate to become true “power” users! This Level 3 course builds on the concepts learned in Excel Level 2: Beyond The Basics.
Because this high level course moves at a set pace we ask that, prior to booking the course, a quick multiple choice assessment is taken to determine your current level of Excel knowledge to enable that all delegates move at the same pace.
Maximise your impact with the use of advanced graphs and presentation techniques. Increase the interactivity of your sheets by learning the true “power” features and functions to solve complex problems while turning raw date into clear usable information that supports measurable initiatives.
The aim of this course is to build on the knowledge gained through Excel Intermediate: Beyond The Basics (Level 2). This course prepares delegates for the Excel Pro: Super Users (Level 4) course.
Delegates will learn:
- Review of Excel Basic Formulas and Functions
- Using Multiple Workbooks
- Working with Large Worksheets
- Using Logical and Date Functions (IF, TODAY, NOW, MONTH, YEAR, TEXT)
- ‘Nesting’ functions
- Advanced Formatting Features
- Format Painter
- Sparklines (Excel 2013 only)
- Conditional formatting and Data bars
- Working with Data Lists and Tables (Sorting, Filtering, Sub-Totals)
- Using Charts in Excel
You can arrange to have this training onsite at your facility on a date and time that is most convenient to your team. Contact us to discuss a bespoke or on-site offering today.