With over one billion people using Microsoft Office globally, it’s not surprising that it is the go-to word processing software for most employers. As such, being able to use it proficiently will prepare you for an entry-level job or enhance your skills as an experienced professional.
The Microsoft Office Suite 2016 is an online professional development program that will introduce you to or update you on Microsoft Office’s five main programs.
In this Microsoft Office course, you will learn the essential introductory and advanced skills across the Microsoft Office Word, Excel, PowerPoint, Outlook and Access programs.
You will learn how to create, format and edit documents in Word, work with formulas and data in Excel, create slideshows and presentations in PowerPoint, format emails and work with calendar tools in Outlook, and discover the Access databases and reporting tools.
On completion of this course, you will be able to use the essential Microsoft Office suite of products in a confident, effective and efficient manner in a vast array of employment sectors.
Unit 1 - Access 2016
Creating and customising forms
Form types and reorganising a form
Inserting buttons in a form
Creating a simple query
Creating a cross tab query
Finding and organisation data
Sorting and filtering data
Replacing data values
Editing database indexes
Inserting, importing and formatting data
Modifying default editing settings
Creating drop down menus
Creating data validation rule
Saving printing and exporting databases
Protecting your database
Tables, fields and entries
Formatting database fields and properties
Linking data in different tables
Visualising object dependencies
Using report analysis tools
Creating and customising a database
Working with databases
Customising the interface
Customising the toolbar and ribbon
Unit 2 - Excel 2016
Exploring and customising the interface
Customising the quick access toolbar and ribbon
Zoom modes and view modes
Using automated formulas, cumulative totals and subtotals
Ranking a value and rounding a number
Replacement formulas and creating random values
Configuring options and settings
Managing your account and add-ins
Configuring input options and default formula options
Document default settings
Creating charts and graphics
Inserting, labelling and formatting a chart
Customising charts and chart axes
Creating a chart template
Creating a pie chart and scatter chart
Bubble chart and radar chart
Inserting and customising trendlines
Creating, saving and sharing workbooks
Creating and using templates
Saving as a PDF
Inserting headers and footers
Setting and adjusting print layout
Custom and conditional formatting
Customising number and text formats
Date and time formats
Conditional formatting tools
Extracting information with formulas
Finding and retrieving information
Largest and smallest values
Separating and combining data into multiple cells
Cross referencing data lists
Finding a value in a double entry table
Finding sorting and filtering data
Using the finding and replacing tools
Sorting and filtering your data
Using slicers in tables
Advanced filter options
Hiding duplicate values
Freezing and unfreezing panes
Setting, formatting and aligning your data
Using colours and changing cell styles
Creating and formatting a title
Creating a table
Resizing and inserting columns and rows
Transferring format styles
Inserting and editing an image
Inserting a screenshot
Inserting a hyperlink
Using smart lookup
Inserting and manipulating data
Inputting data inserting special characters
Creating automatic data series
Editing multiple worksheets simultaneously
Transposing a data range
Consolidating your data
Referencing cells and using cell references
Using data across multiple worksheets
Absolute and relative cell references
Naming data ranges
Calculations using constant values
Using formula auditing
Using conditional formulas
Conditional sum formulas
Conditional message formulas
Creating multiple conditions
Using conditional formulas
Working with formulas
Calculating interest on a loan
Simulating a loan
Reaching a target value
Using the forecast tool
Creating automatic reports
Finding identical values in a spreadsheet
Finding and preventing duplicate values
Unit 3 - Outlook 2016
Installing and configuring an account
Using and creating an event
Adding a calendar
Importing and exporting a calendar
Managing multiple calendars
Creating, customising and assigning a task
Configuring the client
Adding a second user account
Adding an RSS feed
Using the customer interface
Modifying and customising the toolbar
Adding shortcuts to the ribbon
Using your address book
Importing and exporting contacts
Creating and managing contact groups
Printing and configuring your address book
Creating styles and style sets
Creating and customising bullet lists
Using email templates
Inserting links, images and objects
Inserting WordArt graphics and shapes
Inserting and modifying a table
Inserting a SmartArt graphics
Inserting and modifying a chart
Creating a survey
Marking and flagging emails
Deleting and organising messages
Managing IMAP folders
Filtering and sorting emails
Combatting junk mail
Sending and receiving emails
Using the read aloud tool
Sending and drafting an email
Replying and forwarding an email
Using OneDrive and SharePoint
Creating delivery recepts and an out-of-office reply
Creating mail outs
Unit 4 - PowerPoint 2016
Opening and using the application
Moving between slides
Moving between presentations
Creating and customising an animation
Adding animations to slides
Relaying slide animations
Creating transitions between slides
Applying morph transitions
Customising your interface
Customising the Quick access tool
Customising the ribbon
Creating graphics and diagrams
Creating a custom shape
Adding fill effect to shapes
Inserting a diagram or chart
Formatting borders and outlines
Inserting SmartArt graphics
Using themes and templates
Inserting and moving slides
Creating a template
Creating sections in a presentation
Creating an outline
Headers and footers
Using the master mode
Creating a master slide template
Changing fonts and text size
Adding colour to a presentation
Creating a colour palette
Creating a Word Art title
Aligning and rotating your text
Using presentation themes
Creating slide backgrounds
Inserting images and screenshots
Editing images and a multimedia file
Inserting an audio and video file
Using tables in a presentation
Creating a photo album
Importing items from excel
Inserting a preset equation
Inserting and manipulating text
Inserting text and special characters
Undoing and redoing
Using the spell check function
Using the find an replace tool
Using smart look-up
Organising presentation assets
Copying and pasting
Using the clipboard
Manipulating items in a presentation
Preparing and delivering slide shows
Using the slide show mode
Using the notes section
Inserting action buttons
Annotating a presentation
Creating an automatic slide show
Saving and sharing presentations
Backup and recovering a presentation
Creating a video presentation
Creating a presentation package
Creating an accessible presentation
Unit 5 - Word 2016
Inserting images, icons, hyperlinks, videos and equations
Taking a screenshot
Text wrapping and inserting a watermark
Inserting text, text boxes and special characters
Cutting copying and pasting
Using autocorrect and spell check
Shaping and structuring documents
Creating and formatting
Page numbers, headers and footers
Creating a table of contents
Creating an index
Inserting a captions and bookmarks
Find and replace tools
Advanced search tools
Using find and replace tool
Performing wildcard searches
Configuring the application
Installing and managing add-ins
Customising view settings, tool bar and ribbon
Adjusting the language options, save options and input options
Creating forms and bulk mailings
Creating envelopes and labels
Creating and importing a mailing list
Creating a mail merge
Creating graphics and diagrams
Creating a diagram with shapes
Crating a drawing canvas
Using SmartArt graphics
Inserting, formatting and labelling a chart
Creating opening and saving documents
Using document templates
Saving documents as a PDF
Modifying document properties
Using the read aloud tool
Document protection options
When you study with Australian Online Courses, you will be assessed using a competency-based training method.
Competency-based training focuses on the achievement of skills and knowledge against set criteria to ensure your competency is industry relevant. You will not be benchmarked against other students.
If you do not achieve a competency result on your first attempt, you have two more attempts to pass your assessment. So, you have three attempts in total to obtain a competency result.
In this way, you can complete your course in your own time and at your own pace with the assistance of unlimited tutor support.
In this course, you will be assessed via multiple-choice questions to determine your mastery of details and specific knowledge gained during your studies to achieve a ‘competent’ or ‘not yet competent’ result.
Benefits of Multiple-Choice Assessments
Appropriate for assessing students’ mastery of details and specific knowledge.
Can be used to assess both simple knowledge and complex concepts.
Questions can be answered quickly to accurately assess a students’ mastery of many topics relatively quickly.
Assessment can be quickly and reliably scored to achieve a ‘competent’ or ‘not yet competent’ result.
As the answers are visible, multiple-choice questions offer the opportunity for the continuation of the learning process, offering educational value.
Why Choose Australian Online Courses?
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;
We offer twelve (12) months’ access, with extensions available upon application (fees apply);
Certificate of Attainment/Completion issued for your CV (hard copy provided); and
Course may be tax deductible; see your tax advisor.
How long will it take to complete this course?
The approximate study hours for this course is 40 hours. We offer twelve (12) months’ access, with extensions available upon application (fees apply).
Can I purchase optional printed materials?
While printed materials are not available for purchase, transcripts of video lectures and other learning resources are available for printing via our elearning system.
When can I start this course?
You can start within 60 minutes during business hours when you enrol and pay in full with a credit card!
Credit card: Within 60 mins during business hours.
BPAY: Within 1-2 working days.
Internet Banking: Within 1-2 working days.
Cheque/Money Order: Upon receipt of mailed cheque.
Will I receive a certificate upon completion of this course?
Yes! You will receive a Certificate of Attainment upon successful completion of your assessment.
Do I need to attend classes or undertake any work placements?
No. All courses are delivered online via our e-learning system and there are no work placement requirements in this course.
What support can I expect from Australian Online Courses?
Unlimited tutor support is available throughout your studies via email during business hours Monday to Friday. Our Administrative team are available Monday to Friday via email, live chat and telephone.
I am an international student. Can I enrol into this course?
Yes! We accept enrolments from individuals both within Australia and internationally; location is no barrier to entry into our programs.
Professional development for:-
Individuals working in small, medium and large organisations who need to produce professional documents and communications.