Live Webcast Replay
Mastering Advanced Excel Functions and Formulas
Total Credits: 2 including 2 Computer Software & Applications - Non-technical
- Average Rating:
- 4.7
- Category:
- ACPEN Industry Institute | Industry
- Faculty:
- Mac McClelland
- Course Levels:
- Intermediate
- Duration:
- 2 Hour
- License:
- Access for 30 day(s) after program date.
Dates
Please Note: Programs with a ☾ insignia begin after 5pm or air on the weekend.
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 ObjectivesUpon completing this session, you should be able to:
- 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
Course Materials
| Important CPE Credit Instructions_READ BEFORE WEBCAST UPDATED (0.47 MB) | Available after Purchase | ||
| Mastering Advanced Excel Functions and Formulas Handout (855 KB) | Available after Purchase |
Dates
|
Mon, Mar 08, 2021 - 12:00pm to 01:49pm MST
|
|
Sat, Mar 27, 2021 - 02:00pm to 03:49pm MDT
|
|
Mon, Apr 12, 2021 - 08:00am to 09:49am MDT
|
|
Fri, Apr 23, 2021 - 10:00am to 11:49am MDT
|
|
Sat, May 01, 2021 - 12:00pm to 01:49pm MDT
|
|
Thu, May 13, 2021 - 02:00pm to 03:49pm MDT
|
|
Tue, Jun 08, 2021 - 08:00am to 09:49am MDT
|
|
Fri, Jun 18, 2021 - 10:00am to 11:49am MDT
|
|
Sat, Jul 10, 2021 - 12:00pm to 01:49pm MDT
|
|
Mon, Jul 19, 2021 - 02:00pm to 03:49pm MDT
|
|
Wed, Aug 18, 2021 - 08:00am to 09:49am MDT
|
|
Sat, Aug 28, 2021 - 10:00am to 11:49am MDT
|
|
Fri, Sep 03, 2021 - 12:00pm to 01:49pm MDT
|
|
Tue, Sep 21, 2021 - 02:00pm to 03:49pm MDT
|
|
Mon, Oct 11, 2021 - 08:00am to 09:49am MDT
|
|
Sat, Oct 23, 2021 - 10:00am to 11:49am MDT
|
|
Wed, Nov 03, 2021 - 12:00pm to 01:49pm MDT
|
|
Mon, Nov 22, 2021 - 02:00pm to 03:49pm MST
|
|
Sat, Dec 11, 2021 - 08:00am to 09:49am MST
|
|
Tue, Dec 28, 2021 - 10:00am to 11:49am MST
|
Additional Info
Basic Course Information
Original Recording Date 06/01/2020Date 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 BasedComplaint 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
| 5 |
|
| 4 |
|
| 3 |
|
| 2 |
|
| 1 |
|
Overall: 4.7
Total Reviews: 6
Please wait ...