Spreadsheets

Excel 2016/2013 Part 3

This course covers a number of powerful and important functions and features in Excel. Learn popular advanced functions, statistical and analytical features, and automation using macros.

Dates & Times

CourseDate & TimeLocationCost
Excel 2016/2013 Part 3February 27 - 8:30 - 4:30LathamRegister
Excel 2016/2013 Part 3March 28 - 8:30 - 4:30LathamRegister
Excel 2016/2013 Part 3May 4 - 8:30 - 4:30LathamRegister
Excel 2016/2013 Part 3June 1 - 8:30 - 4:30LathamRegister

Course Outline

This course is recommended for an experienced Excel user who would benefit from learning more about the functions and features of the product.

Includes:
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Working with Mulitple Worksheets and Workbooks

  • Use links and external references
  • Use 3-D references
  • Consolidate data

Lesson 2: Using Lookup Functions and Formula Auditing

  • Use Lookup functions
  • Trace cells
  • Watch and evaluate formulas

Lesson 3: Sharing and Protecting Workbooks

  • Collaborate on a workbook
  • Protect worksheets and workbooks

Lesson 4: Automating Workbook Functionality

  • Apply data validation
  • Search for invalid data and formulas with errors
  • Work with macros

Lesson 5: Creating Sparklines and Mapping Data

  • Create Sparklines
  • Map data

Lesson 6: Forecasting Data

  • Determine potential outcomes using data tables
  • Determine potential outcomes using Scenarios
  • Use the Goal Seek feature
  • Forecasting data trends