Microsoft Excel Dashboard for Business Intelligence

Course Objectives

• Creating dashboard
• Pivottbales and PivotCharts
• Useful functions
• Conditional Formatting
• Form Controls
• Working with charts
• Working with Sparklines

Target Audience

This course is best suited to anyone in Business Intelligence, data managers, data analysts, or Project Managers. This course would also suit anyone looking to extend their knowledge of Excel to understand some of the more advanced features and how they can be used to work together.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

Course Modules

• MODULE 1: WHAT IS A DASHBOARD?
• MODULE 2: PIVOTTABLES AND PIVOTCHARTS
• MODULE 3: USEFUL FUNCTIONS
• MODULE 4: CONDITIONAL FORMATTING
• MODULE 5: FORM CONTROLS
• MODULE 6: WORKING WITH CHARTS
• MODULE 7: WORKING WITH SPARKLINES
  APPENDIX A: SAMPLE DASHBOARD PROJECTS