Microsoft 365, Session 5: Processing numerical data using Microsoft Excel, Part 2

Welcome to Processing numerical data using Microsoft Excel, Part 2. 

By the end of the session, you will be able to:

• produce a marksheet
• use formulae to perform calculations (addition, subtraction, multiplication and division)
• understand the order of preference
• understand the difference between and among Cell Names, Ranges and References
• use basic functions to solve simple problems (MIN, MAX, SUM, COUNT and AVERAGE)
• identify problems based on error indicators (#VALUE!, #NAME?, #NUM!, #REF! and #DIV/0!)
• troubleshoot basic errors in formulae and functions
• work with sheets in a workbook (insert, delete and rename)
• perform calculations using functions (COUNTA, COUNTBLANK, ROUND and COUNTIF)
• present numerical data
• create graphs/charts from given data and choose appropriate graph types (column, line and pie)
• edit graphs (chart title, axis titles, data labels and legend)
• troubleshoot basic problems in graphs

We suggest that you download the Class Notes first so you can follow along during the training.

Download the glossary below to quickly remind yourself what the various computer terms mean.