November 5, 2020 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.
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
This course is designed for people who are competent with the fundamentals and basics of Excel (or have completed Excel Level 1: The Fundamentals and Excel Level 2: Beyond The Basics) and aims to develop a range of more advanced skills. Revolutionize the way you manage, present, or otherwise run your department or business with this advanced training course in Microsoft Excel!
Delegates should bring a laptop with Excel 2016 installed and activated – if this is not possible then one can be rented for use during the course but there are a limited number so an early booking is recommended.
Lunch and refreshments will be provided and delegates will be awarded the Chamber of Commerce Certificate of Completion at the conclusion of this course.
Chamber Training Centre
1 Lockheed Court
Amy Johnson Way
Blackpool, FY4 2RN
The Chamber will run this course three times in 2020. However, 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.