Author(s)
Jeff Lenning, CPA, CITP

Publisher:
AICPA

    Credit Info
  • NASBA Field of Study

  • Format

    On demand

  • Level

  • CPE Credit

    0

  • Course acronym

  • Prerequisites

  • Course duration

    6.5 Hours

Advanced Excel: Practical Applications for Accounting Professionals

SKU: EXPF_19A_2 Category: Tag:
If you're comfortable using Excel, but want to take your skills to the next level, you've found the right course.

Written by a CPA and Excel expert, this self-study course will help you be more efficient and productive. This course covers topics including Advanced PivotTables, External data ranges (ODBC), and Visual basic: macros and user-defined functions.

Once you know how to tap the software's full potential, you'll be able to quickly and easily perform accounting and finance tasks in Excel.
$127.20
Hurry up, special offer for a limited time only.
blankTopics 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

blankLearning objectives

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

blank Who will it benefit?

Accounting and finance professionals