This video includes information on: • Freezing and unfreezing rows and columns • Opening a new window for a workbook • Splitting worksheets
16.Sorting Data
This video includes information on: • Types of sorting • Sorting sheets and ranges • Creating a custom sort • Adding levels
17.Filtering Data
This video includes information on: • Filtering data • Applying multiple filters • Clearing filters • Using advanced text, number, and date filters
18.Groups and Subtotals
This video includes information on: • Adding and editing headers, which appear in the top margin • Adding and editing footers, which appear in the bottom margin • Adding and editing page numbers to a document • Restarting page numbering
19.Tables
This video includes information on: • Formatting data as a table • Adding rows or columns to a table • Changing the table style and modifying table style options • Removing a table
20.Charts
This video includes information on: • Understanding and inserting charts • Switching row and column data • Changing chart types • Moving and updating charts
21.Conditional Formatting
This video includes information on: • Understanding conditional formatting • Creating a conditional formatting rule • Using preset conditional formatting • Removing conditional formatting
22.Track Changes and Comments
This video includes information on: • Turning on Track Changes • Reviewing tracked changes • Adding, editing, showing, hiding, and deleting comments
23.Inspecting and Protecting Workbooks
This video includes information on: • Using the Document Inspector • Protecting your workbook
24.Intro to PivotTables
This video includes information on: • Using PivotTables to answer questions • Creating PivotTables • Adding columns • Changing rows and columns
25.Doing More with PivotTables
This video includes information on: • Adding filters • Adding slicers • Creating a PivotChart
26.What-if Analysis
This video includes information on: • Using GoalSeek • Other types of What-If Analysis
.png)
