Excel Mod IV
Charts, PivotTables, & Macros

Download Class
Data Files

Creating Charts
Using Charts
Creating Charts - Chart Wizard
Moving and Resizing Charts
Identifying Chart Objects
Changing the Chart Type
Changing the Chart Type and Sub-Type
Changing the Plot Direction
Moving the Legend
Adding/Removing a Legend
Charting Non-adjacent Ranges
Changing the Chart Range
Changing the Data Source
Changing the Chart Location
Printing a Chart 

Formatting Charts
Adding Chart Titles
Formatting Chart Objects
Changing the Test Orientation
Adding a Data Table
Creating an Exploded Pie Chart
Adjusting the 3-D View
Deleting a Chart

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

Creating/Revising PivotTables
Creating a PivotTable Report
Adding PivotTable Report Fields
Selecting a Page Field Item
Refreshing a PivotTable Report
Changing the Summary Function
Adding New Fields to a PivotTable Report
Moving PivotTable Report Fields
Hiding and Unhiding PivotTable Report Items
Deleting PivotTable Report Fields
Creating a Page Field Report
Formatting a PivotTable Report
Creating a PivotChart Report
Publishing PivotTable Reports to the Web
Adding Fields to a PivotTable ? Browser
Using a PivotTable List

Using Macros
Defining Macros
Opening a Workbook Containing Macros
Running a Macro
Using a Shortcut Key
Using the Visual Basic Toolbar
Opening the Visual Basic Editor Window
Using the Visual Basic Editor Window

Recording Macros
Recording a Macro
Assigning a Shortcut Key
Using Relative References
Assigning a Macro to a Menu
Removing a Custom Menu Item
Deleting a Macro

Editing Macros
Writing a New Macro
Entering Macro Comments
Copying Macro Commands
Editing Macro Commands
Typing Macro Commands
Running a Macro from the Code Window

Creating a Macro Button
Using a Macro Button
Creating a Macro Button
Copying a Macro Button
Formatting a Macro Button
Moving/Sizing a Macro Button
Deleting a Macro Button

Using AutoShapes and Diagrams
Drawing a Callout
Drawing a Basic Shape
Drawing a Connector
Drawing a Flowchart Shape
Inserting a Diagram
Working with Diagrams

Using Additional Effects and Objects
Adding a 3-D Effect
Applying a 3-D Setting
Adding a Shadow
Drawing a Text Box
Drawing an Arrow
Inserting Pictures
Formatting Graphics

Drawing an Object
Drawing Enclosed Objects
Drawing a Line
Selecting Filled and Unfilled Objects
Moving an Object
Adding Test to An Object
Selecting Test in an Object
Resizing an Object
Formatting Lines 

Excel Mod V
Database Management

Download Class
Data Files

Managing Data
Sorting Lists
Sorting in Ascending/Descending Order
Finding Data
Replacing Data

Working with Databases
Using a Database
Creating a Database
Modifying a Database
Sorting Records by Multiple Fields
Using Data Validation
Validating Data using a List
Creating a Custom Error Message
Removing Data Validation
Creating Subtotals in a List
Removing Subtotals from a List

Using AutoFilter
Enabling AutoFilter
Using AutoFilter to Filter a List
Clearing AutoFilter Criteria
Creating a Custom AutoFilter
Disabling AutoFilter

Working with the Data Form
Viewing the Data Form
Viewing Data Form Records
Editing Data Form Records
Adding Data Form Records
Defining Criteria
Clearing Data Form Criteria
Deleting Data Form Records

Working with Advanced Filters
Creating a Criteria Range
Using a Criteria Range
Showing All Records
Using Comparison Criteria
Using an Advanced And Condition
Using an Advanced Or Condition
Copying Filtered Records
Using Database Functions

Importing and Exporting 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 a Table from a Web Page
Copying a Table from a Web Page

Customizing Excel Preferences
Setting View Options
Setting Edit Options
Setting General Options

Using Custom Toolbars and Menus
Creating a Custom Toolbar
Adding/Removing Toolbar Buttons
Adding the Custom Button to a Toolbar
Assigning a Macro to a Button
Changing a Button Image
Displaying Button Text and Image
Attaching a Custom Toolbar
Deleting a Custom Toolbar
Creating a Custom Menu
Adding Custom Menu Commands

Sharing Workbooks
Using Shared Workbooks
Saving a Shared Workbook
Viewing Users Sharing a Workbook
Viewing Shared Workbook Changes
Changing the Update Frequency
Highlighting Changes
Managing Conflicting Changes
Resolving Conflicting Changes
Setting Change History Options
Adding a History Worksheet
Reviewing Tracked Changes
Managing shared Workbook Files

Using Worksheet Protection
Unlocking Cells in a Worksheet
Protecting a Worksheet
Unprotecting a Worksheet
Creating Allow-Editing Ranges
Deleting Allow-Editing Ranges
Protecting Workbook Windows
Unprotecting Workbook Windows
Assigning a Password
Opening a Password-protected File
Removing a Password
Setting Manual Calculation
Resetting Automatic Calculation
Using the Document Recovery Plan

Using Templates
Working with Templates
Saving a Workbook as a Template
Using a Template
Editing a Template
Inserting a New Worksheet
Deleting a Template
Creating Default Templates