| Modifying a Worksheet |
|
Insert, Delete, and Adjust Cells, Columns, and Rows |
|
00:10:00 |
|
Search for and Replace Data |
|
00:09:00 |
|
Use Proofing and Research Tools |
|
00:07:00 |
| Working with Lists |
|
Sort Data |
|
00:10:00 |
|
Filter Data |
|
00:10:00 |
|
Query Data with Database Functions |
|
00:09:00 |
|
Outline and Subtotal Data |
|
00:09:00 |
| Analyzing Data |
|
Apply Intermediate Conditional Formatting |
|
00:07:00 |
|
Apply Advanced Conditional Formatting |
|
00:05:00 |
| Visualizing Data with Charts |
|
Create Charts |
|
00:13:00 |
|
Modify and Format Charts |
|
00:12:00 |
|
Use Advanced Chart Features |
|
00:12:00 |
| Using PivotTables and PivotCharts |
|
Create a PivotTable |
|
00:13:00 |
|
Analyze PivotTable Data |
|
00:12:00 |
|
Present Data with PivotCharts |
|
00:07:00 |
|
Filter Data by Using Timelines and Slicers |
|
00:11:00 |
| Working with Multiple Worksheets and Workbooks |
|
Use Links and External References |
|
00:12:00 |
|
Use 3-D References |
|
00:06:00 |
|
Consolidate Data |
|
00:05:00 |
| Using Lookup Functions and Formula Auditing |
|
Use Lookup Functions |
|
00:12:00 |
|
Trace Cells |
|
00:09:00 |
|
Watch and Evaluate Formulas |
|
00:08:00 |
| Automating Workbook Functionality |
|
Apply Data Validation |
|
00:13:00 |
|
Search for Invalid Data and Formulas with Errors |
|
00:04:00 |
|
Work with Macros |
|
00:18:00 |
| Creating Sparklines and Mapping Data |
|
Create Sparklines |
|
00:07:00 |
|
MapData |
|
00:07:00 |
| Forecasting Data |
|
Determine Potential Outcomes Using Data Tables |
|
00:08:00 |
|
Determine Potential Outcomes Using Scenarios |
|
00:09:00 |
|
Use the Goal Seek Feature |
|
00:04:00 |
|
Forecasting Data Trends |
|
00:05:00 |
