Microsoft Courses

Short Courses

Microsoft Excel 2016 Foundation Short Course

This hands-on beginner’s course aims to give the learner a sound grounding in the use of Microsoft Excel 2016 to create everyday workbooks required either at work or at home. Particular emphasis is placed on developing accurate and well-designed workbooks. The course begins by showing the learner how to navigate around Microsoft Excel 2016. Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This new version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins. This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features of the interface, show users how to print, cover some simple scenarios, and cover the basics of formatting.

What does the Microsoft Excel 2016 Foundation 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 2016. 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 2016
  • Create and work with a new workbook
  • Open and navigate within workbooks and worksheets
  • Make changes to data in a workbook
  • Performing Calculations
  • Copy and paste data in Excel
  • Modifying a Worksheet
  • Move the contents of cells and ranges within and between workbooks
  • Understand, create and work with formulas and functions
  • Understand and use formula cell referencing
  • Use font formatting techniques
  • Align the contents of cells in a number of ways
  • Printing Workbook Contents
  • Format rows and columns in a worksheet
  • Work with elements that make up the structure of a worksheet
  • Managing Large Workbooks
  • Print your workbook data
  • Customising the Excel Environment
This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2016. 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

    Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This new version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins.

    This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features of the interface, show users how to print, cover some simple scenarios, and cover the basics of formatting.
     
    Getting Started with Microsoft Excel 2016 - In this lesson, students will learn how to identify the elements of the Excel interface, create a basic worksheet, and use the help system.
     
    Performing Calculations - This lesson covers how to create formulas in a worksheet, insert functions in a worksheet, and reuse formulas.
     
    Modifying a Worksheet - Next, students will learn how to manipulate data, as well as how to insert, manipulate, and delete cells, columns, and rows. Searching for and replacing data and how to spell check a worksheet are also discussed.
     
    Formatting a Worksheet - This lesson covers how to modify fonts, add borders and colours to cells, apply number formats, align cell contents, and apply cell styles.
     
    Printing Workbook Contents - In this lesson, students will learn how to define the basic page layout for a workbook, refine the page layout, and apply print options.
     
    Managing Large Workbooks - This lesson will teach students how to format worksheet tabs, manage worksheets, and manage the view of worksheets and workbooks.
     
    Customising the Excel Environment - In this final lesson, students will learn how to customise general, language, formula, proofing, and saving options. It also covers how to use Excel’s version control features, customise the ribbon and the Quick Access toolbar, enable add-ins, and customise advanced and Trust Centre options.

     

  • Pricing

    Microsoft Online Short Courses 

    Course Price -  $195 Microsoft Excel 2016 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 that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Excel is necessary.

    • Basic Microsoft Office skills
    • Access to the Microsoft Office 2016 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

    See the Unit Description Page for a full course overview.

    Lesson 1: Getting Started with Microsoft Excel 2010
    Topic A: Identify the Elements of the Excel Interface
    Topic B: Create a Basic Worksheet
    Topic C: Use the Help System
     
    Lesson 2: Performing Calculations
    Topic A: Create Formulas in a Worksheet
    Topic B: Insert Functions in a Worksheet
    Topic C: Reuse Formulas
     
    Lesson 3: Modifying a Worksheet
    Topic A: Manipulate Data
    Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
    Topic C: Search for and Replace Data
    Topic D: Spell Check a Worksheet
     
    Lesson 4: Formatting a Worksheet
    Topic A:Modify Fonts
    Topic B: Add Borders and Color to Cells
    Topic C: Apply Number Formats
    Topic D: Align Cell Contents
    Topic E: Apply Cell Styles
     
    Lesson 5: Printing Workbook Contents
    Topic A: Define the Basic Page Layout for a Workbook
    Topic B: Refine the Page Layout and Apply Print Options
     
    Lesson 6: Managing Large Workbooks
    Topic A: Format Worksheet Tabs
    Topic B: Manage Worksheets
    Topic C: Manage the View of Worksheets and Workbooks
     
    Lesson 7: Customising the Excel Environment
    Topic A: Customise General and Language Options
    Topic B: Customise Formula Options
    Topic C: Customise Proofing and Save Options
    Topic D: Customise the Ribbon and Quick Access Toolbar
    Topic E: Customise the Functionality of Excel by Enabling Add-Ins
    Topic F: Customise Advanced and Trust Centre Options

     

     

  • 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.