Find your new direction

  • 1300 76 2221
  • Australian owned and operated since 2008

Microsoft Office Excel 2013


Course Outline and Topics

Course Overview

Microsoft Office Excel 2013 is an online professional development program that will provide you with the skills and knowledge required to develop spreadsheets using Microsoft Office Excel 2013. In this online excel course you will learn how to create simple and complex spreadsheets, produce charts, use chart design tools and work with formulae.

Businesses need to operate at the cutting edge of technology to remain competitive. It’s just as important for employees to be knowledgeable in the software that enhances business success.

If you want a career in business, you’ll want to be proficient in the Microsoft Office Excel 2013. This software is used by almost every company world-wide. The skills you acquire are transferrable, enhance your ability to communicate and collaborate effectively, increase your productivity and simplify business tasks.

Course Structure

Unit 1 - Develop and use complex spreadsheets Using Excel 2013

  • Select and prepare resources
  • Adjust workspace
  • Work place health and safety
  • Analyse task
  • Determine spreadsheet requirements
  • Spreadsheet terminology
  • Plan spreadsheet
  • Clarify tasks, input, design and layout
  • Data entry, storage, output
  • Reporting and presentation requirements
  • Organisational strategies
  • Energy and resource conservation techniques
  • Using Excel 2016
  • Linking spreadsheets
  • Quick Access Toolbar
  • Formulae and functions
  • Cell formatting
  • Test formulae to confirm output
  • Automate spreadsheet operations
  • Increase spreadsheet efficiency
  • Creating macros
  • Using templates
  • Checking spreadsheet ability
  • Data validation
  • Importing and exporting data
  • Online user manuals
  • File storage
  • Data in graphic form
  • Chart types
  • Manipulating spreadsheet data
  • Graphs with labels

Unit 2 - Create and use spreadsheets Using Excel 2013

  • Select and prepare resources
  • Adjust workspace
  • Work place health and safety
  • Reporting hazards
  • Organisational requirements
  • Recycle, reuse, reduce
  • Create simple spreadsheets
  • Excel screen
  • Consistency of design
  • Ranges
  • Formatting text
  • Alignments
  • Inserting or deleting rows
  • Inserting or deleting columns
  • Creating formulae
  • AutoSum
  • Using functions
  • Producing simple charts
  • Chart styles
  • Chart design tools
  • Protecting a worksheet


Written assignments and exercises, including short-answer questions, reports/essays and projects. There are no examinations or due dates for assessment.

Payment Information

Certificate Course



  • Professional development that is widely recognised and respected;
  • Improve your employment opportunities;
  • Study online, anywhere via our elearning system;
  • High-quality professional development programs written by industry experts;
  • No entry requirements;
  • All course materials provided online – no textbooks to buy;
  • Unlimited tutor support;
  • Easy to understand course content;
  • Unlimited enrolment with no expiry;
  • Certificate of Attainment/Completion issued for your CV (hard copy provided); and
  • Course may be tax deductible; see your tax advisor.
SKU: C00284 Category:
  • Includes unlimited access
  • Full up-front payment only