Previously Excel Consulting

Office 365 Nexacu

Microsoft Office 365 Advanced Courses

Efficiency through automation with Office 365 training

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
Tue 25-Feb-20
Office365 Advanced
Brisbane
Scheduled
Thu 23-Apr-20
Office365 Advanced
Brisbane
Scheduled
Tue 12-May-20
Office365 Advanced
Brisbane
Scheduled
Fri 19-Jun-20
Office365 Advanced
Brisbane
Scheduled
Sydney
Date
Course
City
Status
Tue 25-Feb-20
Office365 Advanced
Sydney
Scheduled
Thu 23-Apr-20
Office365 Advanced
Sydney
Scheduled
Tue 12-May-20
Office365 Advanced
Sydney
Scheduled
Fri 19-Jun-20
Office365 Advanced
Sydney
Scheduled
Parramatta
Date
Course
City
Status
Fri 7-Feb-20
Office365 Advanced
Parramatta
Scheduled
Wed 11-Mar-20
Office365 Advanced
Parramatta
Scheduled
Thu 21-May-20
Office365 Advanced
Parramatta
Scheduled
Mon 29-Jun-20
Office365 Advanced
Parramatta
Scheduled
Melbourne
Date
Course
City
Status
Tue 25-Feb-20
Office365 Advanced
Melbourne
Scheduled
Thu 23-Apr-20
Office365 Advanced
Melbourne
Scheduled
Tue 12-May-20
Office365 Advanced
Melbourne
Scheduled
Fri 19-Jun-20
Office365 Advanced
Melbourne
Scheduled
Canberra
Date
Course
City
Status
Wed 11-Mar-20
Office365 Advanced
Canberra
Scheduled
Thu 21-May-20
Office365 Advanced
Canberra
Scheduled
Mon 29-Jun-20
Office365 Advanced
Canberra
Scheduled
Adelaide
Date
Course
City
Status
Fri 7-Feb-20
Office365 Advanced
Adelaide
Confirmed
Wed 11-Mar-20
Office365 Advanced
Adelaide
Scheduled
Thu 21-May-20
Office365 Advanced
Adelaide
Scheduled
Mon 29-Jun-20
Office365 Advanced
Adelaide
Scheduled
Perth
Date
Course
City
Status
Fri 7-Feb-20
Office365 Advanced
Perth
Confirmed
Wed 11-Mar-20
Office365 Advanced
Perth
Scheduled
Thu 21-May-20
Office365 Advanced
Perth
Scheduled
Mon 29-Jun-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
Level 10, 333 Adelaide St, Brisbane QLD 4000
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
Level 3, 37 Pitt Street, Sydney NSW 2000
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
Level 3, 90 Phillip Street, Parramatta NSW 2150
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
Level 3, 466 Little Lonsdale St, Melbourne VIC 3000
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
Ethos House, Level 1, 28 Ainslie Place, Canberra ACT 2601
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
Level 3, 97 Pirie Street, Adelaide SA 5000
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
Level 1, 140 St Georges Tce, Perth WA 6000
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 Visio Training Courses
  • Microsoft PowerPoint Training Courses
  • Microsoft Word Training Courses
  • Microsoft Project Training Courses
Course Rating
Microsoft Office 365 Training Courses

4.62 5 Microsoft Office 365 Training Courses
4.62 out of 5
354 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

  • Power Automate – Error Handling 
  • Introduction to Debugging Error types 
  • Create a Flow from Templates  
  • Modify the Flow to cause errors 
  • View the Run History 
  • View successful actions and triggers 
  • Identify failures in actions and triggers 
  • Handle the error 
  • Configuring run conditions 
  • Override the failed status of the flow 

 

  • Power Automate – Debugging methods 
  • Add an action with output 
  • View output data from the action 
  • Use compose to view data within a Flow 
  • Use variables to store custom output 
  • View value of variable  
  • Variables versus Compose  
  • View a complex output from an action 

 

  • Power Automate – Data and JSON 
  • Data types 
  • Variables 
  • What is JSON 
  • How a Flow is defined by JSON  
  • Handling JSON in a Flow 
  • A string of JSON 
  • An object of JSON 
  • Handling data in JSON format 
  • Parse JSON 
  • JSON Schemas 
  • Creating a schema 
  • Using Parsed JSON data 
  • Alternative to access parsed JSON data 
  • Modify the data or use expressions 
  • A JSON of multiple items 
  • Accessing an item in the array of JSON items 
  • Parsing a more complex JSON 

 

  • Power Automate – String Expressions 
  • What is the Workflow Definition Language 
  • Creating expressions 
  • The expression pane 
  • String functions 
  • Combining String functions 
  • Variable functions 

 

  • Power Automate – Arrays and Collections 
  • What is an Array 
  • What is a Collection 
  • Defining an Array 
  • Array lengths 
  • Array conditions 
  • Arrays withing another object 
  • Accessing elements of an Array 

 

  • Power Automate – Data and Math Expressions 
  • Arithmetic functions 
  • Conversion functions 

 

  • Power Automate - Date and Time types and Expressions 
  • Date Time data types 
  • Date Time functions 
  • Time Zone functions 
  • Formatting Date and Time 

 

  • Power Automate – Advanced functions 
  • Workflow functions  
  • Data from earlier Action and Triggers 
  • Null or missing values 
  • The ? Operator 
  • Notations for ? operator 
  • Data from Collections and Arrays 
  • Other function groups 

 

  • Power Automate – Configuration 
  • Introduction to limits 
  • Trigger settings 
  • Tracked Properties 
  • Create a Tracked Property 
  • Accessing Tracked Properties 
  • A calculation from a Tracked Property 
  • A more complex calculation of an interval 
  • Manipulate the output for accuracy 
  • Secure Inputs and Outputs 
  • Concurrency control 
  • Trigger conditions 
  • Other settings and configurations 

 

  • SharePoint Content Approval 
  • Introduction to Content Approval 
  • Approving items in SharePoint  
  • SharePoint Workflows and the future of these 
  • Power Automate and SharePoint 
  • SharePoint Triggers 
  • SharePoint Actions 
  • Controlling publishing in SharePoint using Approvals 
  • Create a site for communicating to everyone in an organisation 
  • Configuring pages to publish after approval 
  • Modify a page and await approval 
  • Using SharePoint to manage approvals 
  • Better alternative in using Power Automate 
  • Create a Flow from blank 
  • Set Trigger for any new or changes page 
  • Create an approval set of actions 
  • Test the new Flow by editing or creating a page

 

  • SharePoint Approval Flow 
  • Create a Power Automate approval Flow from within the Library 
  • Verify content approval is turned on in the Library 
  • Replicate the same approval process steps as previous solution 
  • Test new approval 
  • Add or modify documents 
  • Verify the approval status of documents 

 

  • Teams – Adaptive Cards  
  • Types of Teams Apps 
  • What are Adaptive Cards 
  • Uses for Adaptive Cards 
  • A basic Card 
  • Reference information for creating Cards 
  • Creating a basic card configuration 
  • Creating a Flow with an Adaptive Card 
  • Design elements  
  • Types of Cards 
  • Collections 
  • Best Practices of Cards 
  • Text Formatting  
  • Using @ mentions  
  • HTML formatting  
  • Markdown formatting  
  • Card actions 
  • Open a URL button 
  • More complex button types 
  • Samples of Adaptive Cards  
  • Try-It-Yourself in designer 
  • Using the Designer  
  • Key Designer features 
  • Using the card schema in Flow 
  • Verify the card in Teams 

 

  • Power Platform in SharePoint 
  • What is Power Platform 
  • What are Power Apps 
  • SharePoint Lists 
  • Enter and edit data in a SharePoint List 
  • Managing a list with the 3 screen Power App 
  • Getting started with Power Apps 
  • Create a new Power App from the SharePoint List 
  • The Power App designer 
  • Basic Power App features 
  • A simple Power App modification 
  • Test the Power App in designer 
  • Play and Save the App  
  • Publish and Share the App 
  • Input data via the App 
  • View list entries and edit the data from the App 
  • View the data from SharePoint  

 

  • Power Platform Real Time Data in Power BI 
  • Power BI datasets introduction 
  • Streaming data in Power BI 
  • Create a Power BI Workspace 
  • Create a Streaming Dataset 
  • How to access the Streaming Dataset 
  • Power BI and Power Automate working together 
  • Create a Flow to generate some data 
  • Send the data to the Power BI Streaming Dataset 
  • Run the Flow with test data 
  • View the immediate results in Power BI 

 

  • Integration Project 
  • The Business Scenario 
  • Establish a Team 
  • Modify Team settings 
  • Disable channel creation 
  • Create a SharePoint site 
  • Create a SharePoint list 
  • Modify the list with specific data columns 
  • View Power Automate template for Teams channel creation 
  • Create a Flow from blank 
  • Set trigger as an item added to SharePoint List 
  • Create approval actions in Flow 
  • Add actions to create Teams channel 
  • Enhance Flow with additional communications 
  • Post a message with a simple Adaptive Card with channel details 

 

  • Cognitive Services (AI / ML) 
  • What is a Cognitive Service 
  • Artificial Intelligence and Machine Learning 
  • AI for experts 
  • AI for the end-user 
  • What is Azure 
  • Azure Cognitive Services overview 
  • Try Azure services 
  • Text analysis 
  • Image analysis 
  • Facial analysis 
  • Artificial Intelligence in Office 365 
  • Artificial Intelligence for Power Platform 

Why choose Nexacu?

Valued by Individuals

 

4.8/5
Over 18460 Reviews
Course was very good with practical applications covered extremely well. Steven was a very good presenter and covered all the requirements very well -PowerPoint Level 2 Brisbane
Mark - PowerPoint Level 2, .
Thanks Nexacu. Ben did a great job explaining things clearly and answering our individual questions. This was a great day. Many thanks. -Word Intermediate Brisbane
Tempe - Word Intermediate, .
Very helpful course. Teacher was lovely and patient This course is going to help me in my work. Thank you. -PowerPoint Level 2 Brisbane
Loren - PowerPoint Level 2, .
A lot of new information. Lots of info hard to take in everything. Learnt lots -PowerPoint Level 2 Brisbane
Gloria - PowerPoint Level 2, .
Covered a good range of topics and exercises. The course was very interactive which was great. I feel like the course needs to be longer to allow more time to build and practice skills or perhaps offer a beginner and advanced course. There is an awful lot that the software can do. It would be useful to be able to follow along with the manual as I'm worried I'll get lost when I try this in practice. -SharePoint Site Owner Adelaide
Sarah - SharePoint Site Owner, .
Great break down and summary with each section covered. Easy to follow with good examples. Facilitator was able to adjust the course to the different levels within our group. Inspired to try and test my knowledge back in the office. -SharePoint Site Owner Adelaide
Kristine - SharePoint Site Owner, .
It was a very complex topic which got confusing at times but I ended up taking away a lot of new knowledge which will be very useful in my work. -SharePoint Site Owner Adelaide
Cindy - SharePoint Site Owner, .
Fantastic couple of days. Very informative and I appreciate your patience training style. -SharePoint Site Owner Adelaide
Christine - SharePoint Site Owner, .
Jagg explained things well and made the course easy to understand. He is light and entertaining and made the days go fast. Thanks -SharePoint Site Owner Adelaide
Natalie - SharePoint Site Owner, .
Very interesting course -SharePoint Site Owner Adelaide
Jade - SharePoint Site Owner, .
Thank you, this was a very useful course. It is finally tying in all the bits I needed to have a full view of this product. -Power BI DAX Sydney
Wendy - Power BI DAX, .
Very helpful, thanks -Power BI DAX Sydney
Kate - Power BI DAX, .
Good pace and useful content -Office365 Intermediate Parramatta
Linda - Office365 Intermediate, .
was great and very informative. makes using PP seems so easy -PowerPoint Level 2 Melbourne
Fleur - PowerPoint Level 2, .
John was a great trainer. Very easy to follow and understand. I have left today definitely feeling like I have learnt something. Thank you. -PowerPoint Level 2 Melbourne
Jamie - PowerPoint Level 2, .
I thought it was very informative I learnt a lot and would highly recommend -PowerPoint Level 2 Melbourne
Jason - PowerPoint Level 2, .
Great trainer, very informative session. -PowerPoint Level 2 Melbourne
Rachael - PowerPoint Level 2, .
Knowledgeable. Able to answer my queries. -PowerPoint Level 2 Melbourne
Efrat - PowerPoint Level 2, .
Comprehensive course with knowledgeable trainer. -PowerPoint Level 2 Melbourne
Sai - PowerPoint Level 2, .
Very usufull -Excel Advanced Melbourne
wasantha - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia