Excel 2016 Intermediate
Expand your Excel abilities with charts, outlines, workbooks and much more.
Course Description
This course is designed to be the intermediate level of Excel 2016.
Students will learn how to link workbooks and worksheets, create named
ranges and utilize them in formulas, build Logical functions such as IF,
AND, and OR, and use Lookup functions to locate and compare data.
Students will also be introduced to and work with Excel’s Table feature,
learning to create and modify Tables. Students will also create and
modify PivotTables and PivotCharts to analyze large data sets, sort the
data, and use Slicers and Timeline Slicers to filter the data.
Additionally, students will create and modify Charts, work with Flash
Fill, work with subtotals and outlining, and learn how to customize the
Excel environment.
Learning Outcomes
Pre-requisites
Excel 2016 Introduction course or equivalent knowledge or experience
Who is this course intended for?
Students who want to take their Excel knowledge to the next level.