Microsoft Courses

Short Courses

Microsoft Excel 2013 Foundation Short Course

Microsoft Excel 2013 is a word-processing program designed to help you create professional-quality documents. Word helps you organise and write your documents more efficiently. This course is designed to develop a comprehensive knowledge of the fundamental functions, features & practical use of Microsoft Word 2013.

What does the Microsoft Word 2013 Fundamentals Course include?
  • A comprehensive training manual
  • Exercise files
  • Case studies
  • Skill sharpener exercises
  • Assessments
The course is delivered via self paced flexible distance learning which means we provide you with everything you need to study the course via our online training system and there is no classroom attendance required. Students are able to work through the short course at their own pace.

 

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2013. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.
 
At the completion of this course you should be able to:
  • Navigate your way around Microsoft Excel 2013
  • Create and work with a new workbook
  • Open and navigate within workbooks and worksheets
  • Understand and work with ranges in a worksheet
  • Understand, create and work with formulas and functions used to perform calculations
  • Use font formatting techniques to greatly enhance the look of a worksheet
  • Alter the layout of a worksheet  sort and filter data in a worksheet  print your workbook data
  • Create effective charts in Microsoft Excel
  • Obtain help for Excel whenever you need it
  • Understand points to consider to avoid problems in your worksheets
This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2013. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

Course Information

  • Learning Outcomes

    This course covers all the essentials of Microsoft Excel 2013. Topics covered include the new Flash Fill feature, using formulas and functions, inserting PivotTables and PivotCharts, and customising the interface. Material is also included on how to format text, data, and workbooks; insert art and objects; and chart data.

    The Basics - This module begins by covering how to sign into an account. Also covered are the parts of a workbook along with how to create, open, and save workbooks.
     
    Your First Workbook - Next up is how to enter, select, and delete data. How to undo and redo is also covered, along with using cut, copy, and paste functions.
     
    Working with Data - This module covers inserting rows and columns along with how to merge and split cells. Additional topics include using Paste Special, find and replace, and hiding and unhiding cells.
     
    Using Basic Excel Tools - Cell references and formulas are covered in this module. Also discussed is how to use basic formulas, how to learn basic and advanced functions, and how to run spell check. How to use the sort and filter tools to organise data is also covered.
     
    Using Timesaving Tools - Timesaving is the focus of this module. Students will learn how to use AutoFill, Flash Fill, AutoSum, AutoComplete, and AutoCalculate.
     
    Formatting Text - Various ways to format and work with text are the main points of this module. Ways to change font face, size, and colour, apply text effects, and add borders and fill to cells are all covered. Other topics include using the Font tab of the Format Cells dialog and how to clear formatting from text.
     
    Formatting Data - There are many ways to format data in Excel 2013. This module looks at how to adjust text wrapping, changing the size of rows and columns, adjusting cell alignment, changing text direction, and applying number formatting.
     
    Formatting the Workbook - This module will teach how to use cell styles, format data as a table, and change the theme of a workbook. Also covered is inserting page breaks and adding a background image.
     
    Inserting Art and Objects - Inserting SmartArt, text boxes, and equations into worksheets is covered in this module. Also touched upon is how to draw shapes on worksheets.
     
    Charting Data - Various methods to chart data in Excel 2013 are covered in this module. Topics include how to create Sparklines and timelines, plus how to insert PivotTables and PivotCharts, and use Slicers.
     
    Viewing, Printing, and Sharing Your Workbook - Ways to view and distribute a workbook are covered in this module. Topics include using views, saving a workbook as PDF or XPS, printing and e-mailing a workbook, and sharing a workbook on OneDrive.

    Customising the Interface - The final module of this course focuses on ways to customise the interface. Topics for discussion include how to change ribbon display options and how to customise the Quick Access toolbar. Also covered is how to hide and show ribbon tabs and create custom ribbon tabs. How to reset the interface is covered as well.

  • Pricing

    Microsoft Online Short Courses 

    Course Price -  $195 Microsoft Excel 2013 Foundation

    Payment Options - Invoice. Direct Deposit, Visa MasterCard and American Express.

    Please note that Visa & MasterCard attract a 1.5% surcharge & American Express attracts a 2.5% surcharge

    Multiple courses can be enrolled into.

  • Assessments

    You work through the Training Manual at your own pace and complete the quizzes when you are ready. This allows you to progress through the course at a pace that suits your needs. You have 12 months in which to submit your assessments for marking.


  • Requirements

    Students engage in and complete their short course training via our TBST Learning Management System - LMS 


    Our online Learning Management System - LMS - provides students with a more streamlined method of working through their courses by allowing students to login and access all current course files in the one universal location. The LMS has been designed so that students can work through course units in chronological order. Students will always have access to the most up-to-date course content and all updates to course content will be distributed to all students immediately via the LMS.

    The LMS includes:
    • TBST Administration Documents
    • A comprehensive training manual
    • Exercise files
    • Case studies
    • Skill sharpener exercises
    • Assessments
     
    Students are able to work through the short course at their own pace.
  • Prerequisites

    This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2013. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

    • Basic Microsoft Office skills
    • Access to the Microsoft Office 2013 suite of programs (either PC or Macintosh).
    • A basic calculator and stationery
    • PC or Mac – minimum system requirements & loaded with current versions of: Quicktime, Adobe Reader & access to the internet & email programs.
    • Please read and understand the TBST Student Handbook
    • Please read and understand the Policies and Procedures contained in the TBST Student Handbook

     

  • Recommended follow up / prior courses

    Microsoft Excel 2013 Short Courses
    Excel 2013 Foundation
    Excel 2013 Intermediate
     
    Microsoft Word 2013 Short Courses
    Word 2013 Foundation
    Word 2013 Intermediate
    Word 2013 Advanced
     
    Microsoft Excel 2016 Short Courses
    Excel 2016 Foundation
    Excel 2016 Intermediate
     
    Microsoft Word 2016 Short Courses
    Word 2016 Foundation
    Word 2016 Intermediate
    Word 2016 Advanced
     
    MYOB Training Courses
    MYOB Fundamentals
    MYOB Payroll
    MYOB Advanced

     


  • Units of Study

    Module 1: The Basics

    Getting Started
    Signing In
    Creating a New Workbook
    Parts of a Workbook
    Saving a Workbook
    Opening a Workbook
     
    Module 2: Your First Workbook
    Selecting Data
    Entering and Deleting Data
    Using Undo and Redo
    Using Cut, Copy, and Paste
     
    Module 3: Working with Data
    Inserting Rows and Columns
    Merging and Splitting Cells
    Moving Cells
    Using Paste Special
    Using Find and Replace
    Hiding and Unhiding Cells
     
    Module 4: Using Basic Excel Tools
    Understanding Cell References and Formulas
    Using Basic Formulas
    Using Basic Functions
    Using Advanced Functions
    Using Spell Check
    Using Sort and Filter
     
    Module 5: Using Timesaving Tools
    Using AutoFill
    Using Flash Fill
    Using AutoSum
    Using AutoComplete
    Using AutoCalculate
     
    Module 6: Formatting Text
    Changing the Font Face, Size, and Color
    Applying Text Effects
    Applying Borders and Fill
    Using the Font Tab of the Format Cells Dialog
    Clearing Formatting
     
    Module 7: Formatting Data
    Wrapping Text
    Changing the Size of Rows and Columns
    Adjusting Cell Alignment
    Changing Text Direction
    Changing Number Format
     
    Module 8: Formatting the Workbook
    Using Cell Styles
    Formatting Data as a Table
    Changing the Theme
    Inserting Page Breaks
    Adding a Background
     
    Module 9: Inserting Art and Objects
    Inserting SmartArt
    Inserting Text Boxes
    Inserting Pictures
    Inserting Equations
    Drawing Shapes
     
    Module 10: Charting Data
    Creating Sparklines
    Inserting Charts
    Inserting PivotTables
    Inserting PivotCharts
    Using Slicers
    Creating Timelines
     
    Module 11: Viewing, Printing, and Sharing Your Workbook
    Using Views
    Saving a Workbook as PDF or XPS
    Printing a Workbook
    E-Mailing a Workbook
    Sharing Your Workbook on OneDrive
     
    Module 12: Customising the Interface
    Changing Ribbon Display Options
    Customising the Quick Access Toolbar
    Hiding and Showing Ribbon Tabs
    Creating Custom Ribbon Tabs
    Resetting Interface Changes
  • Course Commencement

    Course enrolments can commence at any time after the enrolment process is completed.

    This course is a self paced distance learning training course. Students have 12 months to complete the training. Students work through the workbook, practice the material learnt and then complete the assessments.
     
    Due to the flexibility there is a lower drop out rate thus saving students time and money invested in their desired outcomes. In addition, flexible adult learning encourages students to continue the course at their own pace without restrictions as to when and how they complete the course. Therefore, students are able to continue their life roles and incorporate their study into time slots that suit their lifestyles. This also allows those that are working either as an employee, subcontractor or owner/operator to continue to earn money or charge for billable hours, which further serve to reduce the ʻrealʼ course costs. Students have 12 months in which to complete all of their assessments.

Microsoft Short Course Enrolment Form

TBST offers powerful short course training opportunities in both Microsoft Office 2013 & 2016.

Whether your creating professional-looking presentations, working on spreadsheets, or word processing, Microsoft Office allows you to open, save, modify, or collaborate on documents in the cloud, so you can maximise efficiencies & do great work anywhere, anytime.

Short course online training is a powerful way to learn.

TBST's Available Courses

Browse our range of government funded, fee paying and MYOB courses.