courses a z hat  register key    course timetable   google calendar icon
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.

Interest Group Quick Links (Find news about upcoming and previous meetings here)

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 contact@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.