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.