Excel - Advanced Defined Names & Excel Tables (C50128)


Cancellation Policy

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):

06/18/2021

Registration Open:

12:00 AM - 12:30 PM

Time:

12:30 PM - 2:30 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: $79.00
Nonmember: $99.00

Individual Discounts:

Not Available

Overview

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

  • Use the INDIRECT function and Defined Names to build a summary table
  • Determine the importance of having Consistent Column Calculations
  • Use Excel Tables to build Consistent Column Calculations
  • Build formulas that use Structured Tables References

Highlights

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

  • Using the INDIRECT function with Defined Names
  • The importance of Consistent Column Calculations
  • Ways to create Consistent Column Calculations
  • Using Structured Table References in formulas

Speaker(s)

Prerequisites

We highly recommend you take Excel - Two Must Know Features: Defined Names & Tables before this course.