Introduction

Summarize Data with SUMIF

Summarize Data with AVERAGIF

Summarize Data with COUNTIF

Using VLOOKUP with TRUE to find an Approximate Match

Using HLOOKUP TRUE to find an Approximate Match

Using the Index Function

Using the Match Function

Creating a Combined Index and Match Formula

Comparing Two Lists with VLOOKUP

Comparing Two Lists with VLOOKUP and ISNA

Creating a Nested IF Function

Using the IFERROR Function

Using the LEN Function

Using the TRIM Function

Using the Substitute Function

Showing Formulas

Tracing Cell Precedents and Dependents

Adding a watch Window

Error Checking

Using the Scenario Manager

Using Goal Seek

Analyzing with Data Tables

Protection Overview

Excel File Password Encryption

Allowing Specific Worksheet Changes

Adding Protection to only Certain Cells in a Worksheet

Additional Protection Features

Using the Pivot Tables Charts Wizard

Adding a Calculated Field

Adding a Caculated Item

Apply Conditional Formatting to a Pivot Table

Using Filters in the Pivot Table Fields Pane

Creating Filter Pages for a Pivot Table

Enabling a Power Pivot Add In

What are Macros

Displaying the Developer Tab and Enabling Macros in Excel

Creating a Basic Formatting Macro

Running a Macro

Assigning a Macro to a Button

Creating a More Complex Macro

Viewing and Editing the VBA Code for an Existing Macro

Adding a Macro to the Quick Access Toolbar

What are Form Controls

Adding Spin Buttons and Check Boxes to a Spreadsheet

Adding a Combo Box to a Spreadsheet

What is Data Validation

Restricting Data Entries to Whole Numbers

Data Validation Restricting Data Entry to a List

Data Validation Restricting Data Entry to a Date

Data Validation Restricting Data Entry to Different Text Lengths

Composing Input Messages

Composing Error Alters

Finding Invalid Data

Editing and Deleting Data Validation Rules

Working with Comments

Printing Comments and Errors

Sharing a Workbook

Tracking Changes in a Workbook

Working with Versions

Sharing Files via Email

Importing a Text File

Exporting a Text File

Course Recap