Description

A Business Analytics Dashboard created with Excel can be an amazing tool when it comes to tracking KPIs, comparing data points, and getting data-backed views that can help management take decisions. In this tutorial, you will learn how to create an Excel dashboard, best practices to follow while creating one, features and tools you can use in Excel, things to avoid at all costs, and recommended training material.

Developing Microsoft Excel skills is a powerful way to start analyzing data like the professionals do. Whether you’re navigating toward a future career as a data analyst, you want a new skill to leverage at work, or you want to turn your household budget into an impressive well-oiled machine, learning how to analyze data in Excel with Excel formulas and tools will definitely ramp up the efficiency of your life.

Course Highlights

• Module 1: Introduction to Data Analytics
• Module 2: Data Cleansing: Preparing the Data for the Dashboard
• Module 3: Designing a Visually Professional Dashboard
• Module 4: Introduction to Macros
• Summary & Closure

Who Should Attend?

• Working Accountants and Book-Keepers
• Entrepreneurs
• Managers
• Data Entry Personnel
• Finance and Accounting Students
• Anyone who is interested to learn an application