Microsoft 365 Copilot Masterclass: Copilot Crash Course

Master the building blocks of prompting, including zero-shot prompts. Learn text insertion, question and answer, classification, summarization, conversation, reasoning, and translation, and how combining them enables advanced prompts.

Learn text insertion with copilot by using brackets to insert words at a point, then tailor outputs to a single word, and identify onomatopoeia like hiccup and sizzle.

Explore question and answer prompting with Copilot, practice asking questions, refining outputs with markdown tables and export to Excel options for clean, searchable results.

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

Learn information extraction with Copilot by extracting specific details from text, such as rivers or bodies of water, and format outputs as bullets or other structures.

Learn the text summarization technique using a large language model to condense long articles for LMS workflows, illustrated by a real-world airline turbulence incident.

Explore Copilot reasoning on solving novel problems, from simple math to age problems, and explain why zero-shot prompts struggle while few-shot prompting improves results later in the course.

Learn how Microsoft 365 Copilot translates text across languages, adjusts tone—from casual to professional—and even explores playful styles like a high-seas pirate voice.

Explore basic prompting techniques with Copilot through practical assignments on this course. Learn how to use prompts, instructions, and feedback across LMS tasks, instructor examples, and solution walkthroughs.

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.

Build on basic prompting techniques and prepare to tackle more complex tasks through prompting in the next section, celebrating your progress and readiness for advanced tasks.

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.

Learn to provide context and specify output tone and structure in Copilot prompts, including audience background, quoted material, section outlines, and length and style requirements.

Learn how non-deterministic learning management systems, like Copilot, use probabilistic processes and context history; master iterative prompting to clarify intentions and align responses with expectations.

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.

Develop your skills as a prompt engineer for Microsoft 365 Copilot by crafting increasingly complex prompts to tackle advanced tasks with large language models.

Explore how Copilot in Microsoft Word enhances word processing workflows, enabling you to streamline tasks and boost productivity within the Word environment.

Explore the three types of Copilot—free, Pro, and Copilot for Microsoft 365—and how home versus business subscriptions determine access, licensing, and pricing for Microsoft 365.

Demonstrate using the Word Copilot sidebar to summarize, examine, and extract information from a document; interact by asking questions, with GPT-4 but no browsing, and citations link to sources.

Analyze how a favorite company uses Hamilton Helmer's seven powers—scale economies, network economies, counter positioning, switching costs, branding, and resource and process power—for long-term success.

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.

Master using Copilot inside Microsoft Word to enhance writing tasks and boost productivity, building on your progress in this section.

Leverage Copilot to design, enhance, and automate PowerPoint workflows, improving efficiency across your presentations and accelerating collaboration.

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 to use Copilot with PowerPoint to turn a pre-existing outline, including debates like hot dog is a taco, into a precise, detailed presentation via structured prompts.

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.

Analyze the assignment solution for Nutrify Wellness, a personalized health and coaching platform, using Copilot for PowerPoint and prompt engineering. Review TAM calculations, pricing, and prompts to improve investor pitches.

Learn how to use Copilot in PowerPoint to automate workflows with AI, boosting productivity and efficiency. See how to apply Copilot to enhance presentations with practical steps.

Learn to leverage Copilot inside Microsoft Outlook to assist with writing, editing, training, and summarizing emails.

Demonstrates drafting emails in Outlook with Copilot, choosing tone and length, refining prompts, and applying generated drafts to new messages and replies.

Learn how Copilot in Microsoft Outlook summarizes an email thread, generates concise recaps with citations to the original messages, and guides troubleshooting for software installation.

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.

Draft a concise, personalized outbound email in Outlook using Copilot, detailing Flexi Disc's on-demand workspaces and a one-week free-trial call to action from Salt Lake City offices.

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

Learn to use Copilot inside Microsoft Excel to conduct data analysis with llms, unlocking productivity during the ai wave.

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 IMDb data set with Copilot in Excel, answer questions on director revenue, average revenue, genres by Spielberg and Cameron, and create pivot charts to visualize revenue and ratings.

Use Excel with Copilot to turn data into a table, enable autosave on OneDrive, and build pivot tables to identify the director with the greatest revenue.

Delve into data analysis with generative ai and llms in copilot, highlighting growth potential and the cutting edge of ongoing updates.

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.

Use the desktop Copilot sidebar to capture a screenshot and convert it into a table in Excel. Export the data to a web-based Excel file for download.

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.

Discover how Microsoft Copilot for 365 extends Copilot Pro for business and educational users, via Microsoft Graph's semantic index that searches enterprise data including Teams and Project with user permissions.

Explore the Microsoft 365 Copilot interface, including the chat button and Copilot chats, and learn to query enterprise data—people, files, meetings, and emails—with secure access and privacy controls.

Understand how Microsoft semantic index and graph power Copilot by grounding prompts, checking permissions, and securely injecting enterprise data into the LLM, followed by safety review and delivery.

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.

Discover how to use Microsoft Copilot in Teams, navigate the main interface, rewrite and adjust prompts, and query chats with a Copilot sidebar for project updates like Lambda concerns.

Harness Copilot's knowledge graph to query PowerPoint and Word, creating executive-style presentations from enterprise documents like the AWS Lambda one-pager, outlining budget, benefits, and strategic fit.

Share one of your favorite Copilot applications to show how Copilot improves workflows and boosts efficiency.

Celebrate the prompts you submitted and share them to improve how we use ai tools. Thank you for your work, and see you in the next lecture.

Explore the ChatGPT interface across browser and apps. Learn to start chats, attach files, switch models like GPT-4, and manage memory, custom instructions, and data controls.

Learn how to enable the ChatGPT code interpreter, run Python code to generate and analyze data, view the execution code, and download results as CSV.

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.

Visualize quarterly US housing prices from 1970 to 2024 with a line chart, explore moving averages and residuals to assess prediction accuracy, highlighting 2008–09 and Covid dips.

Perform exploratory data analysis on a climbing product dataset to identify top products and brands by monthly search volume, highlighting non-brand keywords.

Apply linear programming to a two-product production problem with decision variables, an objective to maximize revenue, and resource constraints on labor, material, and logos.

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.

Learn to run regression analysis with code interpreter, compute the correlation coefficient and regression line, and plot the scatter with the line of best fit on height and weight data.