Don’t lose track.
Sign up to save your shortlist.
Microsoft Office training courses
38 training courses
See all
Office 365: Planner
Learn how to use Planner with Office 365 to establish and manage small projects, share files and assign and track group tasks. Learning outcomes: Create a plan Add tasks Add team members Edit a plan
Duration:
1.5 hour
Office 365: OneNote
Learn how to use OneNote with Office 365 to create digital notebooks for capturing, organising and sharing information including meeting minutes, workshop notes and other important reminders. Learning outcomes: Understand OneNote Create notes Using Pages and Sections
Duration:
1.5 hour
Office 365: Getting Started
Get started with the core Office 365 applications and services. The session will focus on using Office 365 in the cloud, on the desktop and on mobile devices with an emphasis on how to get up and running with the core office applications. Learning outcomes: Understand cloud computing Use Office 365 online applications Use Email, Calendar and People Use OneDrive for Business
Duration:
1.5 hour
Excel: Top ten tips
Learn ten essential tips and shortcuts that will dramatically improve the way you use Excel. Learning outcomes: AutoCalculate AutoFit AutoFill & FlashFill Custom Fill lists Ctrl * to select regions Freeze windows Drag & drop to copy cells & sheets Group sheets Format Painter Conditional formatting
Duration:
1.5 hour
Excel: Sorting and Filtering Lists and Database
Learn how to turn raw data into useful business information to help you make more informed decisions. Work with built-in, easy to use database and list management tools in Excel to analyse large sets of business data quickly and efficiently. Learning outcomes: Use Sort and Filter tools Use Subtotals Remove duplicates Clean up imported data
Duration:
1.5 hour
Excel: Pivot Tables and Pivot Charts
Learn how to create and edit Pivot Tables and Pivot Charts to quickly visualise and analyse large Excel data sets and make better business decisions. Learning outcomes Introduction to Pivot Tables Creating a Pivot Table Rearranging Fields and Items in a Pivot Table Creating Pivot Charts Creating a Pivot Chart
Duration:
1.5 hour
Excel: Math Functions
Learn to use Excel Functions for complex mathematical operations. Math functions are used for many mathematical operations including adding up totals, multiplying values and rounding numbers. Learning outcomes: Understand Math Functions Use Functions to round numbers Use Functions to perform conditional sums Use Functions for complex adding and multiplying
Duration:
1.5 hour
Excel: Mastering VLOOKUP formulas
Learn how to create and edit VLOOKUP and other Lookup formulas to extract data from Excel lists and tables based on variable conditions and criteria. Learning outcomes: Understand when to use lookup formulas Understand cell references with Excel formulas Create named ranges Use LOOKUP and VLOOKUP
Duration:
1.5 hour
Excel: Formulas for working with text
Learn to use Excel Text Functions to clean up imported text and manipulate how textual data is stored and displayed. Learning outcomes: Understanding when to use Text Functions Use Text Functions to manipulate text based Excel data Use Text Functions to ‘clean up’ imported text
Duration:
1.5 hour
Excel: Formulas for What-if analysis
Learn how to write and edit IF formulas to return results based on variable conditions in your spreadsheet data. Learning outcomes: Understand how dynamic formulas work in Excel Use simple Functions – Excel’s built-in formulas Use IF Functions to calculate and return results based on conditional tests Use nested IF Functions for complex conditional tests
Duration:
1.5 hour
Excel: Formulas for statistical analysis
Learn how to use Excel Statistical Functions to calculate averages, standard deviations and other useful statistical information for analytical and reporting purposes. Learning outcomes: Understand statistical Functions Use Functions for statistical analysis
Duration:
1.5 hour
Excel: Formulas for finance analysis
Learn to use Excel formulas that work on financial data. Financial functions are used to calculate many finance related operations including loan repayments, depreciation of assets and rates of return on investments. Learning outcomes: Understand when to use financial functions Use Functions to calculate loan repayments Use Functions to calculate rates of return
Duration:
1.5 hour
Excel: Formulas for everyday
Learn how to write and edit simple formulas in Excel to calculate results. You will learn how to write formulas that add totals and calculate averages and how to use built-in formulas called Functions. Learning outcomes: Understand formulas Create a simple formula to add numbers Use formulas to perform common calculated results Understand cell referencing in formulas Use simple Functions – Excel’s built-in for...
Duration:
1.5 hour
Excel: Error-proofing your spreadsheet
Learn how to find and fix common errors in spreadsheets and how to create models that have built-in error prevention mechanisms to help maintain data integrity. Learning outcomes: Understand error types Use Auditing tools to trace errors in spreadsheets Use Data Validation to prevent data input errors Protect workbook data to prevent data input errors
Duration:
1.5 hour
Excel: Data modelling with scenarios, goal seek & solver.
Learn how to use Scenario Manager, Goal Seek and Solver to perform complex spreadsheet modelling and how to quickly analyse options and make better decisions. Learning outcomes: Understand spreadsheet modelling Create a simple what-if model Create models with captured scenarios Use Goal Seek to model simple scenarios Use Solver to model complex scenarios
Duration:
1.5 hour
Excel: Dashboards
Learn how to create a dashboard in Excel to help you keep a visual track of important performance measures and targets in your spreadsheet models. Learning outcomes: Understand when to use a dashboard Create a simple KPI dashboard Edit and update the dashboard
Duration:
1.5 hour
Excel: Collaboration and shared workbooks
Learn to share and co-author Excel workbooks and collaborate with team members online. Learning outcomes: Protecting data Sharing a workbook via a network Sharing a workbook on OneDrive Using Track Changes to review shared edits
Duration:
1.5 hour
Excel: Charts and Graphs
Learn how to display Excel data graphically using a variety of compelling charts. Learning outcomes: Understand chart types and uses Create a chart Format chart elements Change chart types
Duration:
1 week
Most important skills for Microsoft Office
Not knowing Microsoft Office is kind of like not knowing how to drive. With most businesses around the world using Microsoft Office as their software, it’s important you understand how to navigate the basic’s to get your job done properly. Microsoft Office suite has heaps of different skills and expertise, but the good news is that there is a huge range of Microsoft Office Training Courses in Australia.
Your role requirements will dictate the type of Microsoft Office skills Training needed. Generally speaking, most positions require employees to be able to create and edit formulas, using pivot tables, formatting graphs and charts, sorting data, formatting, proofreading and editing, using templates and incorporating texts and images.
How Microsoft Office training courses work
You’ll need to power up because all Microsoft Office skills Training require you to have a laptop and be online. Courses are generally delivered externally, by expert microsoft office training providers and you can either engage in a full certification, or become skilled in certain applications such as microsoft word, outlook, access, publisher, onenote, powerpoint or excel.
Benefits of Microsoft Office training
Whether you’re a student, employee or home-keeper, being able to competently use microsoft applications will benefit you. As mentioned earlier, MicroSoft is used by most businesses, in fact, 90% worldwide. Your employability chances will increase, you can work flexibly, you’ll be seen as an expert in the workplace, and not to mention at home budgeting and financial tracking will become a breeze.
Results you might see
Microsoft Office Training in Australia has a vast range of course options for both professional and person skills training. At the end of any course undertaken, you will walk away more competent and confident in your chosen application.