January Sale - 20% of all courses - Book Today

learn office 365 nexacu australia
Nexacu Office 365 Mobile Image

Microsoft Office 365 Advanced - Hong Kong

Automate more with Power Automate

Learn from our experienced Microsoft Certified Trainers. Remote courses running in Hong Kong.

Microsoft's Office 365 is an expansive eco-system of applications extending beyond the traditional word processor and accounting spread sheet.  These traditional office 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, focuses on Power Automate to 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.

Microsoft Office 365 Advanced - Hong Kong

4.8
Nexacu Office 365 Mobile Image

Skilled end-users learn to create workflow automations using Power Automate. Remote Courses running in Hong Kong.

2530 2100 HKD
10 max
1 day

Hong Kong

Upcoming Courses:
Hong Kong
Date
Course
City
Status
Fri 5-Feb-21
Fri 5 Feb
Office365 Advanced
Hong Kong
Status: Confirmed
Confirmed
Wed 10-Feb-21
Wed 10 Feb
Office365 Advanced
Hong Kong
Status: Confirmed
Confirmed
Fri 19-Mar-21
Fri 19 Mar
Office365 Advanced
Hong Kong
Status: Scheduled
Scheduled
Thu 29-Apr-21
Thu 29 Apr
Office365 Advanced
Hong Kong
Status: Scheduled
Scheduled
Fri 9-Jul-21
Fri 9 Jul
Office365 Advanced
Hong Kong
Status: Scheduled
Scheduled
Fri 6-Aug-21
Fri 6 Aug
Office365 Advanced
Hong Kong
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Office 365 Advanced Hong Kong Course Details

Price
2530 2100 HKD
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
Address
16F & 17F, 700 Nathan Road, Kowloon, Hong Kong
microsoft_gold
deloite_logo

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 Teams Training Courses
Power Automate Training Courses
Microsoft Power Apps Training Courses
Microsoft Project Training Courses
Microsoft Visio Training Courses
Data Analytics Training Courses
Python Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Other Courses
Microsoft Power BI Training Courses
Microsoft Excel Training Courses
Microsoft Excel Specialist Training Courses
Microsoft SharePoint Training Courses
Microsoft Teams Training Courses
Power Automate Training Courses
Microsoft Power Apps Training Courses
Microsoft Project Training Courses
Microsoft Visio Training Courses
Data Analytics Training Courses
Python Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Course Rating
Microsoft Office 365 Training Courses

4.8 5 Microsoft Office 365 Training Courses
4.8 out of 5
25129 Student Reviews

Skills Test

Try our short skills test and find out which course is right for you.

Nexacu Skills Test

 skills test

 

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 Hong Kong 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 Hong Kong 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

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 25129 Reviews
Some very helpful tips, definitely things I can use in the future -Word Advanced Brisbane
Millie - Word Advanced, .
Very informative and engaging. Good teacher -Excel Intermediate Brisbane
Alisha - Excel Intermediate, .
was informative and well done -Excel Intermediate Brisbane
Sola - Excel Intermediate, .
thank you great course and facilitator was great -Excel Intermediate Brisbane
Luke - Excel Intermediate, .
very useful. -Excel Intermediate Brisbane
Jennifer - Excel Intermediate, .
Very clear and helpful. Good pace also. Well structured. -Excel Intermediate Brisbane
Aria - Excel Intermediate, .
This course was great. I knew very little about VBA prior to attending and Michael was clear and built knowledge so well that I feel confident attempting to apply this in real work situations. A highly recommended course. -Excel Macros/VBA 2 Day Parramatta
Mary - Excel Macros/VBA 2 Day, .
This course was amazing. Michael was such an engaging teacher and kept the class so informative and so easy to follow. We had a great time learning the content of this course and we loved the small class we were in. We could ask a lot of questions and enjoy the whole course at the same time. This was one of many courses I have attended with Nexacu and all the teachers are great. Michael is my favourite. 5 Stars from me from all perspectives !!! -Excel Macros/VBA 2 Day Parramatta
Jacqueline - Excel Macros/VBA 2 Day, .
Moved a bit quicker than the beginner but showed good examples of what you can do. I certainly need to go away and practice with some real data to apply what I have learned today. Many thanks -Power BI Intermediate Adelaide
Merrin - Power BI Intermediate, .
Thanks for the help! -Power BI Intermediate Adelaide
Bradley - Power BI Intermediate, .
Brilliant - learnt so much. Many thanks Jagg -Power BI Intermediate Adelaide
John - Power BI Intermediate, .
was able to learn new formulas and functions that will help me in the future. -Power BI Intermediate Adelaide
Estelle - Power BI Intermediate, .
Learnt a lot on how to manipulate and clean up data. Learnt to better manage permissions to data. Learnt more on the date functions, though still don't know how to calculate current week/previous week comparisons. -Power BI Intermediate Melbourne
Kristina - Power BI Intermediate, .
Learnt many items with Power Query and DAX, along with row level security which is of particular interest with the types of personnel reports I will need to build. -Power BI Intermediate Melbourne
Kylie - Power BI Intermediate, .
Excellent content, great teacher. Thank you! -Excel Intermediate Melbourne
Linda - Excel Intermediate, .
Steven was incredibly helpful in training us. He took the time to understand our professional roles and relate what we were learning to our day to day tasks. He was patient and professional. Thank you! -Word Intermediate Brisbane
Alison - Word Intermediate, .
I have enjoyed it and learned many tips. -Word Intermediate Brisbane
Kristian - Word Intermediate, .
This was great! -Word Intermediate Brisbane
Courteney - Word Intermediate, .
Well-paced and very informative training. Trainer is very knowledgeable and helpful with any questions. -Power BI Intermediate Brisbane
Emily - Power BI Intermediate, .
Great course. Jason was very clear and easy to understand. Learnt a lot in one day. Thanks! -Power BI Intermediate Brisbane
Ben - Power BI Intermediate, .

Trusted by Business

Awards and Accreditations

Follow us