Duration: 2 days
Time: 9am to 6pm

What Will Be Taught For This Excel Dashboard Course?

An Excel Dashboard provides insight, analysis and alerts. Get a head start in acquiring the knowledge of creating an interactive dashboard allowing the user to filter data and switch views themselves. There a numerous and a varied number of new tips you will learn irrespective of the Excel version used. The course is for users at all levels, from beginners through intermediate and advanced.

Learning Outcome

By the end of the course, participants will be able to:

  • Apply statistical and logical function to summarize your data
  • Analyse large amount of data through PivotTable
  • Automate repetitive task with macros
  • Build and assemble your dashboard
  • Create form control to filter your dashboard
Module 1. Auditing Tools and Range Name
  • Jumping to a Named Range
  • Assigning Names
  • Using Range Names in Formulas
  • Creating Range Names from Headings
  • Applying Range Names
  • Deleting Range Names
  • Using Range Names in 3-D Formulas
  • Displaying/Removing Dependent Arrows
  • Displaying/Removing Precedent Arrows
  • Showing Formulas
  • Labs
Module 2. Statistical and Logical Functions
  • Using the COUNTIF Function
  • Using SUMIF Function
  • Using AverageA Function
  • Using IF function
  • Using IsError function to avoid error display
  • Creating multiple conditions using nested IF
  • Using logical function OR, And within IF
  • Labs
Module 3. Lookup and Reference Formulas
  • Using Vlookup to find specific data
  • Using Hlookup to find values in rows
  • Using Match and Index to retrieve data
  • Practice
Module 4. Conditional Formatting
  • Creating Conditional Formatting
  • Editing Conditional Formatting
  • Adding Conditional Formatting
  • Custom Number Formats
  • Labs
Module 5. Creating PivotTables
  • Creating a PivotTable Report
  • Adding PivotTable Report Fields
  • Selecting a Report Filter Field Item
  • Refreshing a PivotTable Report
  • Changing the Summary Function
  • Adding New Fields to a PivotTable
  • Moving PivotTable Report Fields
  • Using Expand and Collapse Buttons
  • Deleting PivotTable Report Fields
  • Creating Report Filter Pages
  • Formatting a PivotTable Report
  • Creating a PivotChart Report
  • Labs
Module 6. Recording Macros
  • Recording a Macro
  • Assigning a Shortcut Key
  • Deleting a Macro
  • Adding a Macro to Quick Access Toolbar
  • Deleting a Macro Button from QAT
  • Labs
Module 7. Using Macros Button
  • Using Macro Button
  • Create Macro Button
  • Formatting a Macro Button
  • Rename a Macro Button
  • Copy and Re-assign Macro Button
  • Moving/Sizing a Macro Button
  • Deleting a Macro Button
  • Labs
Module 8. Working with Dashboard
  • Creating Excel Dashboard
  • Applying Range Names
  • Create PivotChart
  • Create Combo Box to Filter Chart
  • Create Dynamic PivotChart Title
  • Create Macro to update PivotChart
  • Create Dynamic Chart with CheckBox
  • Create Links
  • Labs

Who Should Attend This Excel Dashboard Course Training?

Excellent course for professionals in Finance, Sales, Marketing, Engineering, IT and roles such as Project Managers, General Managers, Managing Directors, CXOs and Data Warriors dealing with large volume data and need to possess advanced techniques to convert them into actionable information.

Pre-requisite

An user of Microsoft Excel 2007/2010/2013/2016 for at least 1 year.

  w/o GST w GST
Course Fee $680 $727.60

This course is applicable for Skills Development Fund (SDF).


Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attained minimum 75% attendance in order to qualify for Funding.
  • Trainee undertakes to reimburse ST Electronics (e-Services) FULL course fees should he/she be ineligible for course fee grant. ST Electronics (e-Services) is not liable for any other funding not approved by WSG.
  • ST Electronics (e-Services) reserves the right to change the date or venue without prior notice.
  • ST Electronics (e-Services) reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.


Please click on the course date to enrol.