MenuClose
 Log Out
Cart 0 items
Site Search
Course Search

Taking Advantage of Array Formulas in Excel

 Various
 
2.0
Registration is Open
Price
$89.00 Regular Registration
This course is being offered on multiple dates, listed below. Click the Register button next to your preferred date to register.
 Thu, 06/19/2025 from 4:00 pm to 6:00 pm
 Wed, 07/02/2025 from 4:00 pm to 6:00 pm
 Fri, 07/18/2025 from 3:30 pm to 5:30 pm
 Mon, 08/04/2025 from 3:30 pm to 5:30 pm
 Fri, 08/22/2025 from 4:00 pm to 6:00 pm
 Fri, 09/05/2025 from 3:00 pm to 5:00 pm
 Tue, 09/16/2025 from 1:00 pm to 3:00 pm
 Thu, 10/02/2025 from 12:00 pm to 2:00 pm
 Mon, 10/13/2025 from 12:00 pm to 2:00 pm
 Fri, 11/14/2025 from 1:30 pm to 3:30 pm
 Mon, 11/24/2025 from 2:30 pm to 4:30 pm
 Tue, 12/02/2025 from 9:30 am to 11:30 am
 Fri, 12/19/2025 from 11:30 am to 1:30 pm
 Fri, 01/02/2026 from 1:00 pm to 3:00 pm
 Tue, 01/13/2026 from 11:00 am to 1:00 pm
 Tue, 02/03/2026 from 11:00 am to 1:00 pm
 Fri, 02/20/2026 from 12:00 pm to 2:00 pm
 Mon, 03/02/2026 from 3:30 pm to 5:30 pm
 Wed, 03/18/2026 from 11:00 am to 1:00 pm
 Thu, 04/02/2026 from 4:00 pm to 6:00 pm
 Fri, 04/17/2026 from 12:00 pm to 2:00 pm
Designed For:

This course is ideal for professionals who regularly use Microsoft Excel for data analysis, financial modeling, or complex calculations.

Prerequisite:

A comprehensive working knowledge of Excel

This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel.This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Delivery Method: Individual webcast
CPE Credit: Computer software & applications
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 CPA Crossings.

Objectives

After attending this presentation, you will be able to...

  • Apply array formulas and functions in Excel to solve complex data analysis problems, enhancing the efficiency and accuracy of calculations.
  • Differentiate between regular and array formulas, and determine when to use each for optimal data management and processing in various scenarios.
  • Analyze and select the most appropriate array functions and constants for specific tasks, improving the effectiveness of data manipulation and presentation in Excel

Speakers

Advanced Preparation

Download the handout and practice material prior to course

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.