Office 365 Excel Essentials Coursework

STUDY ONLINE WHEREVER YOU ARE!

Office 365 Excel Essentials Certification

Course Duration: 12 hours - Requisition: 28 days

With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Of­fice applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved.

The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere. 

Career Pathway 

  • Personal Development
  • Family Business Owner
  • Small Business Owner
  • Secretarial
  • Personal Assistant
  • Retail Venture
  • Office Assistant
  • Office Manager/ Supervisor
  • Manufacturer Executive

Assessment

  • Case Study
  • Multiple choice questions quiz

Benefits

  • Gain quality workplace skills and experience to help launch your career.
  • Develop work-related skills and experiences that are recognized by employers. 
  • Develop independence and confidence in an adult learning environment. 
  • Gain an insight into various industry areas to help you decide on a career pathway. 
  • Potentially gain recognition for prior learning for your previous study or work.
  • High-quality course written by industry experts with easy to understand course content
  • Course materials provided online with unlimited tutor support – no textbooks to buy
  • Gain an Australian Certificate upon your successful completion of coursework (Certificate hard copy will be posted to you)
  • Course may be tax deductible - see your tax advisor

Coursework Objectives: 

  • Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
  • Understand the Excel 365 browser interface
  • Upload a spreadsheet to the Shared Documents library 
  • Download and reload workbooks
  • Understand saving and collaborating
  • Build, copy and edit formulas
  • Understand the difference between Formulas and Functions
  • Sort and filter data
  • Collaborate with others on a spreadsheet
  • Use alignment options
  • Apply borders and fill color
  • Insert and work with Tables and Charts
  • Insert links

Course Contents

Administrative Skills

Module One: Getting Started

Coursework Objectives

Module Two: Welcome to Office 365 Web Apps

The Home Page

The Team Site

Shared Documents

Uploading a Spreadsheet

Module Two: Review Questions

Module Three: Worksheets and Workbooks

Opening a Spreadsheet

Overview of the Reading View

Understanding Worksheets vs. Workbooks

Downloading and Reloading

Closing Spreadsheets

Module Three: Review Questions

Module Four: Working with Excel Files

Using the Find Command

Saving a Copy

Editing in Browser

The Excel Web App Interface

Opening in Excel

Module Four: Review Questions

Module Five: Editing in the Browser (I)

About Saving and Save As

A New File and AutoSaving

Entering Data

Editing Data

Using the Wrap Command

Module Five: Review Questions

Module Six: Editing in the Browser (II)

Cut, Copy, and Paste

Using Undo and Redo

Adding Rows and Columns

Deleting Cells

Using Timesaving Shortcuts

Module Six: Review Questions

Module Seven: Building Formulas

The Math Basics of Excel

Building a Formula

Editing a Formula

Copying a Formula

Relative vs. Absolute References

Module Seven: Review Questions

Module Eight: Understanding Functions

Formulas vs. Functions

Using the SUM Function

Using Other Basic Excel Functions

Using AutoComplete

Module Eight: Review Questions

Module Nine: Working with Data

Sorting Data

Filtering Data

About Collaborating

About Refreshing External Data

Module Nine:  Review Questions

Module Ten: Formatting Your Data

Changing the Appearance of Text

Changing the Appearance of Numbers

Setting Alignment Options

Adding Borders

Adding Fill Color

Module Ten: Review Questions

Module Eleven: The Insert Tools

Inserting Tables

Inserting Charts

Working with Charts

Inserting Links

Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise

Course curriculum

  • 1
    MODULE 01
    • Office 365 Excel Essentials Getting Started
  • 2
    MODULE 02
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study Module 02
    • Office 365 Excel Essentials Module 02 Quiz
  • 3
    MODULE 03
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study Module 03
    • Office 365 Excel Essentials Module 03 Quiz
  • 4
    MODULE 04
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study Module 04
    • Office 365 Excel Essentials Module 04 Quiz
  • 5
    MODULE 05
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study Module 05
    • Office 365 Excel Essentials Module 05 Quiz
  • 6
    MODULE 06
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study Module 06
    • Office 365 Excel Essentials Module 06 Quiz
  • 7
    MODULE 07
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study Module 07
    • Office 365 Excel Essentials Module 07 Quiz
  • 8
    MODULE 08
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study Module 08
    • Office 365 Excel Essentials Module 08 Quiz
  • 9
    MODULE 09
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study Module 09
    • Office 365 Excel Essentials Module 09 Quiz
  • 10
    MODULE 10
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study 10
    • Office 365 Excel Essentials Module 10 Quiz
  • 11
    MODULE 11
    • Office 365 Excel Essentials
    • Office 365 Excel Essentials Case Study Module 11
    • Office 365 Excel Essentials Module 11 Quiz
  • 12
    Module 12
    • Office 365 Excel Essentials Wrapping it Up
  • 13
    Rate
    • Rate Office 365 Excel Essentials Course

Our courses can be used to turn your career towards a new direction

Those who have completed courses in fields unrelated to their careers show an open and interested mind, an enthusiastic attitude and a lust for life.

Do You Have Any Questions?

We are happy to assist you in any course or bundle enquiries that you may have.

CONTACT US TODAY