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.
Course ID: CSTMHEC
Controller Series: Technology – Must Have Excel Competencies
Learning 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 use
- Gartner – 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
Advanced Preparations
None
Who Should Attend
Aspiring leaders and leaders of teams and organizations
Fields of Study
Computer Software & ApplicationsPrerequisites
None