Please note this course is available for private booking on a date convenient for you. Live Online instructor led training is also available for this course.
This 1 day Microsoft Excel 2016 Advanced training course is available either at your premises or at the local Cambourne training venue.
Take your already excellent Excel skills to the next level, let Microsoft Excel to the hard work for you. The more you learn about how to get Excel to do the hard work for you, the more you''ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
During this course you will:
- Work with multiple worksheets and workbooks
- Use Lookup functions and formula auditing
- Share and protect workbooks
- Automate workbook functionality
- Create sparklines and map data
- Forecast data
Course Outline
Working with Multiple Worksheets and Workbooks in Excel 2016
- Use Links and External References
- Use 3-D References
- Consolidate Data
Using Lookup Functions and Formula Auditing
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
Sharing and Protecting Workbooks
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
Automating Workbook Functionality with Microsoft Excel 2016
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
Creating Sparklines and Mapping Data
- Create Sparklines
- Map Data
Forecasting Data
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends
To see a full list of training rates are available on our website, alterntaively each course page has a course calculator for your convenience.
The course outline is available to view here and via the website.
For a taster why not check out our Excel Bitesized Online Training Videos
