Cartsini | Upskilling

EXCEL DASHBOARD TRAINING

Treng Technology and Consultancy

Professional

Course Description:
The capability exists within Microsoft Excel to construct sophisticated dashboards that integrate seamlessly with data based in Microsoft Excel or in other external data sources. Using a combination of the Excel worksheet, drawing shapes, pictures, ActiveX controls, cells and charts, and sophisticated dashboards can be constructed in minimal time providing a cost effective way of a business to view its important data. Many companies are turning to constructing dashboards in Excel due to the lower cost, lower development time and because of Excel's exceptional abilities.

Starting from RM0/month

The capability exists within Microsoft Excel to construct sophisticated dashboards that integrate seamlessly with data based in Microsoft Excel or in other external data sources. Using a combination of the Excel worksheet, drawing shapes, pictures, ActiveX controls, cells and charts, and sophisticated dashboards can be constructed in minimal time providing a cost effective way of a business to view its important data. Many companies are turning to constructing dashboards in Excel due to the lower cost, lower development time and because of Excel's exceptional abilities.

People with little or no experience of creating Excel Dashboards. Understanding and using Excel on a regular basis is essential. Ideally delegates have attended an Advanced Excel course or have the equivalent experience

DAY ONE

Module 1 – Visualisation Best Practices

Module 2 – Excel Charting Principles and Advice

Module 3 – Advanced Charting

Module 4 – Excel Pivot Tables

Module 5 – Creating your Excel Dashboards

DAY TWO

Module 6 – More Dashboarding

Module 7 – Working with your Data

Module 8 – Analysing Data

Module 9 – Workshop