20SI-0005: Advanced Excel: Practical Applications for Accounting Professionals (Self-Study)
Valid for one year from purchase date
Self-study - On-Demand
6.5 CPE (6.5 technical)
If the organization paying
for the purchase is exempt from sales tax, call us at 952-831-2707 to complete your purchase.
Add to cart
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.
Major subjects
-
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 objective(s)
-
Automate recurring processes
-
Use the most powerful features of Excel
-
Know which features and functions should be used for various high-level tasks
Who should take this program?
Accounting and finance professionals in public practice or industry
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$155.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Standard Member Fee |
$125.00
|
Standard Nonmember Fee |
$155.00
|