Microsoft Excel Training > Microsoft Excel Dashboard for Business Intelligence

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

Get To Know The Trainer

Trainer Sharon

4.5

Sharon Lee has been a marketing & brand management executive for 20 years and is a successful business builder in the role of distributor, marketer, brand builder and product innovation leader.

VIEW PROFILE