Organizing Data Using Tables

Create Tables

Modify Tables

Format Tables

 

Sorting and Filtering

Sorting Data

Multilevel Sorting

Filtering a List with Autofilter

Filtering a List with Advanced Filter

 

Working With Tables

Highlighting Duplicates

Combining Data from Multiple Tables

Auto Outline

Automatic Subtotalling

 

Database Functions

DSUM

DMAX and DMIN

DAVERAGE

DCOUNT

Other Database Functions

Importing and Exporting Data

Exporting Data From Excel

Importing Data From Other Applications

CSV files

Getting Data Live from the Internet

 

Data Forms

What is a Data Form?

Viewing Records with a Data Form

Deleting Records with a Data Form

Adding New Records with a Data Form

Changing Records with a Data Form

Finding Specific Records with a Data Form

 

Data Tables

What is a Data Table?

Using Data Tables for Forecasting

Creating a One Input Data Table

Creating a Two Input Data Table

 

Scenarios

Creating a Scenario

Managing Scenarios

Creating a Summary Report