In this Excel dashboard training we will train you how to create dashboard in Excel by summarize the data in Excel worksheet. We will explain using the Excel tables, the most efficient way to store and present the data in Excel as a dashboard. We will teach you pivot tables, several types of conditional formats, and how to summarize your data using charts.

Microsoft Excel Dashboard Training Course Singapore uses very advanced functions of Pivot Table, Formulas, Several types of conditional formats, and how to summarize your data using charts. & Charts used for your management reports like Accounting, Finance, Profit & Loss, Sales & Marketing.

After Excel Dashboard Course You will be able to know:

• How to create dashboard in Excel
• Link worksheet data to cells and shapes
• Hide and filter table data
• Changing the Excel program window to meet your needs