Black Friday Offer till Nov 30th ! Unlimited Continuing Education only @$199 ! CLICK HERE to view.

Data Visualization using Excel

You need to register for the webinar to watch the video.

Click Here to Register

Before starting this self study program, please go through the instructional document.

Overview

  • Relationship and sequence of power point
    3 mins
  • Learn to process of data visualisation
    16 mins
  • Explanation of different types of charts
    32 mins
  • Comparison among items
    59 mins
  • Sample to show steps
    67 mins

Course Description

In an age now driven by "big data", we need to cut through the noise and present key information in a way that can be quickly consumed and acted upon making data visualization an increasingly important skill. Visualizations need to not only present data in an easy to understand and attractive way, but they must also provide context for the data, tell a story, achieving that fine balance between form and function.

Excel is commonly used and easily available tool for data analysis and working with data. However, when you think data visualization, you might not think of Microsoft Excel. However, Excel offers a large number of charts and graphing tools that complement its data analysis toolset. Combining the best of power query and power pivot, Excel can help to create data visualization and dashboard very effectively.

This CPE course offers a laser-focused, practical guide to most useful Excel charts and graphs for data visualization. Instructor of this CPE webinar Manish Gupta reviews the key principles of data visualization, and provides expert tips to help you customize any kind of chart in Excel.

Major topics covered in this Excel CPE webinar:

  • Charting 101 - create a basic chart
  • From drab to fab - enhance and customize a basic chart
  • Combination charts - line and bar in a single chart
  • Dynamic charts - automate adding new data to a chart
  • Creating in-cell Sparkline charts
  • Creating info graphics with Excel
  • Creating a heat map using Conditional Formatting
  • Data Visualization using symbols and icons

Learning Objectives

  • To discuss principals of data analysis & visualizations 
  • To discuss most commonly used charts, power pivot and queries
  • To describe how to create custom charts in excel
  • To describe data connections and models 
  • To explain the process for generating dashboards and creating interactivity

Who Should Attend?

  • Business Owner
  • CEO
  • Certified Management Accountant
  • Certified Public Accountant
  • Certified Valuation Analysts
  • CFO/Controller
  • Finance Pros