Module 1: Introducing the Microsoft Excel Charting
Explore various types of Excel Charts
Identify the relevant chart for different scenarios, presentations and purposes
Familiarize the distinctive components in creating charts
Create Essential Charts – Combination Chart, Column Chart and a Bar of Pie Chart
Module 2: Chart Sparklines to Spot Data Trends
Leverage the feature of Sparklines – enable audience to analyse trends on the spot.
Discover the Types of Sparklines – Line, Column, Win/Loss
Apply changes in Sparklines – The Style, The Sparkline Type, Points on the Sparkline and Display Range
Module 3: Key Data Visualization Options
Select the most relevant charts for different presentations, scenarios and purposes.
Thermometer Chart – Tracks attainment on how much on a goal has been achieved
Target Conditional formatting – Indicates Max and Min points with comments
Line Chart with KPIs Colored band – presents a clearer and distinct visualization context
Variance Chart – Indicates the actual performance against expected performance
Waterfall Chart – Understands the cumulative effect of positive and negative values impacting a subtotal or total value
Module 4: Applying Interactive Charts
Apply crucial formulas in setting a framework of a feasible, dynamic and Interactive Chart
Create chart that automatically expand as new data is entered
Produce Charts that are scalable, feasible which enable users to automatically update, summarize trends, report of a latest 12 month period
Incorporate dynamic scroll bar to increase and decrease the data range of the chart
Insert checkboxes to allow users to choose what to display