Office 365 and Power Platform Essentials
Build professional skills in core productivity applications and learn to automate workflows using modern low-code tools.
-
💬
AI instructor
Ask about any lesson and get a clear answer instantly, anytime. -
🕐
Start anytime
No schedules or deadlines — learn at your own pace, whenever suits you. -
🌐
In English
Lessons, tasks and certificate — all fully in your language.
About this course
Course contents
6 modules · 29 lessons · 3h
1
Foundations and Professional Documentation
Master the Office 365 interface and create professional, accessible Word documents.
- Navigation and Terminology
Navigate the Office 365 ecosystem and understand key terms.6 min - Fundamental Word Processing
Create and structure Word documents using a hierarchical logic.6 min - Layout and Industry Standards
Apply styles and formatting that meet modern professional standards.7 min - Document Accessibility
Make documents readable for everyone, including users with visual impairments.6 min - Collaboration and Review
Use comments and track changes to collaborate with a team on the same file.6 min
2
Modern Excel: Data and Automation
Use Excel not just as a table, but as a powerful tool for dynamic data management.
- Spreadsheet Management
Organize data into structured tables for efficient management.6 min - The Power of Dynamic Arrays
Simplify complex calculations using formulas that expand automatically.7 min - Data Cleaning with Power Query
Import and clean messy data automatically without manual intervention.7 min - Transformation and Integration
Combine multiple data sources into a single coherent model.7 min - Validation and Control
Set rules to ensure the integrity of entered data.6 min
3
Visualization and Communication
Transform data into visual stories through charts, dashboards, and presentations.
- Visualization Principles
Choose the right chart for every type of message.6 min - Creating Modern Charts
Build clean and effective charts that communicate clearly.6 min - Interactive Dashboards
Assemble a dynamic control panel to monitor KPIs.6 min - Presentation Design
Create PowerPoint slides that support the speech without overloading it.6 min - Data Storytelling
Present results in a persuasive and professional manner.6 min
4
Power Apps: Low-Code Solutions
Create custom applications to solve specific business problems.
- Introduction to Low-Code
Understand how to create software without writing traditional code.6 min - Data Collection Apps
Build a mobile interface to enter data in the field.6 min - Connecting to Sources
Connect the app to an Excel sheet or a SharePoint list.7 min - Solving Business Problems
Customize app logic to automate a specific process.7 min - Basic User Experience
Make the app easy and intuitive for colleagues.6 min
5
Power Automate: Goodbye Manual Tasks
Automate repetitive workflows to save time.
- Workflow Logic
Understand the concept of triggers (events) and actions.6 min - Data Synchronization
Automatically move data between Outlook, Excel, and OneDrive.6 min - Eliminating Repetitive Tasks
Automate email sending and the creation of periodic reports.7 min - Notifications and Alerts
Receive automatic alerts when data changes or requires attention.6 min - Automated Approvals
Create a digital approval system for requests or time off.6 min
6
Integration and Final System
Unite all tools into a single data management ecosystem.
- Total Integration
Make Word, Excel, and Power Platform communicate in a single flow.5 min - Secure Data Management
Best practices for data security and sharing in the cloud.6 min - System Maintenance
How to update and manage automations over time.6 min - Review and Final Project
Summary of concepts and preparation for the final summary exercise.6 min
Integrated Business Expense Management System
You will create a complete system: a Power App to enter expenses, a Power Automate flow that saves data to Excel, and an Excel Dashboard to visualize budget trends.
What you'll get
-
📜
Certificate of completion
Add it to your LinkedIn profile -
💬
Personal AI tutor
Stuck on a lesson? Ask your built-in tutor anything, any time. -
🎧
Audio version included
Learn on the go — no screen needed -
♾️
Lifetime access
Come back anytime, no expiry -
📱
Phone or computer
Works anywhere, any device -
💸
14-day refund
No questions asked -
⚡
Short & focused
3h of practical content
Certificate of completion
Every course you complete on PickAClass issues a credential like this — original, with its own code, verifiable by URL, and detailed about what was actually demonstrated.
Reviews
No reviews yet — be the first to share your experience.
Learners also took
Excel Essentials: Formulas, Functions, and Data Analysis
Excel and Copilot Foundations for Modern Data Work
XML and XSLT: Beginner's Guide to Data Transformation
Excel Payroll Management and Financial Modeling
Frequently asked
What do I need to take this course? +
Just a phone or computer with internet. No installs, no special hardware.
How do I pay? +
By card via Stripe. We don’t store card details — Stripe handles them securely.
Can I get a refund? +
Yes — full refund within 14 days, no questions asked.
How long will I have access? +
Forever. Once you purchase, the course is yours to revisit anytime.
Will I get a certificate? +
Yes. On completion you'll receive a certificate you can add to your LinkedIn profile.
Get 10 courses a month
Members get 10 courses of their choice every month for $0. No per-course charges — you pay only the subscription.
- ✓ 10 courses every month
- ✓ Cancel anytime
Renews monthly. Unused courses expire at the end of each billing month.