courses a z hatregister key smalltimetable-btn calendar4 001

Font size

Spreadsheets: Microsoft Excel

excel logoExcelexcel spreadsheets2Excel

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.

Please register early to secure your place in our Courses and Workshops:

  • Click here (Timetable) to see if there is currently a course scheduled.
  • You need to supply the name of course or workshop and your membership number.
  • If the course you want is not listed on the Timetable please email learner@seniornetnelson.org.nz
  • NOTE - There is no need to enrol for Interest Groups, Help Sessions or Club Day Meetings, just turn up
  • REMEMBER - You need to be a paid-up member of SeniorNet Nelson to take a course.