Collecting and Presenting Data

This article intends to walk through a process for collecting and presenting data. It will include some basic commands in Excel and Powerpoint. The slide deck below provides a step-by-step guide. You should follow it in order to complete the set tasks.

You will need the following to get started:


1. Replicate the following PDF file (but without the patterned fill): “aje_data_chart.pdf

2. Replicate the following PNG image (but without the patterned fill):

  • Download “aje_data_2.xlsx
  • Email me for the solution: “aje_data_3.xlsx”

Resources on data visualisation:

Some examples of good data visualisation:


The Economist is renowned for good data visualisations. Here is their advert for data journalists, demonstrating their expertise.

This is part of my online course on Analytics.

10 Replies to “Collecting and Presenting Data”

  1. Dear Antony,

    I would like to attend in the additional QM class on Feb10th.

    Thank you in advance for your time


  2. In

  3. In

  4. Anne Schlichting February 8, 2011 at 2:32 pm

    im in as well

  5. In

  6. Celia Ka Li Lok February 8, 2011 at 4:45 pm

    Celia in. Thanks for the extra class Anthony.

  7. I’m in too

  8. In

  9. Dear all – this is to confirm that the class will go ahead tomorrow. I look forward to seeing you all at 11am!

Comments are closed.