Microsoft Excel Level 2

Module: Microsoft Excel Level 2 (Intermediate)

Lesson 1
Calculating Data with Advanced Formulas
 Apply cell and range names.
 Calculate data across worksheets.
 Use specialized functions.
 Analyse data with logical and lookup (h & v lookup) functions.

Lesson 2
Organizing Worksheet and Table Data
 Create and modify tables.
 Format tables.
 Sort or filter worksheet or table data.
 Use functions to calculate data.

Lesson 3
Presenting Data Using Charts
 Create a chart.
 Modify charts.
 Format charts.

Lesson 4
Analyzing Data Using PivotTables, Slicers, and PivotCharts
 Create a PivotTable report.
 Use Slicers for filtering data.
 Analyze data using PivotCharts.

Lesson 5
Inserting Graphic Objects
 Insert and modify pictures and clip art graphics.
 Draw and modify shapes.
 Illustrate workflow using SmartArt graphics.
 Layer and group graphic objects.

Lesson 6
Customizing and Enhancing the Excel Environment
 Customize the Excel environment.
 Customize workbooks.
 Manage themes.
 Create and use templates.