July 21, 2021 from 10:00 am to 4:00 pm
Please Note: This Advanced Excel training 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 (£20) but should be arranged in advance.
This advanced Excel training course will teach you to use the advanced features of Excel to their full extent for your business or department.
By the end of this advanced Excel training course, you will be able to configure and reproduce company data in a list using PivotTables, edit and analyse complex data by creating and utilising Scenarios, Goal Seek, incorporate built-in functions into a worksheet, work with controls and record macros.
This is the fourth and final Excel course in our 4-course Excel Pro-User program. It is the highest level of training for Excel available from the NWL Chamber for those that utilise Excel in a professional environment.
This advanced Excel training is ideal for Financial managers or consultants, business owners or line managers responsible for creating and maintaining company data via spreadsheets.
Delegates will learn the following high level features:
- LOOKUP functions
- Using VLOOKUP and HLOOKUP
- Auditing Workbooks and Worksheets
- Using tracer arrows
- Finding worksheet errors
- Workbook, Worksheet, and Cell Protection
- Protecting and Un-protecting Workbooks and Sheets
- Linking Workbooks
- Creating and Customising PivotTables
- Adding and removing fields
- Hiding and displaying field detail
- Working with totals in a pivot table
- Database, Logical and Information functions
- Command and Function macros
- Recording and running Macros
- Assigning Macros to the Keyboard and Toolbar
- Interpreting and Analysing data using Excel tools Goal seeker, outlines, and scenarios
- Consolidating data
- …And so much more!
This advanced Excel training course has been designed for experienced users of Microsoft Excel who have either completed the Excel Level 3: Power Users course (or equivalent or have taken the Excel Online Assessment to determine a readiness for the Excel Level 4: Pro Users course. The link for the 3-5 minute assessment is below:
This course is instructor led, and involves useful examples and exercises in a workshop environment to enable delegates to come away with an amazing repertoire of practical advanced Excel experience as well as useful techniques, tips, and tricks.
This course requires a laptop and mouse with Excel 2016 or newer installed – if needed, a limited number are available for hire on the course but this must be reserved/booked several days in advance. The trainer will need to install exercise files on your laptop should you choose to use your own.