• aaaflax.jpg
  • city-compressed.jpg
  • Marina.jpg
  • ship.jpg
Font size

Spreadsheets: LibreOffice Calc

libreoffice logo
libreoffice calc sheet

2 x 2-hour sessions   $20
For Windows, Mac or Linux users

 

Overview

LibreOffice is a FREE suite of programmes, similar to Microsoft Office, and includes LibreOffice Writer (similar to Microsoft Word), LibreOffice Impress (similar to Microsoft PowerPoint) and LibreOffice Calc (similar to Microsoft Excel). To find out more about LibreOffice Calc click here.
To download this suite go to www.libreoffice.org/discover/libreoffice/

Spreadsheet programs can be very sophisticated professional pieces of software used for business purposes, but they are also able to be used in the home to record and analyse simple household lists and finances, such as you may already record on paper. This Introduction to LibreOffice Calc is designed to enable home users to "open the door" to the many useful ways you can take advantage of this software. 


Prerequisites

  • You need to have the LibreOffice suite downloaded on your computer or laptop.
  • You may use the Learning Centre computers during the course, or bring your own laptop. 
  • 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.
  • If you wish to save your work to take home you can bring your own USB stick.

Learning Objectives

A take-home DVD containing all the relevant data and background study data will be issued to students, and this will be used during the learning sessions. We will use a preprepared spreadsheet and the aim is to introduce you to spreadsheets in the LibreOffice environment. 

You will learn to:

  • Identify ways of utilising spreadsheets.
  • Manipulate a spreadsheet.
  • Record data and create, copy and paste formulas and functions.
  • Acquire information using various resources.
  • Navigate toolbars and menus
  • Review worksheets, workbooks and their components
  • Use basic formulas in LibreOffice Calc.
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.

Click the image for a timetable of courses coming up in 2017

Timetable for 2017

Click the image for information on how to register for a course.

How to register for a course

Become a tutor

Tutoring is a lot of fun. If you want to know more...

HELP! Become a tutor

Help and Practice

Mac Interest Group

Tehnical Interest Group

iPad Interest Group

Android Interest Group

Digital Imagery Group

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

  • Click Timetable to see if there is currently a course scheduled.
  • NOTE - There is no need to enrol for Interest Groups, Help Sessions or Club Day Meetings.