Print Course information
E-mail to a friend
Return to Course Catalog

Workshops > Microsoft Office 2016

MS Excel 2016 Part 3  

This course builds off of the foundational and intermediate knowledge presented in the MS Excel 2016: Part 1 and Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips.

This workshop is a blended training experience that includes instructor-led classroom time plus these online components available to you on any mobile device.

  • E-Book – an electronic version of your printed book, readable on any computer or mobile device
  • Files – the practice files used in the instructor-led class
  • Assessments – Detailed evaluations based on course content
  • Learn To – Short video tutorials reinforcing and expanding key concepts of the course
  • Checklist – Quick reference material and step-by-step instructions for tasks covered in the class in an easy-to-find format

Topics Covered
Working with Multiple Worksheets and Workbooks
     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
     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

Download Class Files


MS Excel 2016 Part 3
Item: ITOFF6006H5
1:00 PM - 4:30 PM Location: Hickory Hall, Hickory 128
Sessions: 2 M Tu 5407 N. University Peoria, IL 61635
2/18/2019 - 2/19/2019 Fee: $140.00

The Professional Development Institute
Illinois Central College Peoria Campus
5407 N. University St. Peoria, IL. 61635

© Illinois Central College. All Rights Reserved.