Excel for Accounting Professionals Session 1: Tables and Named References

Prerequisites

Working knowledge of Excel

Designed For

Accounting and finance professionals who’d like to improve their mastery of Microsoft 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.