Excel for Accounting Professionals Session 2: Data Validation and Conditional Formatting
If you have questions about this event, please call us at 952-831-2707.
Wednesday, Oct. 7, 2026
10 a.m.-noon Central
2 CPE (2 technical)
Course code: 26WI-0209
View pricing
Which Excel function is your go-to? This session invites you to actively engage and practice with the instructor, exploring exercises demonstrated. In doing so, you'll gain a firmer grasp of common Excel functionalities, including: Data validation; Conditional formatting; Enhanced summing options; Skinny rows.
Gaining proficiency in Excel means learning to design workbooks that are both functional and streamlined. The facilitator will lead you through an array of formatting skills, formula functions, and beyond as we expand upon foundational Excel knowledge with topics such as: Managing data input for individual cells; Using conditional formatting to prevent errors; Enhancing productivity via the Subtotal feature; Ensuring total formulas refresh automatically.
Session 2 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 others to further prepare to tackle real-world issues and build powerful workbooks.
Major subjects
-
Data validation.
-
Conditional formatting.
-
Subtotal function.
-
Reduce formula errors.
-
Skinny row.
Learning 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.
Who should take this program?
- Accounting and finance professionals who'd like to improve their mastery of Microsoft Excel.
Pricing
|
Standard Member Fee |
$89.00
|
Standard Nonmember Fee |
$109.00
|
MNCPA members save $20.00. Become a member.
Our records indicate
you are a
nonmember.
If you register, you will be charged
$109.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
If you have questions about this event, please call us at 952-831-2707.