October 11, 2017 from 9:30 am to 4:45 pm
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 Excel Pro 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 24-question assessment is below:
This 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:
- Quick review of ‘Power user’ – Formulas, Functions and formula syntax
- Using LOOKUP/VLOOKUP/HLOOKUP functions
- Using Advanced filtering
- Auditing Workbooks
- Validating data
- Workbook and Worksheet Protection
- Interpreting and Analysing data using Excel tools
- Goal seeker
- Creating and removing outlines
- Creating and using Scenarios
- Creating and Customising PivotTables/Charts
- Other Excel functions
- Database functions
- Introduction to Macros
- Introduction to VBA and basic editing
- Customising the Ribbon
This advanced Microsoft 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 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, and Goal Seek, incorporate built-in functions into a worksheet, work with controls and record macros.
This course is instructor led, and involves useful examples and exercises in a workshop environment. It is presented by our highly experienced and qualified Microsoft Excel trainer, Chris Stevens who has many years of experience to enable you to come away with an amazing repertoire of practical Excel experience as well as useful techniques,tips, and tricks. Chris trains using version 2016.
Delegates should bring a laptop with Excel 2016 installed – if this is not possible then one can be rented to use during the course but you should arrange this in advance. Chris will need to install exercise files on your laptop should you choose to use your own.
Does this course date/time/location not work for you? We’re flexible, contact us to bring the training directly to your facility through in-house or bespoke courses. Call us for a quote or to arrange for training that takes place on a date, time, or location that is most convenient for you!