MenuClose
 Log Out
Cart 0 items
Site Search
Course Search

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

 Wed, 02/04/2026 from 11:00 am to 1:00 pm
 
2.0
26 / 2-90496
Registration is Open
Member Price
$125.00 Regular Registration
Your Price
$149.00 Regular Registration
Designed For:

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

Prerequisite:

Working knowledge of Excel

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

    Achieving proficiency in Excel features
    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 [Session 3: Workbook Design Principles and Organization] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-pr…) to further prepare to tackle real-world issues and build powerful workbooks.*
    Delivery Method: Individual webcast
    CPE Credit: Specialized knowledge
    Program Level: Intermediate

    This course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by AICPA.

    • 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.

    Speakers

    Vendor

    The Virginia Society of CPAs (VSCPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org.

    For more information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call (800) 733-8272.