A spreadsheet program is a software application that organises information (data) into a grid or table of columns and rows.

The data can then be analysed using mathematical formula that relates one cell to another cell or group of cells.

The data can also be sorted, filtered and copied.

Producing a spreadsheet document is viewed as a basic skill that all workers are now expected to have.

The skill level that will be expected of you will depend on the position you hold but at least basic skills are expected in modern business.

$95.00 Price

135 mins Estimated Time

Components in this Module

1 - Introduction

  • Introduction

2 - Safe Work Practices

  • Ergonomics
  • Bell Curve
  • Setting up your Desk
  • Standing Desk
  • Office Environment
  • Varying your Work
  • Exercising
  • Checkpoint 1

3 - Environmental Practices

  • Office Environmental Practices
  • Checkpoint 2

4 - Producing spreadsheets

  • Microsoft Excel
  • The Microsoft Ribbon
  • The Microsoft Side Bar
  • Templates
  • Organisational Style Guide
  • What is a Spreadsheet?
  • Purpose of the Spreadsheet
  • Audience for your Spreadsheet
  • Checkpoint 3

5 - Getting Started with a Spreadsheet

  • Naming Spreadsheet Cells
  • Match the Cells Challenge
  • Cell Adjustments
  • Adding in a Column or Row
  • Layout and Design
  • Branding
  • Background
  • Styles
  • Checkpoint 4

6 - Working with a Spreadsheet

  • Entering Data
  • Formatting Cell Data
  • Automatic Functions
  • Spreadsheet Features and Formatting
  • Freeze Panes
  • Freeze Multiple Rows or Column
  • Features for Printing
  • Getting Help
  • Checkpoint 5

7 - Working with Formula

  • Formula
  • Addition
  • Auto Sum
  • Subtraction
  • Multiplication
  • Division
  • What is the Answer to the Formula?
  • Average
  • Maximum and Minimum
  • More Complex Calculations
  • Checkpoint 6

8 - Working with Charts

  • Charts
  • Creating Charts
  • Modify Charts
  • Match the Data Challenge
  • Checkpoint 7

9 - Finalise Print and Save

  • Adjust
  • Proofreading
  • Finalise
  • Printing your Spreadsheet
  • Print Options
  • Present the Document
  • Saving your Document
  • PDF Documents
  • Document Names
  • Store and Back up Data
  • Operating a Keyboard
  • Checkpoint 8
  • Congratulations

Pre-requisite?

No previous knowledge or experience is required.

How long?

The online courses are made up of a number of learning modules. Each module has an estimated time to complete them (click on the ‘i’ next to the module to get the time).
The time to complete a module can vary based on your existing knowledge of the material.
No need to finish the course in one session. You can log in and out as many times as you like, until the course end date. The course end date is shown when entering the training. The system remembers what you have completed and you can continue on from where you left off.

How does it work?

Once we receive confirmation of your payment (which could take up to 24 hours), you will receive an email with your login details. Go to the login page which will be emailed to you. Enter your details then click on the name of the course when you are ready to start.

How do I pay?

Pay with mastercard or visa through our secure PayPal internet payment facility. You can also select to ‘Generate an Invoice’ or ‘Make An Enquiry’ and we will get back to you with a group pricing as a quote or submission for you to respond to.

Who should do this course?

These courses are for anyone who wants to learn more or wants to extend their resume by becoming more knowledgable in their company.

How will I be assessed?

Each module is broken into sections with checkpoints, interactive challenges and quiz questions throughout. You are required to go through each section and answer every question correctly to be deemed competent. If you answer any questions incorrectly, you will be given feedback on which question you answered incorrectly. You can then correct your response and continue.

Will I receive a certificate?

These are non accredited corporate-based short courses and if successful you will receive a Certificate of Completion.

Steps to proceed with enrolling in a Course

Step 1 – Select a Course(s) by adding it to the Shopping Cart.
Step 2 – Pay for the course (using Paypal).
Step 3 – Once we have received the payment we will send you an email confirming your order.
Step 4 – This email will have instructions for connecting to the course, your login ID and password.
Step 5 – Complete the online course.
Step 6 – Once the course has been successfully completed, you will have access to your certificate.

If you have any problems or questions just call us on (02) 9635 0477 or email training@alliedrisk.com.au

No courses or modules in the cart.