Microsoft Courses

Short Courses

Microsoft Excel 2016 Intermediate Short Course

This is the second level of our Microsoft Excel 2016 short courses. This version of Excel incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible.

This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyse data, organise worksheet data with tables, visualise data with charts, insert graphics, and enhance workbooks.

By the end of this course users should be comfortable in creating advanced formulas, analysing data with functions, analysing data using functions and PivotTables, working with tables, visualising data with charts, inserting graphics, and enhancing workbooks.

What does the Microsoft Excel 2016 Intermediate 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.
 
At the completion of this course you should be able to:
  • Create advanced formulas
  • Analyse Data with Logical and Lookup Functions
  • Organise and Analysing Datasets and Tables
  • Visualise Data with Charts
  • Analyse Data with PivotTables, Slicers, and PivotCharts
  • Insert Graphics
  • Enhance Workbooks
This manual assumes the user has completed or has an understanding of the materials covered in the Microsoft Excel 2016 Foundation course or similar, including: Using absolute, relative, and mixed references,Using formulas and functions in a worksheet, Managing and organising worksheets,Editing and formatting Excel data, Printing and saving Excel files & Customising the Excel interface.

Course Information

  • Learning Outcomes

    This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyse data, organise worksheet data with tables, visualise data with charts, insert graphics, and enhance workbooks.

    Creating Advanced Formulas
    In this lesson, students will learn how to use range names in formulas and functions, as well as how to use specialised functions.

     
    Analysing Data with Logical and Lookup Functions
    Next, students will learn how to analyse data by using text, logical, lookup, date and financial functions.
     
    Organising and Analysing Datasets and Tables
    This lesson covers how to create and modify tables, sort and filter data, use subtotal features, and work with database functions.

     
    Visualising Data with Charts
    Students will learn how to create charts, as well as how to modify and format existing charts. They will also learn how to create a trend-line and advanced charts.

     
    Analysing Data with PivotTables, Slicers, and PivotCharts
    Creating a PivotTable, filtering data using slicers and, analysing data using PivotCharts will be covered in this lesson.

     
    Inserting Graphics
    Next, students will learn how to insert, modify, layer and group graphical objects. We will also take a look at how to incorporate SmartArt into workbooks.
     
    Enhancing Workbooks
    In this final lesson, students will learn how to customise workbooks, manage themes and, create and use templates. Protecting files and preparing a workbook for multiple audiences will also be covered.

     

  • Pricing

    Microsoft Online Short Courses 

    Course Price -  $195 Microsoft Excel 2016 Intermediate

    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
    • Quick reference guide
    • Assessments
    Students are able to work through the short course at their own pace.

     

  • Prerequisites
    This Course assumes the user has completed or has an understanding of the materials covered in Microsoft Excel 2016 Fundamentals Short Course or similar, including:
    • Using absolute, relative, and mixed references
    • Using formulas and functions in a worksheet
    • Managing and organising worksheets
    • Editing and formatting Excel data
    • Printing and saving Excel files
    • Customising the Excel interface
    • 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: Creating Advanced Formulas
    Topic A: Use Range Names in Formulas
    Topic B: Use Specialised Functions
     
    Lesson 2: Analysing Data with Logical and Lookup Functions
    Topic A: Use Text Functions
    Topic B: Use Logical Functions
    Topic C: Use Lookup Functions
    Topic D: Use Date Functions
    Topic E: Use Financial Functions
     
    Lesson 3: Organising Worksheet Data with Tables
    Topic A: Create and Modify Tables
    Topic B: Sort and Filter Data
    Topic C: Use Subtotal and Database Functions to Calculate Data
     
    Lesson 4: Visualising Data with Basic Charts
    Topic A: Create Charts
    Topic B: Modify and Format Charts
    Topic C: Create a Trendline
    Topic D: Create Advanced Charts
     
    Lesson 5: Analysing Data with PivotTables, Slicers, and PivotCharts
    Topic A: Create a PivotTable
    Topic B: Filter Data by Using Slicers
    Topic C: Analyse Data with PivotCharts
     
    Lesson 6: Inserting Graphics
    Topic A: Insert and Modify Graphic Objects
    Topic B: Layer and Group Graphic Objects
    Topic C: Incorporate SmartArt
     
    Lesson 7: Enhancing Workbooks
    Topic A: Customise Workbooks
    Topic B: Manage Themes
    Topic C: Create and Use Templates
    Topic D: Protect Files
    Topic E: Preparing a Workbook for Multiple Audiences

     


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