By the end of this course, you will be able to
Understand the artificial intelligence technologies embedded in Microsoft Office applications and how they can be used to improve processes and business tasks.
Develop the ability to use AI features and features in Word, Excel, Outlook, and PowerPoint in a skillful way to simplify tasks, reduce manual effort, and improve accuracy.
Gain complex data analysis skills using AI tools in Excel, enabling predictive analytics, trend forecasting, and data-driven decision-making.
Understand how to create, edit, and format documents with the help of artificial intelligence in Word, to achieve maximum efficiency in preparing reports, memos, and correspondence.
Course details
- 1 h 42 m/39 lessons
- Last updated: 26/5/2024
- 17 learning resources
- Course completion certificate
Course Content
Draft a new E-MAIL with copilot
What is a prompt
Copilot for calculated columns
Course introduction
Prompt engineering
Basic definitions - intro to ai technology
What is a prompt
Microsoft copilot chatbot - writing a blog post idea
Chat gpt chatbot - draft a professional email
Ai as a grammar correction tool
Ai as a document summarize tool
Ai for organize unstructured data
Ai for extracting document keywords
Ai for code explaining
Ai as a professional translator
MS WORD COPILOT - INTRO
Draft a new document with COPILOT
Rewrite a text and change the text tone with copilot
Chat with copilot - summarize, ask and extract document keywords
MS DESIGNER FULL PROJECT
Insert HQ picture, cutout people and stickers in the document
View prompts panel, document quality checker and ms word designer
Translate a document and AI dictation
MS POWERPOINT COPILOT - SECTION INTRODUCTION
Create a new presentation
Summarize a presentation - show slide notes
Create a presentation from file - organize a presentation into sections
PowerPoint designer tool
MS OUTLOOK COPILOT - SECTION INTRODUCTION
Draft a new E-MAIL with copilot
Summarize an E-MAIL
Generate Professional E-mail Respond
E-MAIL COACHING
MS EXCEL COPILOT - SECTION INTRODUCTION
Number formatting by copilot
Combine 2 column - add formula column - hide columns by copilot
Copilot for calculated columns
Copilot for conditional formatting
Sort and filter by copilot
AI analyzing data
Dataset AI summarize
Course conclusion
About this course
In the business world, reliance on data and focus on automation are prevalent. Thus, integrating artificial intelligence into daily tools has become a necessity, not just an option. This is why Microsoft Office has incorporated advanced AI features that can transform the way we handle tasks, from simple document editing to complex data analytics. In this course, you will learn about Microsoft Copilot's capabilities in Word, Excel, Outlook, and PowerPoint. The curriculum includes using AI for efficient email writing with ChatGPT, blogging, correcting translation errors, and automating routine tasks. Additional topics cover AI’s impact on text summarization, data analysis, creating impactful presentations, and extracting keywords. Skills in interpreting programming codes and professional translation with advanced AI tools will also be developed. Join this course to leverage Microsoft’s smart tools for business enhancement.
Course requirements and prerequisites
This course requires prior knowledge of using the Office programs WORD, EXCEL, POWERPOINT, OUTLOOK.
Mentor
Abdelrahman Hashem
Organizational Skills Trainer
16,012 Learners
8 Courses