Microsoft 365 Essentials: Teams, Word, and Excel

• Basic computer skills

Audience

• Managers
• Business professionals

Microsoft 365 (Office 365) is a subscription-based suite of productivity tools developed by Microsoft. It combines various applications and services designed to enhance productivity, communication, and collaboration for individuals, businesses, and organizations.

This instructor-led, live training (online or onsite) is aimed at beginner-level business professionals who wish to gain the skills necessary to utilize Teams, Word, and Excel effectively in a management context.

By the end of this training, participants will be able to:

• Gain a comprehensive understanding of Microsoft 365
• Navigate and utilize Microsoft Teams for communication, collaboration, and project management.
• Develop proficiency in creating, formatting, and managing Word documents.
• Use Excel for data entry, manipulation, and analysis.
• Explore how to integrate Microsoft 365 applications for seamless workflows.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction to Microsoft 365

• Introduction to Microsoft 365
• Benefits and features
• Navigating the Microsoft 365 interface

Microsoft 365 Administration Basics

• Setting up user accounts
• Managing permissions and roles
• Understanding subscription and licensing options

Microsoft 365 Security and Compliance

• Security features
• Data protection and compliance
• Best practices for maintaining security

Introduction to Microsoft Teams

• Overview of Teams
• Creating and managing teams and channels
• Navigating the Teams interface

Communication and Collaboration

• Chat and messaging
• Audio and video calls
• Scheduling and conducting meetings

Advanced Features

• Integrating with other Microsoft 365 apps
• Using apps and bots in Teams
• Best practices for effective team collaboration

Introduction to Microsoft Word

• Overview of Word interface
• Creating, opening, and saving documents
• Basic editing and formatting techniques

Advanced Document Formatting

• Styles and themes
• Working with tables and charts
• Using templates and building blocks

Collaboration and Review

• Track changes and comments
• Sharing and co-authoring documents
• Protecting and finalizing documents

Introduction to Microsoft Excel

• Overview of Excel interface
• Creating, opening, and saving workbooks
• Basic cell formatting and data entry

Data Manipulation and Analysis

• Working with formulas and functions
• Sorting and filtering data
• Creating and formatting tables

Advanced Excel Features

• PivotTables and PivotCharts
• Data validation and conditional formatting
• Using Excel for Business Intelligence

Integrating Microsoft 365 Applications

• Using Microsoft 365 apps together
• Sharing and embedding documents across apps
• Automating workflows with Power Automate

Best Practices for Management

• Tips for effective team management
• Leveraging Microsoft 365 for productivity

Summary and Next Steps