Microsoft Excel Advanced

Using Excel as a Database

What Is An Excel Database?

Using the Data Form

Entering Data

Finding Records

Deleting Records

Clearing Search Criteria

Using the Autofilter Feature

Applying Filters

Removing Filters

Filtering for Top 10

Applying Custom Filters

Turning Off AutoFilter

Using the Advanced Filter

Setting Criteria in the Criteria Range

Criteria Range

Applying Advanced Filters

Removing Filters

Using Database Functions

List of Database Functions

Setting Conditions in the Criteria Range

Creating Formulas Using Database Functions

Summarizing And Analyzing Data

Using PivotTables to Summarize Data

Creating a PivotTable

Grouping Data

Changing the PivotTable Layout

Viewing Different Pages

Using the PivotTable Wizard

Changing the Source Data

Summarizing And Analyzing Data (Cont.)

Creating Scenarios

Showing Scenarios

Editing Scenarios

Summarizing Scenarios

Grouping and Outlining Worksheets

Working with Custom Views

Creating Basic Macros

Using Conditional Formatting

Creating Basic Macros

Running a Macro

Editing a Macro

Customizing Toolbars

Using More Advanced Functions

Using the Subtotals Feature

Using the VLOOKUP Functions

Syntax for VLOOKUP and HLOOKUP

Creating Named Ranges

Using the ISERROR Function

Creating a Template

Validating Data Entry

Unlock Certain Cells

Protecting the Worksheet

Creating Basic Templates

Creating a New Workbook Based On a Template