In this module, you will be introduced to steps on how to update workbook properties. A macro is an action or a set of actions that you can run as many times as you want, you will discover how to create and edit a macro. You will also learn how to apply conditional formatting and data validation criteria to ranges of cells in your workbook.

In this module, you will be introduced to steps on how to trace cells. You will learn how to troubleshoot invalid data and formulas, how to watch and evaluate formulas. Excel allows you to group rows or columns so that they can be hidden or displayed with a single mouse click. You will learn how to create a data list outline using Excel 2013.

In this module, you will be introduced to the creation of sparklines, as well as create scenarios and perform a what-if analysis. You will learn how to perform a statistical analysis using the analysis tool pack. You will also learn about how to create interactive data using power view.

In this module, you will be introduced to steps on how to consolidate data. When you create formulas in Excel and refer to a data point in another workbook, Excel creates a link to that workbook. This module teaches you how to link cells in different workbooks and how to merge workbooks.

In this module, you will be introduced to steps on how to export Excel data. A comma-delimited file is one where each value in the file is separated by a comma. You will learn how to import a delimited text file, integrate Excel data with the web and how to create a web query.