Total Credits: 4 including 4 Computer Software & Applications - Non-technical
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.
Important Course Information_Read First (0.47 MB) | Available after Purchase |
Excel Essentials for Accountants 4 hour Handout 2021 (6.8 MB) | Available after Purchase |
=CONCATENATE and Friends (18.3 KB) | Available after Purchase |
=HLOOKUP (11.3 KB) | Available after Purchase |
=VLOOKUP (30.1 KB) | Available after Purchase |
Autofilter (11.2 KB) | Available after Purchase |
Conditional Formatting (11.5 KB) | Available after Purchase |
Pivot Charts (202 KB) | Available after Purchase |
Pivot Tables #1 (12.7 KB) | Available after Purchase |
Pivot Tables #2 (11.4 KB) | Available after Purchase |
Pivot Tables #3 (200.3 KB) | Available after Purchase |
Sorting (11 KB) | Available after Purchase |
Text Editing (12.7 KB) | Available after Purchase |
Chris has been serving the tax and accounting needs of individuals and closely-held businesses since 1998. As a frequent speaker, he has taught a variety of continuing education courses for several state CPA societies. Chris is frequently interviewed by media outlets on a variety of financial, tax, and accounting topics.
None
Van Der Aa Tax Ed, LLC
Practitioners, members in industry and other accounting professionals a better understanding of the advanced features of Microsoft Excel.
No
04/01/2021
A high level of proficiency with Microsoft Excel.
04/01/2021
Please contact Anne Taylor for any complaints. Anne.taylor@acpen.com, (972-377-8199).
Online Registration
Group Internet Based
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
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.
5 |
|
4 |
|
3 |
|
2 |
|
1 |
|