You Don't Know What You Don't Know About Excel 2024

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

Major Topics:

• 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

Major Topics:

• 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

Designed For:

CPAs, accountants and financial professionals.

Prerequisites:

An understanding of Excel conventions.