What Microsoft 365 applications are covered in this complete office course?

The course covers Excel, Word, PowerPoint, Access, Outlook, and Microsoft Teams.

Can I learn how to set up a Gmail account in Microsoft Outlook?

Yes. The Outlook section explains Gmail setup, including enabling the required account access settings.

What will I learn in the Microsoft Teams tutorial?

You will learn the key Teams components, including teams, channels, chats, meetings, and collaboration tools.

Free Course Image Microsoft 365 office complete

Free online course Microsoft 365 office complete

Duration of the online course: 13 hours and 41 minutes

4.4

(11)

Boost your productivity with a free Microsoft 365 course: master Excel, Word, PowerPoint, Outlook, Teams & Access skills and earn a certificate-ready edge.

In this free course, learn about

Excel 2019 fundamentals: workbooks, worksheets, cells, and efficient data entry
Excel calculations: formulas, functions, and formatting data for clarity
Word 2019 basics: creating, editing, and formatting professional documents
Word 2019 interface: understanding the three main tabs shown on opening Word 2019
PowerPoint 2021 skills: building presentations with layouts, themes, and design tools
Purpose of PowerPoint for Microsoft 365 tutorial: using PowerPoint effectively in 365/Office 365
Access 2019 concepts: what Access is and when to use a database vs a spreadsheet
Access basics: tables, relationships, queries, forms, and reports
Outlook 2016/2019 essentials: email, calendar, contacts, and workplace workflows
Gmail setup for Outlook: enabling the required Gmail account setting for access
Microsoft Teams usage: chats, channels, meetings, and collaboration workflows
Key components of Microsoft Teams: teams, channels, tabs, chats, and files

About the free online course

Turn everyday office tasks into polished, professional results with practical Microsoft 365 skills that employers expect. This free online course is designed for anyone who wants to work faster, organize information confidently, and communicate more clearly using the core apps in the Microsoft 365 ecosystem. Whether you are starting from scratch or updating your knowledge for the workplace, you will build the habits that make spreadsheets, documents, presentations, email, and collaboration feel simpler and more consistent.

Across the learning experience, you will gain confidence in Excel for handling data, formulas, and analysis workflows that support real decisions. You will also develop strong Word fundamentals for creating clean, well-structured documents that are easy to read and share. As you progress, you will refine your ability to present ideas using PowerPoint with a professional rhythm, turning information into slides that look organized and persuasive without wasting time on formatting.

Productivity is also about communication and coordination. You will learn how Outlook supports day-to-day work with email organization and setup practices that help you connect accounts and keep messages under control. You will explore how Teams enables modern collaboration, from channels and chats to meetings and shared files, making it easier to coordinate with classmates or colleagues in one place. You will also become familiar with Access as a database tool for storing and managing structured information when spreadsheets are not enough.

To reinforce your progress, the course includes quick exercises and knowledge checks that help you verify what you understood and apply it immediately. By the end, you will feel more capable in common office scenarios, more efficient in routine tasks, and better prepared for roles that value Office productivity. It is a solid choice if you want a free learning path that supports your resume and can fit into a busy schedule.

Course content

Video class: Excel 2019 Complete Tutorial: Microsoft Excel Made Easy 2h27m
Exercise: What is the purpose of the tutorial on using Microsoft Excel 2019 based on Office 365?
Video class: Word 2019 Full Tutorial: Microsoft Word Made Easy 2h54m
Exercise: What are the three tabs presented when opening Word 2019 as part of Microsoft 365?
Video class: PowerPoint 2021 Tutorial for Professionals and Students | Microsoft 365, Office 365 1h58m
Exercise: What is the purpose of the tutorial on PowerPoint for Microsoft 365?

Video class: Access 2019 Full Tutorial: Microsoft Access Made Easy 2h59m
Exercise: What is Microsoft Access?
Video class: Microsoft Outlook 2016, 2019 Tutorial for the Workplace and Students - A Complete Tutorial 2h09m
Exercise: What do you need to enable in your Gmail account settings to be able to set it up in Microsoft Outlook?
Video class: Microsoft Teams Complete Tutorial: Teams Made Easy 1h12m
Exercise: What are the key components of Microsoft Teams?

Learn aboutMicrosoft 365

Explore free online Microsoft 365 courses and build practical skills in Word, Excel, PowerPoint, Outlook, Teams, SharePoint, and cloud collaboration. Learn at your own pace with beginner-friendly lessons, improve workplace productivity, and earn a certificate upon completion. Start learning Microsoft 365 for free and boost your career today.