Lesson 6-Using List Features
Creating a List
Sorting and Filtering a List
Using the List Menu
Using the Insert Row
Creating a Total Row
Lesson 7 - Exporting and Importing Data
Exporting Data to Other Applications
Exporting to XML
Importing Data
Importing Data from Text Files
Changing External Data Range Properties
Importing Data from Other Applications
Removing the Query Definition
Importing Dynamic Data from the Web
Copying a Table from a Web Page
Lesson 8 - Advanced Charting
Adding and Removing Gridlines
Formatting Gridlines
Formatting an Axis
Changing the Axis Scaling
Formatting the Data Series
Adding Data - Different Worksheets
Using a Secondary Axis
Changing Data Series Chart Types
Adding a Trendline
Creating User-defined Charts
Applying User-defined Charts
Workshop Information Page
|
Lesson 9 - Using Multiple Workbooks
Opening Multiple Workbook Windows
Cascading Open Workbook Windows
Activating Cascaded Workbook Windows
Tiling Open Workbook Windows
Activating Tiled Workbook Windows
Copying Data between Workbooks
Saving a Workspace
Closing All Open Workbooks
Opening a Workspace
Linking Workbooks
Opening Linked Workbooks
Lesson 10 - Using Conditional and Custom Formats
Applying Conditional Formats
Changing a Conditional Format
Adding a Conditional Format
Deleting a Conditional Format
Creating a Custom Format |
