Microsoft 365 Copilot - Unlocking Productivity with Copilot and Office

Microsoft 365 Copilot - Unlocking Productivity with Copilot and Office

by HHN Automate Book Inc.
Released May 2024
Publisher(s): Packt Publishing
ISBN: 9781836203933

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

In this comprehensive course, you will embark on a journey to master Microsoft 365 Copilot, an innovative AI-driven assistant designed to streamline your workflow across various Office applications. The course begins with an introduction to Copilot, explaining its different versions and providing an overview of what you can expect to learn.

The course delves into the fundamentals of Microsoft Copilot, offering detailed insights into its features and capabilities. You will explore how Copilot works and discover practical applications for this powerful tool. Additionally, an optional primer on Generative AI provides a deeper understanding of the technology behind Copilot, including its benefits, drawbacks, and ethical implications. By the end of this section, you will have a solid foundation to harness Copilot's full potential.

Hands-on tutorials cover the integration of Microsoft Copilot with Word, Excel, PowerPoint, Outlook, and Teams. You will learn to draft and edit documents, create complex spreadsheets, design impactful presentations, and manage emails and meetings efficiently. Each section offers practical examples and step-by-step instructions to ensure you gain real-world skills. Whether you're enhancing your Word documents or analyzing data in Excel, this course provides the tools you need to succeed.

What you will learn

  • Utilize Microsoft 365 Copilot to streamline document creation and editing in Word
  • Analyze data and create complex spreadsheets in Excel with Copilot
  • Design impactful presentations in PowerPoint using Copilot
  • Manage emails and meetings efficiently with Outlook and Teams integrations
  • Enhance collaboration and productivity with Microsoft 365 Chat features
  • Understand the principles and applications of Generative AI

Audience

This course is for working professionals and office workers who want to get things done faster with Generative AI. This is also for individuals passionate about technology, including and especially those with non-technical backgrounds, seeking to explore Generative AI. This is especially useful for those who use Microsoft Office (Word, Excel, PowerPoint, Outlook, Teams) as part of their job.

About the Author

HHN Automate Book Inc.: Henry Habib is a seasoned manager at a leading management consulting firm. He leverages his expertise to provide counsel on growth strategy, operation, and analytics to Fortune 500 companies. With a strong background in implementing data-driven solutions, Henry has a proven track record of making an impact in organizations of all sizes. He strongly advocates for no-code application development in business and deploys such solutions for his clients. These solutions are not only easier to understand but also quicker to implement. In addition to his consulting work, Henry is a dedicated professor who takes pleasure in guiding students toward success in various fields, ranging from case interviews to no-code application development and automation. His courses are designed to be engaging and informative, and he is always available to assist students in mastering challenging concepts.

Table of contents

  1. Chapter 1 : Introduction
    1. Different Versions of Copilot
    2. What is this Course?
    3. Course Roadmap
    4. Instructor Overview
    5. Keys to Success
    6. Leave a Rating
  2. Chapter 2 : Fundamentals
    1. What is Microsoft Copilot Pro?
    2. Features of Microsoft Copilot
    3. What You Can Do with Microsoft Copilot
    4. How Microsoft Copilot Works
    5. Quick Note on Microsoft Copilot
  3. Chapter 3 : Generative AI Primer (Optional)
    1. What is Generative AI?
    2. Why Did Generative AI Get So Popular Now?
    3. Different Generative AI Models
    4. Benefits of Generative AI
    5. Drawbacks of Generative AI
    6. Ethical Implications of Generative AI
    7. Future of Generative AI
    8. Best Practices and Conclusion
  4. Chapter 4 : Environment Setup
    1. Get Microsoft Copilot Pro and Microsoft Copilot for M365
    2. Onboard Microsoft Copilot Pro and Microsoft 365 on Your Apps
    3. Pre-requisites of Microsoft Copilot
  5. Chapter 5 : Microsoft Copilot and Word
    1. Fundamentals of Microsoft Copilot and Word
    2. Draft Documents with Microsoft Copilot Pro
    3. Draft Documents with Outlines with Microsoft Copilot
    4. Edit Text in Word and Change Tone with Microsoft Copilot
    5. Transform Text in Word into a Table
    6. Ask Questions on Word Documents
    7. Revise Edits to Your Word Documents
    8. Create Output Artifacts with Microsoft Copilot
  6. Chapter 6 : Microsoft Copilot and Excel
    1. Fundamentals of Microsoft Copilot and Excel
    2. Insights Analysis and Charts with Microsoft Copilot Pro
    3. Sort, Highlight, and Filter with Microsoft Copilot for Microsoft 365
    4. Adding Formulas in Excel
    5. ChatGPT and Excel Introduction
  7. Chapter 7 : ChatGPT and Excel (Optional)
    1. Simple Formulas (Sum and Average)
    2. Simple Formulas (Index Match)
    3. String Manipulation Formulas 1
    4. String Manipulation Formulas 2
    5. Implied Formulas - Mortgage Example
    6. Implied Formulas - Physics Example
    7. Sample Data Generator
    8. Custom Formatted Cell Types
    9. Formula Explainer
    10. Pivot Tables
    11. Analyze Data from Excel
    12. Enables Macros in Excel
    13. Create Simple Formatting Macro with ChatGPT
    14. Create Complex Macro with ChatGPT
  8. Chapter 8 : Microsoft Copilot and PowerPoint
    1. Fundamentals of Microsoft Copilot and PowerPoint
    2. Create Presentations from Scratch with Microsoft Copilot Pro
    3. Create Presentations from Templates
    4. Create Presentations from Word Documents
    5. Add a Slide with Microsoft Copilot Pro
    6. Edit a Slide in PowerPoint
    7. Ask Questions about Presentations
    8. Summarize and Organize Presentations with Microsoft Copilot
  9. Chapter 9 : Microsoft Copilot and Outlook
    1. Fundamentals of Microsoft Copilot and Outlook
    2. Draft Emails with Microsoft Copilot for Microsoft 365
    3. Summarize Email Threads in Outlook
    4. Reply to Emails in Outlook and Microsoft Copilot 1
    5. Reply to Emails in Outlook and Microsoft Copilot 2
    6. Use Email Coaching in Outlook
  10. Chapter 10 : Microsoft Copilot and Teams
    1. Fundamentals of Microsoft Copilot and Teams
    2. Summarize and Ask Questions During Teams Meetings
    3. Catch Up During Meetings with Teams and Microsoft Copilot Pro
    4. Ask Questions During Meetings
    5. Get Meeting Coaching with Microsoft Copilot for Microsoft 365
  11. Chapter 11 : Microsoft Copilot 365 Chat
    1. Fundamentals of Microsoft Copilot 365 Chat
    2. Ask Work-Related Questions and Produce Work Material 1
    3. Ask Work-Related Questions and Produce Work Material 2
    4. Reference Files in M365 Chat
    5. Search the Web with Copilot for Work
  12. Chapter 12 : Conclusion
    1. Conclusion and Next Steps
  13. Chapter 13 : Bonus
    1. Bonus

Product information

  • Title: Microsoft 365 Copilot - Unlocking Productivity with Copilot and Office
  • Author(s): HHN Automate Book Inc.
  • Release date: May 2024
  • Publisher(s): Packt Publishing
  • ISBN: 9781836203933