Microsoft 365 Copilot Masterclass: Copilot Crash Course

Learn text classification with Copilot, classifying text as positive, negative, or neutral, and explore tagging data, chat memory, tables, and exporting results to Excel.

Demonstrate basic prompting techniques with Copilot to solve a math SAT question, enhance readability with LaTeX, and show how to request raw LaTeX and code blocks.

Master prompt engineering by crafting specific prompts to boost AI creativity and accuracy, avoid garbage in, garbage out, and guard against biases through human review; explore its productivity gains.

Master advanced prompting by establishing a clear AI identity, defining a clear task, providing context, specifying output style, and iterating with Copilot.

Create a clear AI identity and define tasks with action verbs to tailor Copilot responses. Use roles like a professor to elicit precise, high-quality outputs.

Practice building advanced prompts to craft a Seinfeld plotline in a 15-minute assignment, using prompting principles such as identity, defining the task, providing context, specifying output, and tone and style.

Explore the assignment solution for building advanced Copilot prompts by crafting a Kramer-centered Seinfeld plotline with identity, task definition, context, and tone, guiding it through exposition to resolution.

Apply Hamilton Helmer’s seven powers framework to analyze a company with Copilot for Word, using strong prompt engineering and a concise executive summary, illustrated by Nintendo.

Create a presentation from scratch in PowerPoint using Copilot, covering the price-to-earnings ratio with per-share and market-cap based calculations, plus sample slides and speaker notes.

learn how to craft a startup pitch deck using Copilot in PowerPoint, applying prompt engineering to outline the problem, product, tam, business model, team, and financials for investors.

Discover how the coaching feature in Copilot improves professional emails by optimizing tone, reader sentiment, and clarity. See practical edits that add empathy, concise language, and direct contact options.

Learn to draft a personalized Outlook outbound email with Copilot, including prompts, prospect details, and a concise one-week free trial call to action.

Leverage Copilot to streamline your workflow inside Outlook, and apply this section's techniques to boost productivity.

Learn to use Copilot in Excel with the start-XL-copilot file. Enable autosave and format data as a table to activate Copilot analysis of store locations, guests, revenue, and costs.

Learn to use Copilot in Excel to add a profit column (revenue minus costs) and build pivot tables to identify top stores by profit and profit per guest.

Use Copilot to describe dataset's fields, compute total and average production by country, and visualize trends with a pivot chart and a line chart highlighting Brazil as the highest producer.

Use Copilot for Excel to analyze digital marketing data, computing max, min, and average CPC, and assess trend and correlation between clicks and CPC with scatter plots and regression lines.

Explore the lesser known uses of Copilot in this catch-all section, uncovering practical use cases that deserve a spot in the course.

Explore how to use the edge browser copilot sidebar to query a chemotherapy guide, switch between gpt four and gpt four turbo, and pull page-specific citations for precise, document-based answers.

Discover how to use copilot across various 365 applications with practical usage options, and prepare for the next lecture.

Learn to use Microsoft Copilot for Microsoft 365, available to business or educational accounts. Leverage Copilot's capabilities across your enterprise or organizational data.

Query your 365 data inside Microsoft Copilot for 365 to surface files, emails, Teams messages, and meetings; generate searchable tables, snippets, and recaps for fast insights.

Learn how to use Microsoft Copilot for 365 in Teams meetings by enabling transcription and recording, making meeting data searchable in Copilot for summaries and insights.

Clean a grocery store sales ledger by removing blank rows, imputing dates, deleting items, and computing sales amounts as quantity times price in a code interpreter workflow.

Feed a panorama image into the code interpreter to create an mp4 video that pans from the right to the left in a 9:16 mobile format, with eight-pixel frame step.