Attend courses from home - All courses REMOTE from April 1 - April 30

Office 365 Nexacu

Microsoft Office 365 Advanced 

Efficiency through automation with Office 365 training - join a class from home!

Sign up for any course and remote login details will be provided.
All classes from April 1 to April 30 will be delivered remotely.
Normal classes at oursite to resume thereafter, dates subject to review.


Microsoft
's Office 365 is an expansive eco-system of applications extending beyond the traditional word processor and accounting spread sheet.  These traditional (and critical) systems sit alongside a new wave of computing power within reach of end-users, in a way that has never been available before.   

Taking advantage of the tools at our disposal has never been so obvious of a competitive advantage as it is now.  This Office 365 course will enable advanced end-users, who have started their journey of increased integration between Office 365 products, to raise their skills and knowledge to the next level.  It is focused on automation and workflow for increased capabilities in using these tools.  You can view our detailed course outline below.

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Upcoming Courses:
Brisbane
Date
Course
City
Status
Thu 23-Apr-20
Office365 Advanced
Brisbane
Scheduled
Tue 12-May-20
Office365 Advanced
Brisbane
Scheduled
Fri 19-Jun-20
Office365 Advanced
Brisbane
Scheduled
Wed 8-Jul-20
Office365 Advanced
Brisbane
Scheduled
Fri 7-Aug-20
Office365 Advanced
Brisbane
Scheduled
Fri 9-Oct-20
Office365 Advanced
Brisbane
Scheduled
Wed 16-Dec-20
Office365 Advanced
Brisbane
Scheduled
Sydney
Date
Course
City
Status
Thu 23-Apr-20
Office365 Advanced
Sydney
Scheduled
Tue 12-May-20
Office365 Advanced
Sydney
Scheduled
Fri 19-Jun-20
Office365 Advanced
Sydney
Scheduled
Wed 8-Jul-20
Office365 Advanced
Sydney
Scheduled
Fri 7-Aug-20
Office365 Advanced
Sydney
Scheduled
Fri 9-Oct-20
Office365 Advanced
Sydney
Scheduled
Wed 16-Dec-20
Office365 Advanced
Sydney
Scheduled
Parramatta
Date
Course
City
Status
Thu 23-Apr-20
Office365 Advanced
Parramatta
Scheduled
Thu 21-May-20
Office365 Advanced
Parramatta
Scheduled
Mon 29-Jun-20
Office365 Advanced
Parramatta
Scheduled
Wed 5-Aug-20
Office365 Advanced
Parramatta
Scheduled
Fri 4-Sep-20
Office365 Advanced
Parramatta
Scheduled
Wed 18-Nov-20
Office365 Advanced
Parramatta
Scheduled
Melbourne
Date
Course
City
Status
Thu 23-Apr-20
Office365 Advanced
Melbourne
Scheduled
Tue 12-May-20
Office365 Advanced
Melbourne
Scheduled
Fri 19-Jun-20
Office365 Advanced
Melbourne
Scheduled
Wed 8-Jul-20
Office365 Advanced
Melbourne
Scheduled
Fri 7-Aug-20
Office365 Advanced
Melbourne
Scheduled
Fri 9-Oct-20
Office365 Advanced
Melbourne
Scheduled
Wed 16-Dec-20
Office365 Advanced
Melbourne
Scheduled
Canberra
Date
Course
City
Status
Thu 23-Apr-20
Office365 Advanced
Canberra
Scheduled
Thu 21-May-20
Office365 Advanced
Canberra
Scheduled
Mon 29-Jun-20
Office365 Advanced
Canberra
Scheduled
Wed 5-Aug-20
Office365 Advanced
Canberra
Scheduled
Fri 4-Sep-20
Office365 Advanced
Canberra
Scheduled
Wed 18-Nov-20
Office365 Advanced
Canberra
Scheduled
Adelaide
Date
Course
City
Status
Thu 23-Apr-20
Office365 Advanced
Adelaide
Scheduled
Thu 21-May-20
Office365 Advanced
Adelaide
Scheduled
Mon 29-Jun-20
Office365 Advanced
Adelaide
Scheduled
Wed 5-Aug-20
Office365 Advanced
Adelaide
Scheduled
Fri 4-Sep-20
Office365 Advanced
Adelaide
Scheduled
Wed 18-Nov-20
Office365 Advanced
Adelaide
Scheduled
Perth
Date
Course
City
Status
Thu 23-Apr-20
Office365 Advanced
Perth
Scheduled
Thu 21-May-20
Office365 Advanced
Perth
Scheduled
Mon 29-Jun-20
Office365 Advanced
Perth
Scheduled
Wed 8-Jul-20
Office365 Advanced
Perth
Scheduled
Fri 7-Aug-20
Office365 Advanced
Perth
Scheduled
Fri 9-Oct-20
Office365 Advanced
Perth
Scheduled
Wed 16-Dec-20
Office365 Advanced
Perth
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Office 365 Advanced  Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming L10, 333 Adelaide Street, Brisbane QLD 4000 thereafter
microsoft_gold

Office 365 Advanced  Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 3, 37 Pitt Street, Sydney NSW 2000 thereafter
microsoft_gold

Office 365 Advanced  Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 3, 90 Phillip Street, Parramatta NSW 2150 thereafter
microsoft_gold

Office 365 Advanced  Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 3, 466 Little Lonsdale St, Melbourne VIC 3000 thereafter
microsoft_gold

Office 365 Advanced  Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Ethos House, Level 1, 28 Ainslie Place, Canberra ACT 2601 thereafter
microsoft_gold

Office 365 Advanced  Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 3, 97 Pirie Street, Adelaide SA 5000 thereafter
microsoft_gold

Office 365 Advanced  Course Details

Price
$440
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 4, 220 St Georges Tce, Perth WA 6000 thereafter
microsoft_gold

Office 365 Course Outlines

Other Courses
  • Microsoft Power BI Training Courses
  • Microsoft Excel Training Courses
  • Microsoft Excel Specialist Training Courses
  • Microsoft SharePoint Training Courses
  • Microsoft PowerApps Training Courses
  • Microsoft Project Training Courses
  • Microsoft Visio Training Courses
  • Data Analytics Training Courses
  • Microsoft PowerPoint Training Courses
  • Microsoft Word Training Courses
  • Teach Remotely Training Courses
Course Rating
Microsoft Office 365 Training Courses

4.63 5 Microsoft Office 365 Training Courses
4.63 out of 5
415 Student Reviews

Contact Us

What do I need to know to attend?

The course will build on the knowledge learned in our Office 365 Beginner and Intermediate courses. You should have completed these courses or be very comfortable with the content covered. 

Office 365 Advanced  Learning Outcomes

On completion of this course you will know how to:

  • Handle errors and debug Power Automate flows
  • Create String expressions
  • Understand how to use JSON in a flow
  • Work with Arrays, Functions and Data and Time expressions

 

  • Configure SharePoint Approval Flows
  • Create and Use Adaptive Cards in Teams
  • Tap into the Power Platform 
  • Explore the basics of Cognitive Services and AI in Office 365

Office 365 Advanced  Course Content

  • Introduction
  • Course Objectives
  • How this manual is organised
  • What is Office 365?
  • Office 365 Subscriptions
  • Power Automate – Error Handling
  • Introduction to Error Handling
  • Error Handling in Power Automate
  • Error Types in Power Automate
  • Create an error free Flow in Power Automate
  • Cause the Flow to error
  • View successful actions & triggers
  • View failed actions & triggers
  • Power Automate – Error Handling cont'd
  • Error handling techniques
  • Configuring Run Conditions
  • Handle the error with a parallel branch
  • Add an action after the parallel branches
  • Handle the outcome of all branches
  • Use Terminate to successfully end a Flow
  • More complex but efficient alternative error handling
  • Power Automate – Debugging
  • Debugging in Power Automate
  • View the output of an action
  • Using Compose to see data
  • Variables for debugging
  • Using a variable to capture debug information
  • Variables versus Compose
  • View a complex output from an action
  • Debugging with Static Results
  • Causing an error with Static Results
  • Advice for Debugging and Error Handling
  • Power Automate – Data and JSON
  • Basic data Types in Power Automate
  • Object and Array data types
  • What is JSON
  • JSON examples
  • How to handle JSON
  • How a Flow is defined (JSON)
  • A string of JSON in a Flow
  • An Object of JSON in a Flow
  • Handling data in JSON format
  • Parse JSON data
  • Extended Topic – JSON Schemas
  • More complex JSON data
  • Accessing an array of JSON data
  • Power Automate – Expressions
  • What is the Workflow Definition Language
  • The Workflow Definition Language Schema
  • The functions reference for Workflow Definition Language
  • Writing Expressions in Power Automate
  • The expression pane
  • Power Automate – String Expressions
  • A Basic String function
  • Combining String functions together
  • Power Automate – Variables in expressions
  • Variable naming conventions
  • The variables() function
  • Referencing a variable in another function
  • Power Automate – Arrays & Collections
  • What is an array
  • What is a collection
  • Defining an array
  • Looping through an array
  • Filtering an array
  • The length of an array
  • Find if an element exists in an array
  • Accessing an array element by index
  • Power Automate – Data & Math Expressions
  • Arithmetic Functions
  • Conversion functions
  • Power Automate – Date/Time types and expressions
  • The Date and Time data type
  • Date and Time functions
  • Time Zone functions
  • Formatting Dates and Times
  • Power Automate – Advanced Functions
  • The workflow() function
  • Data from the trigger
  • The dot (.) operator
  • Data from an action
  • Operators to access data fields
  • Avoiding errors with NULL or missing fields
  • The ? operator
  • Have a default if value is null
  • Other function groups
  • Power Automate – Configuration
  • Introduction to limits
  • Trigger Conditions
  • Tracked Properties
  • Create a Tracked Property
  • Accessing Tracked Properties
  • A calculation from a Tracked Property
  • Extended Exercise – Using a calculated output for Tracked Property
  • Other Power Automate settings
  • Secure Inputs and Outputs
  • Concurrency Control
  • Timeouts and Retries
  • Other settings
  • SharePoint Automation
  • Power Automate and SharePoint
  • SharePoint Triggers
  • SharePoint Actions
  • SharePoint caution with actions and triggers
  • Perform an action on an item using Power Automate
  • Share a SharePoint Flow
  • Select file and initiate the Flow
  • Use SharePoint metadata to advise user
  • Expand the SharePoint Flow functionality
  • SharePoint Automation cont'd
  • Content Approval in SharePoint
  • SharePoint Approval Process
  • SharePoint Workflows
  • Using Power Automate to manage SharePoint Approvals
  • Create a Flow to Approve SharePoint files
  • Add an approval action to the SharePoint Flow
  • The approval response handling
  • Testing the approval Flow
  • Advanced SharePoint Actions via API
  • The magic behind Power Automate
  • About Application Programming Interfaces
  • API Methods
  • Other API considerations
  • The SharePoint API action
  • The SharePoint API via a web browser
  • Finding the site Title from the API
  • Advanced SharePoint Actions via API cont'd
  • Filter only needed data using ODATA format
  • Accessing the property only
  • Use the Title in our approval Flow
  • More ODATA query examples
  • ODATA filters
  • Format of a response
  • References for the SharePoint API
  • Teams – Adaptive Cards
  • Types of Teams Apps
  • What are Adaptive Cards
  • Uses for Adaptive Cards in Teams
  • Structure of an Adaptive Card
  • Templates in Adaptive Cards
  • A basic Adaptive Card sample
  • Modify the sample Adaptive Card JSON
  • Populate an Adaptive Card with data from the Flow
  • Adaptive Card Schema
  • Text Formatting a Card
  • Adaptive Card Designer
  • Create an Adaptive Card in designer
  • Teams – Adaptive Cards cont'd
  • Test run the new card with Power Automate
  • Add dynamic fields to the custom card
  • Modify the card in designer with fields intact
  • Adding inputs to the trigger
  • Extended Topic – Actions on an Adaptive card
  • Action buttons on cards
  • Action on elements
  • Adding actions to a card
  • Other types of card elements
  • At mentions in cards (alternative)
  • Power Platform in SharePoint
  • Why is the Power Platform so useful
  • What are Power Apps
  • Power Apps and Data (SharePoint)
  • Create a SharePoint list
  • Manage the list with a 3-screen Power App
  • Trying to break the Power App
  • Modify the SharePoint column
  • Add an option to the column
  • Modifying the Power App
  • Saving, Sharing and Publishing the Power App
  • Housekeeping to clean-up our environment
  • Cognitive Services
  • Traditional Computing
  • What is Artificial Intelligence
  • What is Machine Learning
  • Uses for Artificial Intelligence
  • Microsoft Cognitive Services
  • What is Azure
  • Text Analysis
  • Image Analysis
  • Cognitive Services cont'd
  • Computer Vision
  • Facial Recognition
  • Face Verification
  • Face Detection
  • Emotion Recognition
  • Artificial Intelligence in Office 365
  • Artificial Intelligence in the Power Platform
  • AI Builder in Power Platform
  • Where to from here

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 20017 Reviews
Ken, is a very qualified professional. I am very keen to start doing my own developments and get ready for the next level. Thanks to Nexacu for organizing the course online in this hard times. -Power BI Beginner Melbourne
Vanessa - Power BI Beginner, .
I found this course highly valuable, with excellent coverage across a range of PowerBI functions I can see myself using in my day-to-day work. Ken was a fantastic facilitator, and the change to online delivery (due to COVID-19) didn't prove to be an impediment at all. -Power BI Beginner Melbourne
Dean - Power BI Beginner, .
Ken was great! Would love to see him in future courses that I complete. -Power BI Beginner Melbourne
Tracey - Power BI Beginner, .
Ken is good - would like to have have him as trainer in the future -Power BI Beginner Melbourne
Luis - Power BI Beginner, .
Great -Excel Intermediate Sydney
Liz - Excel Intermediate, .
Instructor was very knowledgeable, course content was excellent. -Excel Intermediate Sydney
Louise - Excel Intermediate, .
very engaging for long online session -Excel Intermediate Sydney
cecelia - Excel Intermediate, .
Great instruction from David! The content was easy to follow, went at a manageable pace and he was accommodating to questions that were not in the course content. I have learnt some very valuable new skills, thank you David! -Excel Advanced Perth
Holly - Excel Advanced, .
Excellent course, very well explained and learned a the CORRECT way to operate in excel. Thanks for your patience Dave -Excel Advanced Perth
Russell - Excel Advanced, .
Excellent session. Very informative and enjoyable. Learnt heaps in a friendly environment. Thank you Dave -Excel Advanced Perth
Hans - Excel Advanced, .
good presentation skills kept it entertaining despite the remoteness -Power BI Intermediate Perth
oliver - Power BI Intermediate, .
Excellent course and Dom is superb as usual. -Power BI Intermediate Perth
Chandra - Power BI Intermediate, .
Domenic has been a good solid instructor with excellent knowledge of the product and great at problem-solving. Thanks Dom! -Power BI Intermediate Perth
Louie - Power BI Intermediate, .
Once again fantastic course, very helpful and easy to learn. No issues using remote learning for the first time. -Power BI Intermediate Perth
Alissa - Power BI Intermediate, .
N/A -Power BI Intermediate Perth
Ehsan - Power BI Intermediate, .
Great course, very interesting and informative! -Power BI Desktop Beginner Canberra
Mel - Power BI Desktop Beginner, .
The beginner Power BI course was very informative and well run. -Power BI Desktop Beginner Canberra
L - Power BI Desktop Beginner, .
Content was explained thoroughly and in an entertaining way. Very knowledgeable trainer and was able to and demonstrate all answers to questions. -Power BI Desktop Beginner Canberra
Tess - Power BI Desktop Beginner, .
Thank you, for the fantastic course. Learnt a lot that I can use for work. -Power BI Desktop Beginner Canberra
MH - Power BI Desktop Beginner, .
Great course, very interactive. Well laid out and presented. -Power BI Desktop Beginner Canberra
Sarah - Power BI Desktop Beginner, .

Trusted by Business

Procured by Government

Map of Australia