Microsoft Excel 2016 Advanced Training 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
Dates Monday, March 23, 2020 - Download as vCalendar
Venue This 1 day course can either be held at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.
Contact Name Cindy Cubbin
Email cindy@computertutoring.co.uk
Contact Phone 0800 158 3588
Website Event website

Event details:

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

 

Computer Tutoring have a reputation for quality and engaging training. Our many training courses are available either at your own premises or at a local computer tutoring training venue.