Data Visualisation With Excel Dashboards

by James Cook Institute Claim Listing

This course aims to equip learners with the necessary skills and knowledge to create insightful and impressive management reports using the various tools in Microsoft Excel.

S$348.8

Contact the Institutes

Fill this form

Advertisement

James Cook Institute Logo

img Duration

8 Hours

Course Details

This course aims to equip learners with the necessary skills and knowledge to create insightful and impressive management reports using the various tools in Microsoft Excel.

 

Target Audience:

  • This course is aimed at participants who have attended the basic Microsoft Excel course or have some working knowledge of Microsoft Excel.

 

Course Outline:

  • DASHBOARD FUNDAMENTALS
  • What is a dashboard
  • Key characteristics of a dashboard
  • PLANNING CONSIDERATIONS
  • Define information needs
  • Acquire and arrange data
  • DASHBOARD DESIGN CONSIDERATION
  • Dashboard Dos and Don’ts
  • Selecting appropriate tools
  • Determine chart elements and colour selection
  • Histogram
  • REPORTING WITH PIVOTTABLE AND PIVOTCHART
  • Insert and populate a PivotTable and PivotChart
  • Update PivotTable data
  • Using Slicer
  • ADVANCED EXCEL TOOLS
  • Conditional formatting
  • Using Range Names
  • Create Drop-down list with data validation
  • OBTAIN DATA WITH EXCEL FUNCTIONS
  • Use Lookup and Reference functions
  • Use INDEX and MATCH functions
  • Database functions
  • CREATE EXCEL CHART
  • Create standard charts
  • Combination chart
  • Sparkline
  • CUSTOMISING CHART ELEMENTS
  • Format axis
  • Display/format Data Labels
  • ADVANCED CHART TYPES
  • Pareto chart
  • Box & whisker chart
  • Gauge or Speedometer chart
     
  • Central Branch

    150 Orchard Rd, #06-14, Central

Check out more Data Visualization courses in Singapore

Impress Training Logo

Power BI For Beginners

This course provides participants with the knowledge and skills to work with and analyze data and work with business cases using Microsoft Power BI.

by Impress Training [Claim Listing ]
COMAT Logo

Data Visualization with Power BI

This two-days instructor-led course provides students with the knowledge and skills analyze data with Power BI. Use Power BI Desktop to connect to data (usually multiple data sources), shape that data (with queries that build insightful, compelling data models)

by COMAT [Claim Listing ]
Singapore Polytechnic Logo

Data Wrangling, Analysis and Visualisation

In today's era of big data where the computer and network are everywhere and business process may be translated to data, data manipulation and visualisation skills are much needed to make insightful decisions.

by Singapore Polytechnic [Claim Listing ]
IMA Logo

Data Analytics and Visualization for Accounting Professionals (Beyond the Basics)

Accounting has always been about analytical thinking. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software.

by IMA [Claim Listing ]
COMAT Logo

Complete Data Analytics For Beginners

In this course, participants will be introduced to the basic concepts of Data Analytics. This knowledge could help us understand our data better, and in many contexts enable us to make better decisions.

by COMAT [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy