Data Visualisation in Excel

Learning Objectives

Create and format effective visualizations using Microsoft Excel. Apply PivotTables and charts for summarizing data. This ensures learners can leverage Excel’s built-in tools to produce accurate, professional-quality visual reports for data exploration and presentation.

Indicative Content

• Basic charts in Excel:

  • Bar charts: Simple, stacked, and horizontal bar charts.

  • Pie charts and doughnut charts: Representing proportions.

  • Treemaps: Hierarchical visualizations of category sales.

• Statistical plots in Excel:

  • Histograms: Showing distribution of a variable.

  • Box Whisker Plots: Visualizing quartiles and outliers.

  • Scatter plots: Exploring correlations between two numeric variables.

  • Bubble charts: Representing three variables in Excel.

• Using PivotTables for data aggregation:

  • Creating pivot charts for summarizing data.

• Interactive filtering with slicers:

  • Applying slicers for dynamic data exploration.

• Automating chart updates using macros or Power Query could be beneficial for reporting workflows.