Excel Dashboard Training

Singapore Excel Dashboard Course

Excel Dashboard Course Objectives:

In this Excel dashboard training course 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 Course 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.

You can use Microsoft Excel Dashboard to generate automated reports of your each department and view under one file. You can view it as charts, tabular formate or index format.

After 2 Days 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 Excelprogram window to meet your needs

Perquisites:

The course requires advanced Excel knowledge, kindly help us do this quiz to check your level before start the training: Inspizone – Quick test

Course Outline For This Singapore Excel Dashboard Training

Creating Advanced Formulas

• Use Range Names in Formulas
• Use Specialized Functions

Automating Workbook Functionality

• Apply Data Validation
• Work with Forms and Controls

Applying Conditional Logic

• Use Lookup Functions
• Combine Functions

Visualizing Data with Basic Charts

• Create Charts
• Modify and Format Charts

Advanced Charting Techniques

• Use Advanced Chart Features
• Create Sparklines

Analyzing Data with PivotTables, Slicers, and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Slicers

Course Fees:

S$450.00/Pax+ 9% GST (GST applied from 1st Jan 2023))

Discount policy (Applied from 1 Jun 2023 – 31 Dec 2023):

• 4 pax from the same group: 5% discount for each person
• 5 pax from the same group: 10% discount for each person

Funding :

For the Company sponsorship: SDF claimable from Skillsconnect $2/ hours claimable ($14/pax/training-day) (Singaporean and PR)

For the Individual sponsorship: 

Singaporean individual above 25: Claimable from Skillsfuture credits (Except mid-career transition credit)

NTUC union member can claim from UTAP funding 50% of the unfunded course fee

• Unfunded course fee is the balance course fee payable after applying government subsidy.  
• Enjoy up to $250 *unfunded course fee support when you sign up for courses supported under UTAP. NTUC members aged 40 and above enjoy higher funding support up to $500 each year, capped at 50% of *unfunded course fees, for courses starts before 31st March 2025.
• For more details, kindly visit: UTAP

Course Schedule :

From 8 participants joining together, we can open a new class on the requested schedule, subject to trainer availability (No group discount applied to this).

Corporate Training:

We can conduct corporate customized class for a group of a min of 12 persons.

Trainers: 

All our trainers are ACTA Certified and have more than 10 years’ of experience.

Certificate: 

A Certificate Of Achievement will be issued upon completion of course

Excel Dashboard Training Course Benefits

• Informed Decisions- Provide actionable insights for decision-makers.
• Time Savings- Streamline data analysis and reporting processes.
• Tailored Solutions- Customize dashboards to meet specific needs.
• Automation- Keep dashboards updated with dynamic data
• Collaboration- Foster teamwork with easily shareable dashboards.

We also offer excel 2013 and Excel 2010 training courses. Register Now for quick enquiry to Find here a range of courses from best microsoft excel courses.

*If you are Singaporean and you have $500 with Skillsfuture, you no need to pay upfront fee and your fees will be paid by SkillsFuture upto $500*.