Topics in this episode: Create dual-axis charts, Add trendlines to charts, Save a chart as a template and create custom chart templates, and View chart animations.

Topics in this episode: Create and manage custom conditional formatting rules, Create conditional formatting rules that use formulas, Create PivotCharts, and Manipulate options in and apply styles to existing PivotCharts.

Topics in this episode: Custom Formatting - dates and text, and Custom Formatting - sections and colors

Topics in this episode: Formatting number values, and Custom Formatting - number formatting.

Topics in this episode: Filtering Data, including using Slicers, Group PivotTable data, and Reference data by using GETPIVOTDATA, and add and utilise calculated fields.

Topics in this episode: Using FREQUENCY, Trapping errors with IFERROR and ISERROR, Creating our first PivotTable, and PivotTable Options

Topics in this episode: Perform logical operations by using nested functions, Perform statistical operations by using COUNTIFS, and Perform statistical operations by using SUMIFS and AVERAGEIFS.

Topics in this episode: Encrypt a workbook with a password, Importing and exporting XML data, Perform logical operations by using the NOT function, and Perform logical operations by using AND and OR.

Topics in this episode: Hiding Formulas, Protect Workbook, Sharing Workbooks, Track Changes and Manage Workbook Versions.

Topics in this episode: Reference data by using structured references, Restrict editing by protecting a spreadsheet, Lock and unlock cells, and Lock and unlock objects and hide formulas