On-Demand


2 CPE

Excel - Advanced Defined Names & Excel Tables

On-Demand
2 CPE

Learning Objectives

  • 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

Major Topics

  • 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

CPE Credits Available

2 CPE
2
Computer Software & Applications

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Pracitioner
  • Pracitioner's
  • Pracitioners
  • Technology

Prerequisites

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

Advanced Preparation

None

Intended Audience

Anyone that wants to take their Excel skills to the next level

Provider

CPA Crossings

Purchase This Course

  • MACPA Member

    $ 90 90
    Join
  • MACPA Non-Member

    $ 110 110
    Your Price

Please login to register.