Microsoft Office Suite 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
• Database templates
• Customising the interface
• Customising the toolbar and ribbon

• Getting started
• Exploring and customising the interface
• Customising the quick access toolbar and ribbon
• Zoom modes and view modes
• Basic formulas
• Performing calculations
• 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
• Formatting data
• Setting, formatting and aligning your data
• Using colours and changing cell styles
• Document themes
• Creating and formatting a title
• Creating a table
• Resizing and inserting columns and rows
• Inserting borders
• Transferring format styles
• Illustrating documents
• Inserting and editing an image
• Inserting a screenshot
• Inserting shapes
• Inserting a hyperlink
• Using smart lookup
• Inserting and manipulating data
• Inputting data inserting special characters
• Creating automatic data series
• Editing multiple worksheets simultaneously
• Transferring data
• Transposing a data range
• Consolidating your data
• Referencing 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
• Formula errors
• Using conditional formulas
• Conditional sum formulas
• Conditional message formulas
• Creating multiple conditions
• Using conditional formulas
• Referencing positions
• 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

• Setting up
• Installing and configuring an account
• Using Outlook
• Keyboard shortcuts
• Calendar tools
• 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
• Contact tools
• Using your address book
• Adding contacts
• Importing and exporting contacts
• Creating and managing contact groups
• Printing and configuring your address book
• Formatting emails
• Formatting techniques
• Creating styles and style sets
• Email themes
• Creating and customising bullet lists
• Managing signatures
• Using email templates
• Illustrating emails
• 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
• Organising emails
• Marking and flagging emails
• Deleting and organising messages
• Using clutter
• Creating folders
• 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 attachments
• Using OneDrive and SharePoint
• Creating delivery recepts and an out-of-office reply
• Creating mail outs

• Getting started
• Opening and using the application
• Moving between slides
• View modes
• Zoom tools
• Moving between presentations
• Adding animations
• Creating and customising an animation
• Adding animations to slides
• Relaying slide animations
• Creating transitions between slides
• Applying morph transitions
• Configuring PowerPoint
• Installing add-ins
• 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
• Creating presentations
• 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
• Formatting presentations
• 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
• Illustrating presentations
• Inserting images and screenshots
• Editing images and a multimedia file
• Inserting an audio and video file
• Adding hyperlinks
• Creating bookmarks
• 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
• Slide content
• 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

• Illustrating documents
• Inserting images, icons, hyperlinks, videos and equations
• Taking a screenshot
• Text wrapping and inserting a watermark
• Editing documents
• 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.

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

The approximate study hours for this course is 80 hours. We offer twelve (12) months’ access, with extensions available upon application (fees apply).

While printed materials are not available for purchase, transcripts of video lectures and other learning resources are available for printing via our elearning system.

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.

Yes! You will receive a Certificate of Attainment upon successful completion of your assessment.

No. All courses are delivered online via our e-learning system and there are no work placement requirements in this course.

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.

Yes! We accept enrolments from individuals both within Australia and internationally; location is no barrier to entry into our programs.