Excel 2016 Intermediate

Excel 2016 Intermediate

Learn how to link workbooks and worksheets, and work with named ranges.

Updated Apr 09, 2019

This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.


The recommended prerequisite for this course is Excel 2016 Introduction course or equivalent knowledge or experience.


This IAAP-certified course counts for 4 recertification points for the CAP certification under the Technology and Information Distribution content area. Email [email protected] with proof of completion of the course to obtain your certificate.