Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
Overview
Excel techniques that incorporate data validation, improved formatting, and alternatives for standard functions, tailored for accounting experts.
Highlights
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.
Non-Member Price $109.00
Member Price $89.00