1. Training Room 4

INF2080

Project 3: Spreadsheet Skills

 

Training Room 4: Presenting Data Visually

 

This image shows a pie chart, bar graph, and 3D bar graph.

© Sean Gladwell/shutterstock

Each training room you complete adds to the skill set you are developing in working with spreadsheets. In Training Room 4 you will advance your knowledge of charts, chart tools, and sorting and filtering information.

 

In this training room you will

  • review charts
  • create and format charts
  • create, modify, and format pie charts and scattered charts
  • change chart layouts
  • create a clustered column graph
  • add graphics to charts from outside sources
  • apply a two-component sort
  • apply a two-component filter
How to Do It

 

To successfully complete this training room, do the following:

  • Read and watch instructional videos of topics covered in the training room.
  • Use help and online references should you require additional instruction or software assistance.
  • Complete the Time to Practise 4 exercise.

You are now ready, once again, to start working in Microsoft Excel 2007. Open Training Room 4: Presenting Data Visually, and follow the instructions, starting with an introduction to charts. Save your Training Room 4 in your INF2080 SS2 folder.