Spreadsheets
BCS IT User - Level 1
Course Contents
Spreadsheets
Course Set up Instructions
Getting Started
Starting the Excel program.
Opening a workbook stored in a particular folder.
Types of data used within a worksheet.
Understanding spreadsheet components and their layout.
Cells.
Rows.
Columns.
Worksheets and workbooks.
Closing a workbook.
Exiting Excel.
Ways of inputting your data.
Entering numbers and text.
Using your first function.
Default text and number alignment.
Exiting Excel and saving your data at the same time.
Saving a workbook to a particular folder, using a particular file name.
Creating a new workbook.
Good practice when entering data.
Good practice when naming and storing files.
Manipulating your data
Selecting a cell.
Selecting a range of cells by dragging the mouse
Selecting a range of cells using the keyboard.
Deleting cell contents.
Inserting additional cell content, or modifying existing cell content.
Using the Undo and Redo buttons.
Copying and moving data between cells using the Clipboard.
Copying and moving data between cells using drag and drop.
Finding text in a worksheet.
Finding and replacing text within a worksheet.
Adding or deleting rows and columns within a worksheet.
Analysing and Interpreting Data
Summarising and Displaying Information
Tools and techniques available to summarise and display information.
Good practice when creating or editing lists.
Sorting a list in ascending alphabetical order.
Sorting a list in descending alphabetical order.
Sorting a list in ascending numerical order.
Sorting a list in descending numerical order.
Functions and Formulas
SAMPLE ONLY - NOT TO BE USED FOR TRAINING
Copyright Cheltenham Courseware Pty. Ltd. - www.cheltenhamcourseware.com.au
