Spreadsheets: Microsoft Excel
2 x 2-hour lessons $20
For Windows or Mac users
Overview
Microsoft Windows Excel is used for Spreadsheet and Database lessons.
Prerequisites
- You need to be familiar with common computer techniques typically used through web browsing, emailing, word processing.
- You need a basic understanding of arithmetic functions, addition, subtraction, multiplication, and division.
Learning Objectives
You will learn about:
- Screen basics
- Data entry into a spreadsheet
- Editing and formatting
- Using standard toolbars
- Calculations, formulas and functions
- Saving files
- Copying and printing sheets
- Recording financial transactions
- Constructing a database
- Managing, sorting and filtering data
- Using the drawing toolbar
- Creating charts
- Other practical uses.
On completion of the course you should be able to:
- Prepare a spreadsheet, edit and format it
- Apply formulas and functions to a spreadsheet
- Use the standard and drawing toolbars
- Create charts from spreadsheet data
- Set up a database, manage, sort and filter it
- Save an Excel file
- Print and copy spreadsheets or database information
- Select from a range of other practical uses of Excel.
STYLE-->
Desired Outcomes:
When you have completed the course you should be able to:
Ø Prepare a spreadsheet, edit and format it,
Ø Apply formulas and functions to a spreadsheet,
Ø Use the standard and drawing toolbars,
Ø Create charts from spreadsheet data,
Ø Set up a database, manage, sort and filter it,
Ø Save an Excel file,
Ø Print and copy spreadsheets or database information and
Ø Select from a range of other practical uses of Excel.
