At present, the data analysis and the effective presentation of information are skills that are in high demand in the workplace. Training in KPI Dashboards and Pivot Tables in Excel It meets this need by teaching you to master pivot tables, a key tool for synthesising large volumes of data and presenting information in a clear and engaging way. You will also learn how to integrate Excel and Power BI, making it easier to create striking dashboards that will capture your audience’s attention. This training course is ideal for those who wish to enhance their professional profile and stand out in a competitive market. By the end of the course, you will be ready to make informed decisions and add value to your organisation.
Cross-cutting
Digital Skills
35 mins
KPI Dashboards and Pivot Tables in Excel
Digital Skills
35 mins
Introduction
Objectives
-
Learn how to use pivot tables to analyse large volumes of data efficiently.
-
Design custom pivot tables which comply with the the specific requirements of each project.
-
Include additional fields in pivot tables to provide a analysis more comprehensive and detailed.
-
Create dynamic charts from tables for eye-catching and easy-to-understand visualisations.
-
Import and export data between Power BI and Excel for to optimise information management.
-
Develop dashboards eye-catching visualisations in Power BI that facilitate decision-making.
-
Improving the data presentation by using graphical tools in Excel and Power BI.
Table of Contents
VIDEO LESSON 1. THE POTENTIAL OF PIVOT TABLES IN EXCEL
VIDEO LESSON 2. DESIGNING A PIVOT TABLE
VIDEO LESSON 3. ADDING ADDITIONAL FIELDS TO A PIVOT TABLE
VIDEO LESSON 4. PIVOT TABLE REPORTS
VIDEO LESSON 5. DYNAMIC CHARTS
VIDEO LESSON 6. POWER BI AND EXCEL: DATA INTEGRATION AND EXPORT
More related courses
Cross-cutting
Cross-cutting
Cross-cutting