Product Image

Advanced Excel: Practical Applications for Accounting Professionals

Author/Moderator: Jeff Lenning, CPA, CITP
Publisher: AICPA
Availability: Backordered
See Below To Add To Cart
View Online Catalog
Divider
Print This Page
Divider

Description

Available Formats:  Text | See All

A CPA designed this CPE course specifically for accounting and finance professionals who have a good grasp of Excel and want to take their skills to the next level. Learn about the features you need to achieve greater efficiency and automation. Also, each exercise presented in the course is available as an interactive Excel Workbook file (download at clickconsulting.com), so you can follow along in Excel as you read.

Topics Discussed:

  • Advanced pivot tables
  • External data ranges (ODBC)
  • Visual basic: macros and user defined functions
  • Digital workpapers
  • Securing worksheets and workbooks
  • Named ranges
  • Vlookup() and related functions that Nest Offset(), Text(), Match()
  • IF function and other efficiency gains
  • Encryption and data validation

Learning Objectives:
When you complete this course, you will be able to:

  • Automate recurring processes.
  • Use the most powerful features of Excel.
  • Know which features and functions should be used for various high level tasks.

Who Will Benefit?
Accounting and finance professionals in public practice or industry

Prerequisite: Working knowledge of Excel

Advanced Preparation: None

Table of Contents

Excerpts

Videocourse Details

NASBA Field of Study: Specialized Knowledge and Applications
Level: Advanced
Recommended CPE Credit: 10 (Preliminary Credit, See Details)
Advanced Excel: Practical Applications for Accounting Professionals
Text , 2015
Product# 745756
Availability: Backordered
Regular:$193.75
AICPA Member:$155.00
Your Price:$193.75
To receive your AICPA member discount, Sign In now, or Register using your AICPA membership number.