Welcome to the Pearl Cove Library Excel Basics Course!



In this Online Learning Course, designed for Pearl Cove Library staff, we will be introduced to the basics of Microsoft Excel. The aim of this course is to equip PC Library staff to be able to make use of the Excel programme for work related duties.

At the end of this course you will be able to:

                     describe the WHS issues associated with computer use
                     locate Microsoft excel on the computer
                     Identify possible uses of excel in the workplace
                     create a basic excel spreadsheet
                     enter data into an Excel Spreadsheet
                     complete basic formatting of an Excel spreadsheet

Additionally, you will be given access to resources that will facilitate further learning on the subject should you wish to pursue additional learning, including

                     Data sorting
                     Basic Formulas and Functions
                     Further formatting of an Excel spreadsheet
                     Creating and renaming additional worksheets in a document
                     Data validation, consolidating and removing duplicates
                     Protecting a workbook or cells within a workbook

To complete this course, you will require access to a copy of Microsoft Excel for Windows or Mac*.


*Please note, this course was designed for users of Microsoft Excel for Windows.


These pages link to tutorial pages that deal with each of the areas we will be learning about in this course. If you are a complete novice with Microsoft Excel and other Office products, you will find it easiest to move through the lessons in numerical order. If you have used Microsoft Office before, you may be able to skip some of the earlier lessons.


In LESSON ONE, we will begin with Ergonomics, and the importance of WHS when using Excel.