Data Analysis – Skills Checklist

The list below shows you the skills that you should be comfortable with in terms of document production. Work through the list and check off all of the skills you currently have. Any areas that you have not checked must be revised.

The ‘Where can I find help’ section refers to the Section 14 Self Study Workbook found on this web page:

Skill / Can I do this? (tick) / Where can I find help?
Spreadsheet Basics:
  1. Do I know what a data model is
/ Page 4
  1. What is an active cell
/ Page 4
  1. What is a cell reference
/ Page 4
  1. Writing simple formulae
/ Page 5
  1. Resizing column widths
/ Page 6
  1. Autofil
/ Page 7
  1. Absolute cell references
/ Page 8
  1. Printing spreadsheet values
/ Page 9
  1. Adding data into spreadsheet Header/Footer
/ Page 9
  1. Showing and printing spreadsheet formulae
/ Page 10
  1. Check for accuracy
/ Page 11
Simple Formulae:(add, subtract, multiply, divide, indices)
  1. Formulae with mathematical operators
    (+, -, *, /, ^)
/ Page 11 - 13
  1. Use named cells within formulae
/ Page 14
  1. Use named cell ranges within formulae
/ Page 15
Simple Functions:(SUM, AVERGAE, MAX, MIN)
  1. Write a SUM function
/ Page 16 - 17
  1. Write an AVERAGE function
/ Page 18
  1. Write a MAX function
/ Page 18
  1. Write a MIN function
/ Page 19
  1. Use the FUNCTIONS menu rather than write each function manually
/ Page 19 - 20
Functions that Manipulate Numbers:(INT, ROUND, COUNT, COUNTA, COUNTIF)
  1. Write an INT function
/ Page 21 - 22
  1. Write a ROUND function
/ Page 22 - 23
  1. Write a COUNT function
/ Page 24
  1. Write a COUNTA function
/ Page 25
  1. Write a COUNTIF function
/ Page 26 - 29
  1. Write a SUM IF function
/ Page 30 - 32
  1. Write a SUM IF with NOT criteria
/ Page 33 - 34
  1. Write a COUNT IF with NOT criteria
/ Page 35 - 36
More Complex Functions:(IF, NESTEDIF, IFAND)
  1. Write an IF function
/ Page 37 - 39
  1. Write a NESTED IF function
/ Page 40 - 42
  1. Write an IF AND function
/ Page 43 – 44
Functions that Look Up data:(HLOOKUP, VLOOKUP)
  1. Write a HLOOKUP function
/ Page 45 - 47
  1. Write VLOOKUP function
/ Page 48 - 49
  1. Write a LOOKUP function across 2 different spreadsheets
/ Page 50 - 52
Using Filters to Interrogate data:
  1. Use filters to interrogate text data
/ Page 52 - 53
  1. Use filters to interrogate number data
/ Page 54 – 56
Graphs and Charts:
  1. Create different types of charts
    (column, line, pie, bar etc)
/ See video section on section 14 web page for help on all of the chart skills
  1. Add titles to a chart

  1. Add vertical and horizontal labels to the chart

  1. Showing and hiding chart legend / key

  1. Create a chart from data that is in cells not adjacent to each other

Columns and Rows:
  1. Showing and hiding columns and rows
/ See video section on ictlounge section 14
Printing Charts:
  1. Use print preview to check for accuracy before sending to printer
/ See video section on section 14 web page for help on all of the printing skills
  1. Setting printout to landscape / portrait

  1. Printing specific areas of a spreadsheet

  1. Printing spreadsheet gridlines

  1. Printing spreadsheet column / row headings