Apply conditional formatting to highlight data based on specified criteria. Create and apply data validation rules to help ensure accurate data entry. Create and apply custom date and number formatting. Move and copy worksheets and export data from Excel for use in Word. Create pivot table reports. Password protect at the worksheet and workbook level. Record and run macros and view and edit VBA code. 6 hours

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