Advanced Excel: Practical Applications for Accounting Professionals

Printer Friendly
Text Size: A A A A
 
Back New Search

Overview

5.0 Credits
ONLINE

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 book is available as an interactive Excel Workbook file, so you can follow along in Excel as you read.

Objectives

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

Major Topics

  • 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

Designed For

Accounting and finance professionals in public practice or industry
Add to Cart