On-Demand


6.5 CPE Credits

Advanced Excel: Practical Applications for Accounting Professionals

On-Demand
6.5 CPE Credits

Learning Objectives

Advanced

Major Topics

Advanced PivotTables;External data ranges (ODBC);Visual basic: macros and user-defined functions;Digital workpapers;Securing worksheets and workbooks;Named ranges;VLOOKUP and related functions, Nest Offset, Text, Match;"IF" function and other efficiency gains;Encryption and data validation

CPE Credits Available

6.5 CPE Credits
6.5
Specialized Knowledge

Things to Know About This Course

Course Level

  • Advanced

Professional Area of Focus

  • Future Ready

Prerequisites

Working knowledge of Excel

Intended Audience

All accounting and finance professionals

Provider

AICPA

Purchase This Course

  • MACPA Member

    $ 145 145
    Join
  • MACPA Non-Member

    $ 175 175
    Your Price

Please login to register.