Lesson 6 - Managing Data
Sorting Lists
Sorting in Ascending/Descending Order
Finding Data
Replacing Data
Finding and Replacing Cell Formats
Lesson 7 - Using AutoFilter
Enabling AutoFilter
Using AutoFilter to Filter a List
Clearing AutoFilter Criteria
Creating a Custom AutoFilter
Disabling AutoFilter
Lesson 8 - Managing Files
Changing Workbook Properties
Using the Basic Search Task Pane
Using the Advanced Search Task Pane
Clearing Query Clauses
Selecting File Views
Sorting Excel Files
Using the Document Recovery Pane
Workshop Information Page |
Lesson 9 - Creating Charts
Using Charts
Creating Charts with the Chart Wizard
Moving and Resizing Charts
Identifying Chart Objects
Changing the Chart Type
Changing the Chart Type and Sub-type
Changing the Plot Direction
Removing/Adding a Legend
Moving the Legend
Charting Non-adjacent Ranges
Changing the Chart Range
Changing the Data Source
Changing the Chart Location
Printing a Chart
Lesson 10 - Formatting Charts
Formatting Charts
Adding Chart Titles
Formatting Chart Objects
Changing the Text Orientation
Adding a Data Table
Creating an Exploded Pie Chart
Adjusting the 3-D view
Deleting a Chart |
