Irvine Training Company www.IrvineTrainingCo.com
Excel 315
Excel 315
 |
 |
 |
 |
 |
 |
 |
 |
| Excel 315 - Macros and More! Control keyed data entry, Create drop-down lists for data entry, Change Excel's default settings, Use multiple workbooks in formulas, automatically change cell formatting when contents change, more... 1/2 day Prerequisites: Excel Level 1 and Level 2, or equivalents for both click here to return |
Macros
Hands on - Adjust macro security settings Hands on - Make simple modifications to a macro Hands on - Assign a macro to a shortcut key Hands on - Assign a macro to a macro button Hands on - Assign the macro button to a toolbar Hands-on - Change the icon of a macro button Hands-on - Modify the icon of a macro button, freehand Conditional Formatting
Hands on - Automatically change cell formatting based on another cell Control Data Entry with Data Validation
Hands on - Create drop-down lists in the Data Validation window Hands on - Create and use a separate table as a drop-down list Hands on - Create descriptive messages for data input Hands on - Create descriptive messages for data entry errors Change Default Settings
Hands on - Change the default font name and font size Hands on - Choose whether zero values display as blank or zero Protect Worksheets and Workbooks
Hands on - Protect your Worksheet without a password Hands on - Protect your Worksheet with a password Hands on - Protect your workbook to keep others from opening it Multiple Workbooks
Hands on - View multiple workbooks with Arrange Hands on - Create a workspace containing all of these workbooks Hands on - Open multiple workbooks automatically Hands on - Refer to a cell in a different workbook Hands on - Create a formula that uses cells in a different workbook |
