OBJECTIVE:
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 OUTCOME: 
By the end of this course, participants should be able to: 

• 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. 

CONTENT:
The topics in this seminar include: 

• 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 

APPLICABLE FOR:
All accounting and finance professionals 

WHAT TO EXPECT: 

•  After registering for the on-demand course, you will receive an email from Bridge (AICPA) with your login information within two business days. 
• You will be required to sign into Bridge to access your course. To create a password for your Bridge account, use the forgot password link. The email from Bridge may take a few minutes to arrive. Please also check your junk folder.
• You will have 180 days after registration to complete the course.  
• This self-study course allows the user to save their progress and return to continue later.