Microsoft 365 Fundamentals

What's inside

Learning objectives

Microsoft 365 fundamentals
How to use microsoft 365

How to use the different apps that are part of microsoft 365
Where you can find support information for microsoft 365

Microsoft 365 fundamentals
How to use microsoft 365
How to use the different apps that are part of microsoft 365
Where you can find support information for microsoft 365

Syllabus

Introduction

This lecture provides an initial Introduction to Office 365

This lecture walks you through and initial tour of Office 365

A quick introduction to Microsoft Teams. This lecture walks you through the concepts we will cover in the course.

This lecture gives you a brief overview of Microsoft Teams and what it's all about & how you can use it at the workplace.

This lecture covers Microsoft Teams resources that are available to you for free & the Microsoft Teams app

This lecture goes through the Teams demo that Microsoft offers.

This lecture walks you through a real world example and setup of Microsoft Teams and takes you through an initial Tour of Microsoft Teams as an application

This lecture covers the ins and outs of creating and managing teams in Microsoft Teams.

This lecture covers the ins and outs of creating and managing channels in Microsoft Teams.

This lecture covers chatting in Teams, how to text, call, share emojis, gifs and more.

This lecture cover everything else you should know about Microsoft Teams. So all the additional features, characteristics and functionality which wasn't covered in previous lectures of the course.

This lecture is a real world video conference call in Microsoft Teams where I interview Felipe Gomez about his experience with Agile.

This lecture gives you a brief introduction on Microsoft Planner and walks you through some of the initial Planner concepts.

This lecture compares Microsoft Planner vs. other tools out there used for planning and managing projects.

This lecture walks you through the official Microsoft Planner website.

This lecture gives you an initial tour of Microsoft Planner. From how Planner looks, some of its unique terminology and more.

This lecture covers where to find support documentation and resources for Microsoft Planner.

This lecture covers how you can help improve Microsoft Planner and stay up to date with the latest Planner updates.

This lecture walks you through a real world example of Microsoft Planner and how it can be used as an Agile Kanban Board.

This lecture covers:

How to change font in Excel
How to change the background color of a cell in Excel
How to change the text size in Excel
How to change text color in Excel
How to convert a number to currency in Excel
How to add the dollar symbol in Excel
How to copy format from one cell to another in Excel
How to build a profit and loss template in Excel from scratch
How to leverage on Excel's smart functionality to automatically add months of the year in a spreadsheet

This lecture covers:

How to freeze panes in Excel
How to unfreeze panes in Excel
How to free rows in Excel
How to unfreeze rows in Excel
How to freeze columns in Excel
How to unfreeze columns in Excel
Why it's helpful to freeze panes in Excel and why so many people use it

This lecture covers how to create Microsoft Excel Templates with ChatGPT by using a very simple and powerful ChatGPT app you can use to create and download Microsoft Excel Templates in seconds.

This lecture provides an initial introduction into the world of Microsoft PowerPoint & what you can expect from Microsoft PowerPoint.

This lecture covers how to save in Microsoft PowerPoint and why it's important to save your work in Microsoft PowerPoint.

This lecture walks you through working with text in Microsoft PowerPoint. In this part of the course you'll learn how to change font type, font size, font color and more in Microsoft PowerPoint.

In this lecture we'll cover how to insert slides in Microsoft PowerPoint, how to delete them and how to move slides around in Microsoft PowerPoint.

In this part of the course we'll cover how to insert images in Microsoft PowerPoint and how to use the powerful Designer tool in Microsoft PowerPoint. This tool leverages on AI (Artificial Intelligence) to create amazing and outstanding slides in Microsoft PowerPoint.

In this lecture we'll cover where to source free high quality images and photos for your Microsoft PowerPoint slides. We'll also go into a few paid options which you can consider when sourcing outstanding images for your PowerPoint presentations.

In this lecture we'll go over a benchmark Microsoft PowerPoint presentation which can serve as inspiration when you're working on your Microsoft PowerPoint slides.

In this lecture we'll go over some of my hot tips and tricks that will allow you to create effective and impactful Microsoft PowerPoint presentations.

In this lecture we cover how to translate your Microsoft PowerPoint Slides or Slide Deck.

In this lecture we cover how to use real time presentation subtitles when using Microsoft PowerPoint.

This lecture covers how to create Microsoft PowerPoint Templates with ChatGPT by using a very simple and powerful ChatGPT app you can use to create and download Microsoft PowerPoint Templates in seconds.

This lecture points you to additional Microsoft PowerPoint resources directly from Microsoft itself.

This lecture covers how to create Microsoft Word Templates with ChatGPT by using a very simple and powerful ChatGPT app you can use to create and download Microsoft Word Templates in seconds.

This lecture introduces you to Microsoft OneDrive and what you can do with this powerful tool

This lecture covers the different plans and pricing for OneDrive

This lecture walks you through the ins and outs of OneDrive in an initial tour

This lecture shows you how to create, view and open files in OneDrive

This lecture shows you how to upload, rename, download, copy and move files in OneDrive

This lecture walks you through everything you need to know about sharing files and folders with OneDrive

Bonus Lecture (Final Lecture)

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Provides a practical overview of Microsoft 365 applications, which is beneficial for professionals aiming to improve their daily workflows

Covers Microsoft Teams, which is a widely used collaboration tool in many workplaces, and teaches learners how to manage teams and channels

Explores Microsoft Planner, which is a project management tool that helps users organize tasks and improve team collaboration

Includes coverage of Excel, PowerPoint, and OneDrive, which are essential tools for data analysis, presentations, and cloud storage

Features lectures on creating templates with ChatGPT for Excel, PowerPoint, and Word, which may be useful for those looking to automate document creation

Includes lectures that cover older versions of Microsoft 365 applications, which may not reflect the latest features and updates

Reviews summary

Comprehensive introduction to microsoft 365

According to learners, this course offers a fantastic overview and solid foundation for anyone new to the Microsoft 365 ecosystem. Students say it is excellent for beginners and provides the essentials needed for work. The instructor is highly praised for being clear, easy to follow, and knowledgeable. Reviewers consistently mention the well-structured content, including bite-sized modules that make information easy to digest, and appreciate the practical approach with real-world examples and demos. While some learners noted it's a fundamentals course and doesn't deep-dive into advanced features, they agree it effectively covers the main applications and builds confidence for further exploration.

Covers essentials, not advanced topics.

"While it provided a good overview of each application, I would have liked to see more in-depth coverage of some of the advanced features... However, considering it's a fundamentals course, the level of detail was appropriate."

"Don't expect deep dives, but for fundamentals, it's excellent."

"Covers the core apps well. Some sections felt a little rushed..."

"A good overview. It covers the main applications and their basic functions. Could benefit from slightly more detailed examples in some areas."

Real-world applications are useful.

"The instructor provided real-world examples and demonstrations, which helped me understand how to apply the concepts in a practical setting."

"The hands-on exercises were also valuable in reinforcing the learning."

"The real-world examples are a big plus."

"The demos were particularly useful."

"This course is exactly what I needed to get up to speed with M365 for my job. Practical, clear, and well-paced."

Content is easy to follow and digest.

"The course is well-structured"

"I love the bite-sized modules that focus on one area. This makes it much easier to understand and digest the information."

"The organization of the modules made it easy to navigate through the course."

"It's well-structured and easy to follow."

"The structure is logical, and the delivery is clear."

Instructor explains concepts effectively.

"the instructor has an excellent delivery, clearly explaining each area."

"The instructor is clear and easy to follow."

"Instructor explains clearly and keeps it simple."

"Another positive aspect was the instructor's engaging teaching style. They were knowledgeable and passionate..."

"The instructor clearly knows their stuff and explains complex topics simply."

Builds a solid base in M365.

"Excellent course... Great foundation built."

"This course gives a solid overview of Microsoft 365... Good starting point."

"This course provided me with a fantastic overview and introduction to Microsoft 365. It has given me the foundations and confidence..."

"found the course to be incredibly helpful in providing a solid foundation."

"The course does a great job of covering the fundamentals... It was very helpful for someone like me who had limited prior knowledge..."

Ideal for newcomers to M365.

"Excellent introductory course for M365."

"Recommended for beginners."

"Perfect for getting a grip on the essential tools."

"As a complete beginner, this course was perfect."

"Highly recommend this course for beginners. It demystifies M365 and gives you confidence..."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft 365 Fundamentals | Microsoft 365 Essentials with these activities:

Review Microsoft Office Fundamentals

Show steps

Reinforce your understanding of core Microsoft Office concepts before diving into Microsoft 365. This will help you grasp the new features and integrations more easily.

Browse courses on Microsoft Office Suite

Show steps

Review your notes from previous courses.
Practice using basic features in each application.
Identify areas where you need a refresher.

Read 'Microsoft 365 for Dummies'

Show steps

Gain a solid foundation in Microsoft 365 with a beginner-friendly guide. This will help you understand the core concepts and navigate the platform more effectively.

View Melania on Amazon

Show steps

Obtain a copy of 'Microsoft 365 for Dummies'.
Read the chapters relevant to the course syllabus.
Take notes on key concepts and features.

Follow Microsoft's official tutorials

Show steps

Enhance your practical skills by working through Microsoft's official tutorials for each application. This will give you hands-on experience and reinforce your understanding of the concepts.

Show steps

Visit the Microsoft 365 support website.
Select tutorials for Excel, PowerPoint, Teams, and OneDrive.
Follow the tutorials step-by-step.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Excel data manipulation exercises

Show steps

Improve your Excel skills by practicing data manipulation techniques. This will help you become more proficient in using Excel for data analysis and reporting.

Show steps

Find or create a sample dataset.
Practice sorting, filtering, and transposing data.
Create charts and pivot tables to visualize the data.

Read 'Mastering Microsoft Teams'

Show steps

Expand your knowledge of Microsoft Teams with an advanced guide. This will help you master the platform and use it effectively for collaboration and communication.

View Putting Knowledge to Work on Amazon

Show steps

Obtain a copy of 'Mastering Microsoft Teams'.
Read the chapters relevant to your work or interests.
Experiment with the advanced features discussed in the book.

Create a PowerPoint presentation

Show steps

Solidify your understanding of PowerPoint by creating a presentation on a topic related to your work or interests. This will help you apply the skills you've learned in the course.

Show steps

Choose a topic for your presentation.
Create an outline and gather relevant information.
Design your slides using the techniques learned in the course.
Practice your presentation.

Project: Automate a task with Power Automate

Show steps

Deepen your understanding of Microsoft 365 by automating a repetitive task using Power Automate. This will help you explore the integration capabilities of the platform.

Show steps

Identify a repetitive task in your workflow.
Research how to automate the task with Power Automate.
Create a flow in Power Automate to automate the task.
Test and refine your flow.

Career center

Learners who complete Microsoft 365 Fundamentals | Microsoft 365 Essentials will develop knowledge and skills that may be useful to these careers:

Virtual Assistant

A Virtual Assistant provides administrative, technical, or creative assistance to clients from a remote location. This role often requires proficiency in various software applications. This Microsoft 365 course helps the Virtual Assistant become adept at using Microsoft Office applications like Word, Excel, and PowerPoint, as well as communication tools like Teams. This course provides the fundamental skills necessary for a Virtual Assistant to manage tasks and provide support to clients remotely and effectively. The breadth of relevant skills makes this course especially useful for a virtual assistant.

See salaries and explore the career path for Virtual Assistant

Data Analyst

A Data Analyst interprets data to help organizations make better decisions. This role involves extensive use of spreadsheet software. This Microsoft 365 course is a great fit for a Data Analyst, as it helps them develop a deep understanding of Microsoft Excel, which is a critical tool for data manipulation and analysis. Learning to use features, like pivot tables and charts effectively will enable the Data Analyst to derive greater insights from data. This course is particularly useful for those who want to use Excel for their data analysis work.

See salaries and explore the career path for Data Analyst

Administrative Assistant

An Administrative Assistant provides crucial support to an organization by handling various office tasks. This involves using software tools for scheduling, communication, and documentation. This Microsoft 365 course helps Administrative Assistants become proficient in Microsoft applications such as Excel, PowerPoint, and Word for creating documents, presentations, and reports. The course is particularly relevant since it is designed to enhance efficiency and organization in an office environment through Microsoft applications, which are essential for the daily tasks of an Administrative Assistant.

See salaries and explore the career path for Administrative Assistant

Team Coordinator

The Team Coordinator works closely with teams to facilitate their activities and improve collaboration. This includes scheduling, communication, and task allocation. This course will help the Team Coordinator become proficient with Microsoft Teams for team communication and collaboration, and Planner for organizing tasks and projects. The course helps a Team Coordinator to effectively manage team operations and resources. This course's focus on key Microsoft 365 apps helps the Team Coordinator bring greater efficiency to a team.

See salaries and explore the career path for Team Coordinator

Office Manager

An Office Manager oversees the day-to-day operations of an office, ensuring smooth and effective workflows. This involves utilizing various software and communication platforms. This course helps the Office Manager gain expertise in using Microsoft 365 tools such as Teams for communication, Planner for task management, and OneDrive for document sharing and storage. With this knowledge, the office manager can establish a more efficient and collaborative work environment. The hands-on training with these tools makes this course particularly useful for any Office Manager.

See salaries and explore the career path for Office Manager

Project Coordinator

A Project Coordinator plays a vital role in supporting project managers by organizing project activities. This includes tasks such as scheduling meetings, managing documents, and tracking progress. This course on Microsoft 365 helps build a foundation for using tools like Microsoft Teams for team collaboration and communication, Planner for project planning and task management, and OneDrive for file sharing. A project coordinator benefits from a strong capability with these tools to ensure project success and efficient workflow. The course is particularly relevant due to the hands-on training in how to leverage these Microsoft applications for practical project needs.

See salaries and explore the career path for Project Coordinator

Marketing Coordinator

A Marketing Coordinator supports marketing activities by organizing events, managing content, and assisting with campaigns. This role benefits from strong organizational and communication skills. This Microsoft 365 course helps build a Marketing Coordinator’s proficiency with Microsoft Teams for communication and collaboration, as well as Excel and PowerPoint for managing data and creating presentations related to marketing campaigns and results. The hands-on approach means that this course is particularly useful to enhance a Marketing Coordinator’s workflow.

See salaries and explore the career path for Marketing Coordinator

Business Analyst

A Business Analyst examines an organization’s processes and systems to identify areas for improvement. This role often requires the use of data analysis and presentation tools. This course helps the Business Analyst become proficient in Microsoft Excel for data manipulation and analysis, as well as PowerPoint for creating presentations outlining their findings and recommendations. The Business Analyst can take advantage of this course to enhance the effectiveness of their presentations and analyses. This course could be very useful for a business analyst.

See salaries and explore the career path for Business Analyst

Sales Associate

A Sales Associate engages potential clients, presents products, and closes sales. This often requires creating presentations and managing client information. This Microsoft 365 course helps a Sales Associate build a working knowledge of PowerPoint for creating sales presentations, Excel for managing sales data, and Teams for collaborative work. By enhancing these skills, they become better equipped to present information effectively and drive sales. This course is particularly helpful for gaining practical skills with the tools that sales associates use daily.

See salaries and explore the career path for Sales Associate

Research Assistant

A Research Assistant supports researchers by conducting studies, managing data, and preparing reports. This Microsoft 365 course helps the Research Assistant to effectively use tools like Excel for data organization and analysis, PowerPoint for presentations, and OneDrive for document management. This course enables the Research Assistant to organize and present research data effectively. The hands on approach to learning these tools makes this course especially useful for a research assistant.

See salaries and explore the career path for Research Assistant

Information Manager

An Information Manager is responsible for organizing and managing an organization's data and information resources. This includes ensuring that data is accessible, secure, and used effectively. This Microsoft 365 course helps an Information Manager as it provides an understanding of how Microsoft 365 can be leveraged for efficient document management via OneDrive and collaboration using Teams. An Information Manager can leverage the knowledge gained from a course like this to improve their workflows and ensure data is well-managed. This course is particularly useful for a practical introduction to these tools.

See salaries and explore the career path for Information Manager

Content Creator

A Content Creator develops engaging content for various platforms, often using tools for presentation and collaboration. This Microsoft 365 course helps build a Content Creator's skills in creating visually appealing content using PowerPoint, collaborating effectively on projects using Teams, and managing and sharing files effectively using OneDrive. The hands-on approach of this course helps the Content Creator learn how to generate and deliver polished, impactful content. This makes this course quite useful for a content creator.

See salaries and explore the career path for Content Creator

Training Specialist

A Training Specialist designs and delivers training programs to employees, often involving the use of presentation software and communication tools. This Microsoft 365 course may be helpful, as it helps the Training Specialist to master tools like PowerPoint for creating training materials, Teams for virtual training sessions, and OneDrive for sharing resources. The course also provides experience with other key programs, which enables the training specialist to better train others. This course can be quite useful for improving a training specialist's capabilities and effectiveness of training programs.

See salaries and explore the career path for Training Specialist

Customer Service Representative

A Customer Service Representative provides support to customers, answering inquiries and resolving issues. This role requires familiarity with communication tools and knowledge management systems. This Microsoft 365 course may be useful, as it helps a Customer Service Representative learn to use Microsoft Teams for internal communication and collaboration, as well as OneDrive for accessing and sharing support materials. This will enhance efficiency in providing customer support. The course may be valuable by improving a customer service representative's ability to respond quickly and effectively to customers.

See salaries and explore the career path for Customer Service Representative

Technical Support Specialist

A Technical Support Specialist assists users with technical issues related to software and hardware. This role requires a solid understanding of the tools they support. While this course focuses on the usage of Microsoft 365, it may be helpful, as it gives a Technical Support Specialist a deeper understanding of the full suite of applications. This can greatly aid the specialist in assisting users with issues related to Teams, Excel, PowerPoint, or OneDrive. This course may be particularly valuable, as it offers a hands-on approach to working with these tools.

See salaries and explore the career path for Technical Support Specialist

Microsoft 365 Essentials

What's inside

Learning objectives

Syllabus

Traffic lights

Save this course

Reviews summary

Comprehensive introduction to microsoft 365

Activities

Career center

Reading list

Share

Similar courses