Find your new direction

  • 1300 76 2221
  • Australian owned and operated since 2008

Microsoft Office Excel 2010


Course Outline and Topics

Course Overview

Microsoft Office Excel 2010 is an online professional development program that will provide you with the skills and knowledge required to develop spreadsheets using Microsoft Office Excel 2010. 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 2010. 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 - Create and use spreadsheets Using Excel 2010 and Windows 7

  • Select and prepare resources
  • Adjust workspace
  • Workplace 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

Unit 2 - Develop and use complex spreadsheets Using Excel 2010

  • Developing spreadsheets
  • Spreadsheet specifications
  • Designing workbooks
  • Functions
  • Linking spreadsheets
  • Formatting
  • Conditional formatting
  • Testing formulae
  • Automating spreadsheets
  • Visual Basic
  • Creating macros
  • Using templates
  • Forms and toolbars
  • Checking data
  • Accuracy of data
  • Data validation
  • Importing and exporting data
  • User documentation
  • Using context sensitive help
  • Storing spreadsheets
  • Style
  • Graphs and labels


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: c400130 Category:
  • Includes unlimited access
  • Full up-front payment only