Conditional Formatting

• Add a conditional format
• Change or remove a conditional format
• Copy conditional formatting to another cell
• Apply conditional formatting

Data Validation

• Designate valid cell entries
• Error message options
• Create a data validation rule

Custom Date and Number Formatting

• Number formatting
• Custom number formatting
• Delete a custom format
• Format characters for building custom number formats
• Date formatting

Protecting your Worksheets

• Add protection to your worksheet
• Unprotect your worksheet

Protecting your Workbook

• Protect the structure of a workbook
• Add password protection to a workbook
• Open the protected workbook
• Remove password protection

Moving and Copying Sheets

Exporting Data from Excel into Word

• Paste the Excel spreadsheet as a picture
• Paste the Excel spreadsheet as an Excel object

Creating Automatic Subtotals

• Create automatic subtotals in a list
• Remove the subtotal feature

Creating Pivot Table Reports

• Using the Pivot Table wizard
• Pivot Table Toolbar and field list
• Filter a field list
• Rearrange pivot table fields
• Pivot table drill down
• Format your Pivot table report
• Print preview your Pivot table report

Consolidating Data

• Consolidate data using 3-D formulas
• Consolidate data by position

Getting Started with Excel Macros

• Automate tasks
• Macro virus settings
• Set Excel macro security level
• Run a command macro
• Run and examine existing macros
• Run a macro using Tools menu
• Run a macro using a customized button
• Run a macro using 'lower case' keyboard shortcut
• Run a macro using 'upper case' keyboard shortcut
• Run a macro using VB toolbar
• View macro code in VB

Running a Command Macro from Another Workbook

• Run a macro from the Macro dialog box
• Run a macro witha shortcut key

Recording a Simple Command Macro

• Use the VB basic toolbar
• Record a simple macro

Recording More Macros

• Create macros that open other workbooks
• Delete a macro
• Creat a macro that tiles worksheets
• Relative vs. absolute reference recording
• Create an absolute reference maco
• Create a relative reference macro

Creating Macros for Printing

• Create and use Page Setup macros

Assigning Macros to Buttons and Menus

• Add controls to a sheet using the forms toolbar
• Run a macro from a custom button
• Run a macro from a toolbar button
• Delete a toolbar
• Add a macro to an existing menu
• Create a new macro menu
• Reset the worksheet menu bar

Using the Personal Macro Workbook

• Create a macro and save it in your personal macro workbook
• Delete the macro from your personal marco workbook