Excel for Accounting Professionals Session 1: Tables and Named References
Wednesday, Feb. 4, 2026
8-10 a.m. Central
2 CPE (2 technical)
Course code: 25WI-0475
View pricing
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. 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 to further prepare to tackle real-world issues and build powerful workbooks.
Major subjects
-
Excel conventions
-
Critical shortcuts
-
Named references
-
Tables
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
Who should take this program?
- Accounting and finance professionals who'd like to improve their mastery of Microsoft Excel
Pricing
|
Standard Member Fee |
$125.00
|
 Standard Nonmember Fee |
$149.00
|
MNCPA members save $24.00. Become a member.
Our records indicate
you are a
nonmember.
If you register, you will be charged
$149.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
