Course Content
Lesson 1: Using Lists
- Using Auto Fill to Enter Data
- Using AutoComplete
- Creating and Using Absolute Named Ranges
- Working with Data Validation
- Inserting and Deleting Columns or Rows
- Freezing and Unfreezing Panes
- Splitting a Worksheet Window Using Functions with Lists
Lesson 2: Using Table Features
- Creating a Table, Formatting a Table
- Sorting a Table, Filtering a Table
- Working with the Total Row, Creating a Calculated Column
Lesson 3: Working with Data
- Importing Data from a Text File
- Exporting Data
- Converting Text to Columns
- Using Flash Fill, Using Text Functions
- Connecting to Data in an Access Database
- Creating a Web Query
- Importing Web Data using a Saved Query, Working with Hyperlinks
Lesson 4: Creating and Working with PivotTables
- Understanding PivotTables
- Creating a PivotTable using Worksheet Data, an External Data Connection
- Laying out a PivotTable on a Worksheet
- Modifying PivotTable Fields
- Using a Report Filter
- Refreshing a PivotTable, Formatting a PivotTable
- Using VLOOKUP to Add a Column to a List
Lesson 5: Enhancing PivotTables
- Working with Summary Functions
- Creating a Slicer, Calculated Field, Calculated Item & PivotChart
- Applying Filters & Grouping Data
- Using a Timeline