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, 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
Date | Duration | Location | Price | Booking | Enquiry |
---|
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. 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, 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.
Duration - 2 days
Upon successful completion of this course, students will be able to: Module 1 Visualization Best Practices
Module 2 Excel Charting Principles and Advice
Module 3 Advanced Charting
Module 4 Excel Pivot Tables
Module 5 Creating your Excel Dashboards
Module 6 Creating Interactive Components for Dashboard
Module 7 Working with your Data
Module 8 Analyzing Data
Module 9 Bullet-proofing your Dashboards
Module 10 Workshop
3 Months FREE email support for queries