Description
The following topics will be covered:
Rules for Creating a Database
- Elements of a Database
- Create an Excel Database
- 7 rules for setting up an Excel database
- Modifying the Database Structure
Excel Tables
- Creating a table from a list
- Formatting a table
Sorting
- 2 click sorting
- Multiple column sorting
- Sort by colours
- Sort by cell icon
Pivot Charts
- Create a Pivot Chart
- Format Pivot Charts
Filters
- Understanding filters
- Turn on auto filter
- Filter text fields
- Filter number fields
- Filter date fields
- Filter by colour
- Filter by cell icon
- Select filtered data
- Totals and filters
- Multiple field filters
- Advanced filter
- Remove filters
Pivot Tables
- What is a Pivot Table
- Understand how PivotTables summarise data
- Create a PivotTable
- Pivot Table layout options
- Change designs
- Sort and filter a PivotTable
- Refresh a PivotTable
- Change the data source
- Group data by row labels
- Format numbers within a Pivot Table
- Create calculated fields