Log In to Register

Please note that this webinar Is from a third party vendor, CPA Crossings. We strongly recommend registering no later than one-hour before the webinar begins. Please contact CPA Crossings webinar hotline if you do Not receive your webinar invitation via email within five minutes after registering:  877-370-2220 ext. 1. Thank you.

Date(s):

04/15/2024

Registration Open:

12:00 AM - 1:00 PM

Time:

1:00 PM - 3:00 PM

Facility:

Online

Meeting Type:

Webinars

CPE Credit:

2.00

Field(s) Of Study:

Computer Software and Applications (2.00)

Level of Knowledge:

Intermediate

Price:

Member: $89.00
Nonmember: $109.00

Individual Discounts:

Not Available

Overview

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

  • Identify the best practices for setting up spreadsheets for data analysis
  • Apply the use of Consistent Column Calculations to improve the accuracy of your spreadsheets
  • Determine how to leverage array formulas

Highlights

The major topics that will be covered in this class include:

  • Overview of setting up spreadsheets for data analysis and how Excel Tables can help
  • Learning the importance of Consistent Column Calculations
  • How to use Conditional Formatting to highlight important information
  • How to leverage Excel Tables by analyzing them in PivotTables
  • Learning to leverage array formulas

Prerequisites

Excel for Staff Level 1 or similar course