Module 1: Enhancing Workbooks

Your workbooks can be customized in a number of different ways. In this topic you will learn how to customise in more ways.

• Customize workbooks
• Create and use templates
• Protect files

Module 2: Automating Worksheet Functionality

This section looks at speeding up repetitive tasks such as adding automatic worksheet functionality to spreadsheet 

• Update workbook properties
• Create and edit a macro
• Apply conditional formatting
• Add data validation criteria to a workbook

Module 3: Analysing and Presenting Data

This section looks at analysing data and presenting data in an easy to understand manner.

• Create Sparklines
• Create a Data List Outline
• Perform statistical analysis with the Analysis ToolPak
• Create interactive data with Power View

Module 4: Import and Export Data

This section looks at importing and exporting data to and from Excel.

• Export Excel data
• Import a delimited text file
• Integrate Excel data with the web
• Create a web query
• Import and export XML data

Module 5: Managing Large Workbooks

After completing this module, the learner will be able to consolidate, link and sort data within spreadsheets.

• Consolidate data
• Merge workbooks
• Sort and filter data

Module 6: Analysing data within PivotTables, Slicers and PivotCharts

One of the most powerful tools that you have your disposal when analysing data in Excel is the PivotTable. It is important to understand how they work and gain some fundamental understanding of their purpose before creating PivotTables of your own data.

• Create a PivotTable
• Filter data using slicers
• Analyze data using PivotCharts

Module 7: Analysing Data with Logical and Lookup Functions

While you are now familiar with Excel’s more commonly used functions, you still need to learn about some of its more specialized ones. In this topic you will learn about functions that are specific to text analysis.

• Use text functions
• Use logical functions
• Use lookup functions
• Use date functions
• Use financial functions
• Use specialised functions