Advanced Excel: Practical Applications for Accounting Professionals

Tap into Excel's full potential. 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) - 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. Learning Objectives: Understand how to automate recurring processes. Utilize the most powerful features of Excel. Identify which features and functions should be used for various high-level tasks. Field of Study: Specialized knowledge Level: Advanced CPE: 6.5