Intermediate Microsoft Office (Word, Outlook, Power Point and Excel)
Learn from a user’s perspective what’s possible in Microsoft 365 with this highly interactive intermediate course, building on your existing knowledge to enhance efficiency and confidence for both personal and professional use!
As an intermediate learner of Microsoft Office 365, you will deepen your skills in Word, Excel, and PowerPoint in one comprehensive course designed to help you work smarter and more effectively.
Microsoft 365 continues to be a powerful productivity suite that supports efficiency, flexibility, and collaboration in a user-friendly environment. Used by millions worldwide, it remains a key requirement in today’s digital workplace.
In this intermediate course, you will move beyond the basics and begin to apply more advanced tools and features within Word, Excel, and PowerPoint. You will learn how to create polished documents, analyze and manage data more effectively, and design engaging presentations that clearly communicate your ideas.
Please note that this course will not cover analytics on Excel. If you would like to learn analytics, register for the beginner Data Analytics on Excel course.
-
Course outline
Week 1 & 2 – Intermediate Microsoft Word
Advanced document formatting (styles, themes, section breaks)
Working with templates and creating custom templates
Advanced page layout (columns, spacing, margins, orientation)
Managing large documents (table of contents, navigation pane)
Inserting and formatting tables, images, SmartArt, and charts
Headers, footers, page numbering, and document branding
Collaboration tools (track changes, comments, version history)
Integration with other Microsoft 365 applications
Week 3, 4 & 5 – Intermediate Microsoft Excel and PowerPoint
Microsoft Excel
Advanced workbook management and formatting
Data organization and analysis (sorting, filtering, conditional formatting)
Creating and customizing charts and graphs
Working with tables and named ranges
Data validation and error checking
Integration with other Microsoft 365 applications
Microsoft PowerPoint
Designing professional presentations using themes and slide masters
Advanced slide layouts and formatting
Adding and editing multimedia (images, audio, video)
Using SmartArt, charts, and visual elements effectively
Transitions and animations for impact (best practices)
Presenter tools and delivering engaging presentations
Collaboration and sharing presentations
Integration with other Microsoft 365 applications
Week 6 – Integration, Productivity Tools & Course Wrap-Up
Cross-application integration (Word, Excel, PowerPoint with OneDrive/Teams)
File sharing, collaboration, and cloud-based workflows
Time-saving tips, shortcuts, and productivity tools
Real-world scenarios and practical exercises
Review and consolidation of key concepts learned
Learning Outcomes
In this course, you will learn how to:
Create professionally formatted and structured documents in Word
Manage data using Excel tools
Design and deliver engaging, high-quality presentations in PowerPoint
Apply integration features across Microsoft 365 applications for improved workflow
Work more efficiently using intermediate-level tips, tools, and best practices
Course evaluation
A combination of multiple choice, demo exercises using sample data sets, group cases, cumulative assignments to wrap up all concepts learned (especially in the last week) and possibly take-home assignments
-
● Ability to speak, write, and understand English
● Have access to computers.
-
CAD $450
-
Zaimin Karmali is a CPA (Certified Public Accountant) and Microsoft Certified. She has a Masters in Adult Education and is a Certified Training Development Professional. She has over 10 years of teaching in both the public and private sector designing her own curriculum and training strategy on complex accounting and business topics. She has over 20 years of accounting, audit and tax experience and has worked with a wide array of clients both in the government and private sector. She has a passion for teaching and always will. She loves to make students’ learning journey as valuable as possible, her way of making a difference in the world.
-
Training model: online
Course length: 4 weeks