Lesson 1 - Working With Labels in Formulas
Using Labels in Formulas
Using Labels to Define a Range
Using Multiple Stacked Headings
Using Labels to Refer to Cells
Lesson 2 - Working With Outlines
Applying an Outline
Collaspsing/Expanding an Outline
Modifying Outline Settings
Clearing an Outline
Using Auto Outline
Lesson 3 - Working With Databases
Using a Database
Creating a Database
Modifying a Database
Sorting Records by Multiple Fields
Using Data Validation
Validating Data using a List
Creating a Custom Error Message
Removing Data Validation
Creating Subtotals in a List
Removing Subtotals from a List
Workshop Information Page |
Lesson 4 - Working With the Data Form
Viewing the Data Form
Viewing Data Form Records
Editing Data Form Records
Adding Data Form Records
Defining Criteria
Clearing Data Form Criteria
Deleting Data Form Records
Lesson 5 - Working With Advanced Filters
Creating a Criteria Range
Using a Criteria Range
Showing All Records
Using Comparison Criteria
Using an Advanced And Condition
Using an Advanced Or Condition
Copying Filtered Records
Using Database Functions |
