Description

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.

Target Audience

Aspiring leaders and leaders of teams and organizations

Course 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

Subjects

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