Description
Excel now has approximately 500 functions, many of which are unused by most accounting and finance professionals. This two-hour session will put you on the path to improved Excel productivity by introducing you to powerful and timesaving, but little used, Excel functions. If you want to improve your knowledge and efficiency with Excel, this session is a must for you.
Basic Course Information
Learning Objectives
- List the three Excel functions for computing payments, payment interest, and principal write down
- Differentiate between the GETPIVOTDATA and CUBEVALUE functions
- Recognize similarities in using the SUBTOTAL and AGGREGATE functions
- Identify the steps necessary to create array formulas using ordinary Excel functions
Major Subjects
- Using financial functions to calculate loan payments, depreciation, and cash flows
- Retrieve summarized data with the GETPIVOTDATA and CUBEVALUE functions
- Making sophisticated calculations with array formulas
Additional Info
Basic Course Information
Original Recording Date
06/01/2020
Date Added to Catalog
06/17/2020
Prerequisites
None
Advanced Preparation
None
Designed For
All
Course Developer
K2 Enterprises
Yellow Book
No
Additional Information
Instructional Delivery Method
Group Internet Based
Complaint Resolution Policy
Please contact Anne Taylor for any complaints. anne.taylor@acpen.com, (972-377-8199).
Official Registry Statement
Business Professionals' Network, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org
Refund/Cancellation Policy
Please contact the ACPEN help desk 1-877-602-9877 or help@acpen.com if you wish to cancel your attendance for a previously purchased webcast and are requesting a refund or transfer.
Course Registration Requirements
Online Registration
Reviews
Overall:
4.6
Total Reviews: 30