Microsoft 365, Session 4: Processing numerical data using Microsoft Excel, Part 1

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

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

• understand the purpose of a spreadsheet
• understand the concepts of a cell, row, column and sheet.
• understand the use of cell references
• format and edit cells (key in data, wrap text, merge and unmerge cells, align text, add borders and shading, adjust text direction)
• use the autofill feature
• use number formats (general, number, currency, text)
• resize rows and columns
• sort data up to two levels
• format and edit spreadsheets (paper size, page margins and page orientation)
• set a Print Area and Print Titles (gridlines, repeat rows/columns)

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.