Microsoft Excel 2013 Level 2

Course Code: N/A

Course Description

This course gives students a further understanding of Microsoft Excel, building a range of more advanced skills for creating and editing workbooks.

Course Outcomes

Create advanced formulas.
Analyze data with logical and lookup functions.
Organize worksheet data with tables.
Visualize data by using charts.
Analyzing data with PivotTables, slicers, and PivotCharts.
Insert graphic objects.
Enhance workbooks.

Course Modules

Creating Advanced Formulas Apply Range Names Use Specialized Functions Analyzing Data with Logical and Lookup Functions Leverage Questions and Testing to Write Formulas Use Logical and Lookup Functions to Find Answers to Questions Organizing Worksheet Data with Tables Create and Modify Tables Sort and Filter Data Use Summary and Database Functions to Calculate Data

Enhancing Workbooks Customize Workbooks Manage Themes Create and Use Templates Protect Files

Visualizing Data with Charts Create Charts Modify and Format Charts Create a Trendline Create Advanced Charts Analyzing Data with PivotTables, Slicers, and PivotCharts Create a PivotTable Filter Data by Using Slicers Analyze Data by Using PivotCharts Inserting Graphics Insert and Modify Graphic Objects Layer and Group Graphic Objects Incorporate SmartArt

Prerequisites

Microsoft Excel 2013 Level 1

Next Steps

Microsoft Excel 2013 Level 3

Questions about this course?