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

Garranto Academy Logo

Data Analytics & Business Intelligence Tools

Numerous organizations and individuals today are embarking on the journey of digital and data transformation. Business intelligence is the process of turning data into actionable insights that help a company accomplish its objectives.

by Garranto Academy [Claim Listing ]
NTUC LearningHub Logo

Data Analysis Using Excel

This course is intended for anyone who wants to stretch their data analysis capabilities using Microsoft Excel starting with a block of data to a table of data, going beyond just functions and formulas, and picking up more advanced capabilities leading to data preparation

by NTUC LearningHub [Claim Listing ]
Scribble Academy Logo

Data Analytics Course

The digital age has transformed how organizations leverage data and analytics to drive their business decisions. Almost any organization requires data in the form of simple reports or advanced visualizations to support their business.

by Scribble Academy [Claim Listing ]
  • Price
  • Start Date
  • Duration
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 ]
CASUGOL Logo

Data Analytics Overview Using Python x ChatGPT

Acquire essential knowledge on the role of data analytics in various industries and decision-making processes and the prowess of Python Programming x ChatGPT as a tool for data analysis

by CASUGOL [Claim Listing ]

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