Menu

Excel for Accounting Professionals Session 1: Tables and Named References

Overview

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.

    Prerequisites

    Working knowledge of Excel

    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

  • Excel conventions
  • Critical shortcuts
  • Named references
  • Tables

    Register Now

    Materials are generally available 3 days in advance of an event. Once you have downloaded the manual, we are unable to cancel your registration.

    • Event Code:

    4902286

    2 CPE Credits
    Specialized Knowledge and Applications: 2 Credits

    Registration

    Member Price:
    $125
    Non-member Price:
    $149

    Registration is open through 04/02.

    Thursday, April 2nd

    1:00pm to 3:00pm

    Add to Calendar

    Instructor

    Liam Bastick

    Related Courses

    Determining Reasonable Compensation for Owner Employees

    March 30, 2026

    1 Credits
    Details
    Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation

    March 31, 2026

    2 Credits
    Details
    Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check

    March 31, 2026

    3.5 Credits
    Details
    © 2025 Kentucky Society of Certified Public Accountants. All Rights Reserved. Contact Us