Controller Series: Technology - Must Have Excel Competencies
Wednesday, May 29, 2024
Webcast or Webinar, Online
11:00AM - 12:00PM (opens at 10:30AM) EST
1Credits
Technical Business
Registration is Open
Members
$71.00 Regular Price
Non-Members
$82.00 Regular Price
CPE PowerPass Users
Click the "Apply PowerPass" button to use your PowerPass for the applicable course below.
$20.00 Members / $28.00 Non-Members
Don't have a CPE PowerPass? Click
here to find out more about the CPE PowerPass program.
Course Type: Webcast
Course Code: 24/AI383988
Level: Basic
Vendor: AICPA CPE Division
Overview:
Excel has long been included in the accountant's toolbox. Even though Microsoft Power BI and other big data tools such as Qlik and Tableau are becoming more important, Excel is still a "must have" tool. We cover what the accountants of today should know about Excel to improve their efficiency, access data, and gain insights into the company, industry, and economy.Objectives:
- Identify the tools that controllers should know, such as Excel's Power Pivot and Big Data
- Identify the relationship between Excel and Lean techniques
- Recognize how Excel complements data analytics
- Recall tricks and shortcuts to improve Excel use for your staff
Major Topics:
Reality of Excel useGartner - Magic Quadrant of tools for data analysis
Will Excel go away?
Two essential Lean principles
Misuses of Excel
APIs (Automated Program Interfaces)
Relationship between Excel and data analytics
Excel tips and tricks
Major Topics:
Reality of Excel useGartner - Magic Quadrant of tools for data analysis
Will Excel go away?
Two essential Lean principles
Misuses of Excel
APIs (Automated Program Interfaces)
Relationship between Excel and data analytics
Excel tips and tricks