June 21, 2018 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 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, Goal Seek and Solver, 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 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:
- 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
- Working with Toolbars
- Interpreting and Analysing data using Excel tools Goal seeker, outlines, and scenarios
- Consolidating data
- …And so much more!
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 3-5 minute assessment is below:
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.
This course requires a laptop and mouse with Excel 2016 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.
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!