Review what we remember about spreadsheet terminology and apply some of the basic spreadsheet tools. You will explore the autofill command and practice simple spreadsheet layout techniques, adding and deleting rows and columns etc.

When you click on the 'download - spreadsheet' link, the practice file will open in a Google Sheet, you can select to download this as an Excel file too. Remember to save all your practice files.

 Calculating with Spreadsheets

 Objectives:

In this lesson you will review and extend you use of formulae in a spreadsheet, you will use basic mathematical operators like +,-,* and divide and you will look at the use of a 'what -if' scenarios in spreadsheets.

Getting creative with functions

Objective: To explore the use of functions

Both Excel and Google Sheets provide an extensive range of functions for:

• maths and trigonometry

• finance and statistics

• logic and 'lookup'

• conditional calculations

• dates and times

• data and text manipulation

Using functions avoids the necessity to construct complex formulae yourself, and lets you do things for which you couldn't write a formula.

Using a spreadsheet to work with data sets.

A spreadsheet can also be used to handle lots of data, much like a database does. There are some significant differences, but lets see what a spreadsheet can do with a data set.

When your using a spreadsheet to work with lists of data, use the tools provided to make it easier to find and manage information.

Lists of data can be:

• Sorted into a different order

• Filtered by multiple criteria

In addition, Google Sheets includes features that are particularly useful when collaborating:

• Filter views - change your view of data without affecting what others see

• Sort and filter functions - leave the data set unchanged

Explore some of the advanced spreadsheet data handling functions. 

Using the 'look up' function to find related data based on a unique field.