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:


This is part of my online course on Analytics.

Share and be social

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.