Microsoft Excel – Beginners
An introduction to this popular programme will lead you through how to create spreadsheets, charts, perform calculations with formulae, and analyse numerical information. A course fee subsidy applies for permanent residents of NZ (conditions apply).
-
Mon 26 Jul
- TEC-subsidised course fee for qualifying students: $30.00 incl. GST
- $105.00 incl. GST
Sessions
Session 1
Mon 26 Jul 19:00 - Mon 26 Jul 21:00Selwyn College, Auckland.Session 2
Mon 02 Aug 19:00 - Mon 02 Aug 21:00Selwyn College, Auckland.Session 3
Mon 09 Aug 19:00 - Mon 09 Aug 21:00Selwyn College, Auckland.Session 4
Mon 16 Aug 19:00 - Mon 16 Aug 21:00Selwyn College, Auckland.Session 5
Mon 23 Aug 19:00 - Mon 23 Aug 21:00Selwyn College, Auckland. -
Sat 07 Aug
- TEC-subsidised course fee for qualifying students: $30.00 incl. GST
- $105.00 incl. GST
Sessions
Session 1
Sat 07 Aug 09:30 - Sat 07 Aug 15:30Selwyn College, Auckland.Session 2
Sun 08 Aug 09:30 - Sun 08 Aug 15:30Selwyn College, Auckland. -
Wed 20 Oct
- TEC-subsidised course fee for qualifying students: $30.00 incl. GST
- $105.00 incl. GST
Sessions
Session 1
Wed 20 Oct 19:00 - Wed 20 Oct 21:00Selwyn College, Auckland.Session 2
Wed 27 Oct 19:00 - Wed 27 Oct 21:00Selwyn College, Auckland.Session 3
Wed 03 Nov 19:00 - Wed 03 Nov 21:00Selwyn College, Auckland.Session 4
Wed 10 Nov 19:00 - Wed 10 Nov 21:00Selwyn College, Auckland.Session 5
Wed 17 Nov 19:00 - Wed 17 Nov 21:00Selwyn College, Auckland.
Description
NOTE: This course offers a course fee subsidy through funding from the Tertiary Education Commission (TEC) for NZ citizen and permanent migrant adults, and young people aged 16+ who are not currently enrolled in a NZ secondary school. We need to collect extra information such as age, ethnicity, educational achievement and gender for statistical purposes. You must also provide evidence of NZ citizenship or residency if requested. A condition of accepting this course fee subsidy is that you will attend at least 80% of classes.
About the course
An introduction to this popular programme will lead you through how to create spreadsheets, charts, perform calculations with formulae, and analyse numerical information.
Course outline
- What is Excel?
- What are spreadsheets and charts/graphs?
- What can we use Excel for - for personal use and in the workplace?
- The advantages of using Excel
- The Excel screen
- The Quick Access Toolbar
- Cell contents - labels, values, formulae
- Moving around a spreadsheet
- Selecting cells
- The AutoSum button
- The Fill handle - AutoFill
- Merging and Centre main and sub-headings
- Widening columns
- Formatting numbers and text
- Formatting and naming your Worksheet
- Saving, printing and closing
- Using Arithmetic Operators
- Borders
- Viewing your spreadsheet in Print Preview - adding Gridlines and Headers/Footers, centring horizontally and vertically
- Inserting/deleting Rows and Columns
- The Format Painter
- Select data in your spreadsheet and create a Chart/Graph
- Design your own spreadsheet from a brief
Who should attend?
Those wanting to learn the basic of Excel spreadsheeting. You should have basic computer skills and familiarity with Windows to attend this course. This course guides you through step-by-step projects designed to build your skill and confidence when using this software. If you are lacking confidence with computers, please enquire at the office about suitable courses.
Courses held on the school personal computers. Maximum class size 12 students.
Testimonials
From June 2020 course: "Dear Kathy Ma'am, you've been such an amazing teacher and friend who makes the whole session so lively and positive with your smile .I will always be thankful to have been taught by you. You have worked so hard. You are the spark, the inspiration. Wish you all the best. Love you, Niharika"
