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
|