Training Course in Microsoft 365 with Power BI

Course Level: Advanced

Introduction

This course focuses on introducing Microsoft 365’s core productivity tools, such as Word, Excel, PowerPoint, Outlook, Teams, OneDrive, and SharePoint.

Participants will gain practical knowledge on how to use these tools for seamless collaboration, communication, and productivity. Power BI will be briefly introduced as a tool that can integrate with Microsoft 365 to enhance data visualization and reporting.

Duration

5 Days

What You Will Learn

• Overview of Microsoft 365 apps and their use for personal and team productivity
• Managing emails and calendars using Outlook
• Collaborating with Teams and sharing files using OneDrive and SharePoint
• Creating and editing documents, spreadsheets, and presentations with Word, Excel, and PowerPoint
• Introduction to Power BI and its integration with Microsoft 365 for simple reporting

What You Can Do With Microsoft 365?

• Streamline work with a suite of productivity tools like Word, Excel, PowerPoint, Teams, and OneDrive
• Organize emails, manage calendars, and schedule meetings with Outlook
• Share documents and collaborate in real time using SharePoint and Teams
• Visualize data in Power BI, integrated with Microsoft 365 tools

Who Should Take This Course?

• Business professionals who want to improve productivity using Microsoft 365 tools
• Administrative staff looking to enhance their workflow
• IT professionals seeking a deeper understanding of Microsoft 365 applications
• Students and individuals new to Microsoft 365
• Anyone interested in improving collaboration and efficiency with Microsoft tools

Course Requirements

• A laptop or desktop computer
• Microsoft 365 subscription (or trial version)
• Basic familiarity with computer operations (not required but helpful)
• Proficiency in English

Topics to Be Covered

• Overview of Microsoft 365 apps: Word, Excel, PowerPoint, Teams, OneDrive, SharePoint, and Outlook
• Managing emails and calendars with Outlook
• Collaborating and sharing files with Teams and SharePoint
• Using Word, Excel, and PowerPoint for document creation and presentation
• A brief introduction to Power BI: What it is, how it connects to Microsoft 365, and its simple reporting capabilities

Course Objectives

• By the end of this course, learners will be able to:
• Navigate and use Microsoft 365 apps like Word, Excel, PowerPoint, Teams, OneDrive, SharePoint, and Outlook
• Collaborate with colleagues using Teams and SharePoint
• Create and edit documents and presentations with Word, Excel, and PowerPoint
• Understand the basic integration of Power BI with Microsoft 365 for data visualization

Learning Outcomes

• At the end of this course, learners will be able to:
• Use Microsoft 365 apps for personal and team productivity
• Manage emails, tasks, and meetings in Outlook
• Share files and collaborate with others in Teams and SharePoint
• Create, edit, and present documents using Word, Excel, and PowerPoint
• Understand how Power BI integrates with Microsoft 365 for data reporting

Course Outline

Module I: Introduction to Microsoft 365

• Overview of Microsoft 365 apps: Word, Excel, PowerPoint, Teams, OneDrive, SharePoint, and Outlook
• Basic navigation and account setup

Module II: Getting Started with Core Apps

• Outlook: Managing emails, calendar, and tasks
• Word: Creating and formatting documents
• Excel: Basic data entry and spreadsheet management
• PowerPoint: Designing effective presentations

Module III: Collaboration and File Sharing

• Using Teams for communication and file sharing
• Organizing and sharing files in OneDrive and SharePoint
• Collaborating on documents and projects in real-time

Module IV: Brief Introduction to Power BI

• What is Power BI, and how does it integrate with Microsoft 365
• Simple use case: Connecting Power BI with Excel and OneDrive for basic reporting
• Overview of creating and sharing Power BI reports

Module V: Final Project and Collaboration

• Practical session: Collaborating using Microsoft 365 tools
• Creating a simple report in Power BI (brief introduction)
• Q&A and troubleshooting