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.