Really enjoyed the flow of this. The practical applications discussed were spot on. Great course!
Office Productivity: Intermediate Excel, Word, PowerPoint, and Outlook
Move beyond the basics and master essential intermediate techniques in Excel, Word, PowerPoint, and Outlook to work faster and more efficiently.
-
💬
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
5 modules · 28 lessons · 2h 59m
1
Excel: Data Analysis and Power
Master modern functions and data analysis
- Data organization and cleaning
Learn how to structure data into tables for efficient analysis.6 min - The XLOOKUP (CERCA.X) revolution
Replace the old VLOOKUP with a more powerful and flexible function.7 min - Dynamic arrays and filter functions
Use formulas that automatically expand results across multiple cells.7 min - Creating effective Pivot Tables
Summarize large amounts of data with just a few clicks.7 min - Advanced analysis with Pivot Tables
Insert calculated fields and time groupings into pivot tables.7 min - Professional conditional formatting
Automatically highlight critical data using visual rules.6 min
2
Word: Professional Documents
Create structured documents ready for collaboration
- Document structure and sections
Organize long documents using section breaks and different numbering.6 min - Mastering Advanced Styles
Ensure visual consistency and generate automatic tables of contents with one click.7 min - Creating and using Templates
Save time by creating reusable templates for reports and letters.6 min - Professional reviews and comments
Manage suggested changes from colleagues without losing control of the file.6 min - Cross-references and captions
Dynamically link tables and figures within the text.6 min - Automation with Building Blocks
Quickly insert recurring text snippets or tables.6 min
3
PowerPoint: Design and Storytelling
Design modern presentations that capture attention
- Modern layout principles
Use the grid and alignment for a clean look.7 min - Clean design aesthetics
Choose colors and fonts that improve readability and impact.6 min - Smooth transitions with Morph
Easily create cinematic animations between slides.7 min - Animations with a purpose
Use animations to guide the audience's eye, not distract them.6 min - Advanced multimedia integration
Insert videos, icons, and 3D models to enrich the message.6 min - Visual storytelling
Transform data into engaging visual narratives.6 min
4
Outlook: Efficiency and Automation
Manage daily workflow without stress
- Inbox organization
Use categories and folders to keep the Inbox clean.6 min - Advanced sorting rules
Automate moving emails based on senders or keywords.7 min - Smart search folders
Create dynamic email views based on specific criteria.6 min - Advanced Calendar management
Schedule meetings, manage time zones, and shared calendars.7 min - Automation with Quick Steps
Perform multiple actions (e.g., reply and archive) with a single click.6 min - Task and To-Do integration
Turn emails into manageable tasks directly within Outlook.6 min
5
Integrated Collaboration
Work in teams smoothly and securely
- Sharing and permissions
Share files via the cloud while ensuring data security.6 min - Real-time co-authoring
Work on the same file simultaneously with colleagues.7 min - Version history and recovery
Recover previous versions of a document without fear of errors.6 min - Cross-app workflow
Dynamically integrate Excel tables into Word and charts into PowerPoint.7 min
Final Project: The Integrated Corporate Report
Create a complete work package for a fictional product launch. You will analyze projected sales data in Excel, write the formal proposal in Word, prepare the pitch in PowerPoint, and plan the launch with the team via Outlook.
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
2h 59m 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 (4)
Loved this! The structure made complex ideas easy to digest. I can already see how I'll use this in my daily work.
Solid content and presented clearly. I appreciated the real-world applications shown. Could have used a few more practice opportunities.
This course exceeded my expectations. The real-world applications discussed are incredibly useful. Great job!
Learners also took
Time Management and Prioritization for Modern Productivity
Google Chat Essentials: Streamline Team Communication and Collaboration
Gmail Foundations: Efficient Email Management and Productivity
Outlook Productivity: Rules, Automation, and Calendar Management
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.