CPE & Events Catalog
Excel for Accounting Professionals Session 1: Tables and Named References
Transforming how you use Excel with engaging and expert-led instruction
Designed for you to work alongside an expert and complete the same exercises, you’ll dig deeper into topics, including:Benefits of using named references for faster navigation
Increased versatility and efficiency withing your Excel workbooks
Excel Tables special properties and
Error reduction for greater productivity.
Mastering Excel functions
Excel mastery involves understanding how to create functional and efficient workbooks. The instructor will guide you through Tables, named references, and more as you build on basic Excel skills and use critical functions, such as: Excel conventions
Critical shortcuts
Efficient navigation techniques
Automatic formula updating
*Session 1 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 2: Data Validation and Conditional Formatting] (https:// https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-2--data-validation-and-conditional-formatting) to further prepare to tackle real-world issues and build powerful workbooks.*
Designed for you to work alongside an expert and complete the same exercises, you’ll dig deeper into topics, including:
Mastering Excel functions
Excel mastery involves understanding how to create functional and efficient workbooks. The instructor will guide you through Tables, named references, and more as you build on basic Excel skills and use critical functions, such as:
*Session 1 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 2: Data Validation and Conditional Formatting] (https:// https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-2--data-validation-and-conditional-formatting) to further prepare to tackle real-world issues and build powerful workbooks.*
Learning Objectives
- Identify Excel conventions that make recurring workbooks possible.
- Identify critical Excel shortcuts that can be used to increase efficiency.
- Use named references for more efficient navigation.
- Apply Tables to facilitate automatic formula updates when new data is added to an existing spreadsheet.
Highlights
· Identify Excel conventions that make recurring workbooks possible.
· Identify critical Excel shortcuts that can be used to increase efficiency.
· Use named references for more efficient navigation.
· Apply Tables to facilitate automatic formula updates when new data is added to an existing spreadsheet.
Event Level: Intermediate
Field of Study: Specialized Knowledge
Who Should Attend
Accounting and finance professionals who'd like to improve their mastery of Microsoft Excel
Required Knowledge
Working knowledge of Excel
