Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting

Prerequisites

Working knowledge of Excel

Designed For

Accounting and finance professionals who’d like to improve their mastery of Microsoft Excel

Objectives

• Use data validation techniques that provide controls related to what can be typed into a cell.
• Apply conditional formatting techniques that prevent errors and increase efficiency.
• Use the subtotal function in place of the sum function to increase efficiency.
• Use skinny rows to automatically update total formulas when data is entered at the end of the range.