Office 365 includes a set of advanced tools that most users never touch. This course is for users who have completed the foundational Office courses and want to go further. Power Query transforms how you handle data imports. SharePoint changes how teams share files. OneDrive solves files that only exist in one place. Power Automate lets you build workflows that trigger automatically. We focus on the features that produce the greatest efficiency gains in real professional work.
What you will be able to do
Use Power Query to import and transform data automatically
Share and collaborate via SharePoint sites
Sync files anywhere with OneDrive
Build Power Automate workflows for repetitive tasks
Connect Office apps into efficient cross-application workflows
Course modules
Power Query
Import, transform, refresh data
Advanced Excel
Array functions, dynamic arrays
SharePoint
Sites, libraries, collaboration
OneDrive
Sync, share, access everywhere
Power Automate
Flows, triggers, automation basics
Cross-App Workflows
Connecting Office applications
Who this is for
- Users who completed the foundational courses
- Power users who want to automate more
- IT admins supporting teams on Microsoft 365
- Anyone not getting full value from Office 365
Lifetime access
Certificate Included
Practice files included
12h 00min of content
EN + PT language options
Access within 24 hours. 14-day refund available.