Highlights
• Excel shortcuts and time savers
• Working with templates, formats, styles and themes
• Customizing and enhancing Excel
• Protecting and securing workbooks
• Formula building and the Excel function library
Objectives
• Recognize the many keyboard shortcuts that are available to save time and effort
• Indicate how one would use Excel Templates, Styles, and Themes to add uniformity to workbooks they design or edit
• Indicate how a user can design custom number and date formats to meet their specific needs
• Recognize ways to add security to the workbooks, including workbook encryption and the use of sheet-level, range level and cell-level security features
• Recognize formula-building conventions such as order of operation
• Recall how to troubleshoot formulas that are not working properly
• Recall how to work with functions in the Excel function library to create powerful formulas