Microsoft Copilot Masterclass - Microsoft 365 Copilot Office

Discover how Microsoft Copilot for Microsoft 365 blends the GPT-4 based large language model with your emails, files, meetings, chats, and Office apps to boost productivity.

Explore Microsoft Copilot features that deliver personalized, private and secure responses across Word, Outlook, Teams, PowerPoint, and Excel with multimodal search, real-time monitoring, and tailored prompts.

Explore how Copilot enhances Word, Excel, PowerPoint, Outlook, and Teams with drafting, summarizing, data analysis, charts, speaking notes, and meeting summaries.

See how Copilot uses a large language model and natural language processing with Microsoft Graph and a semantic index to understand and act on your data within 365 apps.

Copilot remains in preview with weekly features, so expect bugs and timeouts. Generative ai can be wrong or biased, so keep humans in the loop and avoid outsourcing your job.

Trace the path from artificial intelligence to machine learning and deep learning, and see how generative AI uses neural networks to create text, images, and audio.

Explore how advances in neural network architecture, including transformers and generative adversarial networks, along with cheaper compute and abundant data storage, propelled generative AI into the mainstream.

Explore generative ai models, including large language models, image creation, and music generation, with ChatGPT, Midjourney, and Dall-E. Learn about style transfer, data augmentation, drug discovery, and molecular design.

Explore how generative AI boosts creativity, creates synthetic data, personalizes content, automates tasks, and supports complex problem solving across industries.

Explore the drawbacks of generative ai, including probabilistic outputs, not fully deterministic accuracy, hallucinations, training data biases, and the black box nature that enables misuse and scams.

Explore the ethical implications of generative AI, including misinformation, disclosure and liability, training data and copyright concerns, and effects on job displacement, economic inequality, and skill decay.

Explore the future of generative ai with Copilot across bigger models, multimodal inputs, and the shift from chat to actions, plus governance and regulation implications.

Explore practices for using and integrating generative AI in business, stay excited and cautious, and keep humans in the loop to move from 0 to 80% and 80 to 100%.

Learn how to set up Copilot Pro and Copilot for Microsoft 365, including licensing, account linking, and admin steps for Word, Outlook, and Teams.

Discover how to onboard Copilot Pro and Microsoft 365, verify Copilot in Word, and troubleshoot account, license, and OneDrive settings for desktop or online apps.

Copilot for Microsoft 365 requires an eligible license (E3/E5 or Business Standard/Premium), an Entra-based account, a OneDrive setup, and Office updates for Outlook and Teams, or use the web version.

Identify and access Microsoft Copilot in Word, locating the Copilot icon. Confirm Copilot appears in the web version on Microsoft365.com or office.com with Copilot Pro and complete the environment setup.

Draft with Copilot creates a Word job posting from prompts, including remote accounting associate, minimum five years experience, and QuickBooks Cloud, while inheriting document styles.

Draft a Europe expansion proposal for a coffee brand by starting with an outline, including executive summary, market analysis, product offering, marketing strategy, and free trade with ethical farming.

Edit text in Word with Microsoft Copilot and rewrite for tone. Explore casual, professional, and neutral styles, and note that Copilot currently edits only plain text paragraphs.

Convert unstructured text in Word into structured tables using Copilot, visualizing as a table to extract columns like job title, description, and salary from bullets or lists.

Discover how Copilot uses semantic search to answer questions in documents, identify markets like Italy and Germany, and enhance market analysis with prompts and chat.

Discover how Copilot revises Word documents by drafting intro paragraphs and adding sections to increase urgency, while it cannot auto-edit or insert changes directly.

Explore how Copilot in Word creates output artifacts by summarizing documents and generating concise emails, jingles, and slides with references and traceability.

Learn how to use Copilot with Excel by turning data into a table, saving files to OneDrive with AutoSave, and troubleshooting license issues to enable Copilot in Excel.

Explore general data analysis with Microsoft Copilot for Excel to generate data insights, add them to sheets, and create pivot charts, highlighting trends, outliers, and correlations.

Explore how Copilot for Excel enables data Q&A, letting managers ask detailed questions about sales, latte performance, and ratings by store and year. Reference columns for precise results.

Learn to filter data in Excel with Copilot using natural language, e.g., 'show me store A' or 'year 2018,' and apply multi-column filters via OneDrive AutoSave.

Combine data filtering with data analytics in Excel using Copilot to identify the year with the highest total sales for a store, verified via a pivot table.

Apply Copilot to format data in Excel by highlighting and bolding the rating column, applying green, yellow, red conditional formatting, and note you can format only the column, not rows.

Explore how Copilot can automatically create and fill new columns in a dataset using context and formulas, including profit, profit percentage, rating band, and scenario analysis.

Explore how to sort data with Microsoft Copilot and Excel, including single-column and multi-column sorts by store, coffee product, and year in ascending or descending order.

Create data visualizations in Excel with Copilot, producing bar, pie, and line charts, using exact aggregations (total, average, max, min) and filters like year.

Discover how general Copilot for Microsoft 365 interprets Excel formulas, explains the due date logic from invoice amount, and generates sample data and new formulas.

Explore how to use generative AI and Excel together with ChatGPT in an optional submodule to create data, understand formulas, and generate complex formulas beyond Excel Copilot.

Learn how to use ChatGPT as an Excel formula advisor to generate simple formulas for sum and average, enabling quick calculations from data ranges like B2:B13.

Discover how to generate Excel revenue lookup formulas with index match or vlookup using ChatGPT prompts, and how context and prompts yield correct results for any year and month.

Explore how ChatGPT assists with string manipulation formulas in Excel, including splitting names, reformatting dates, rounding to the nearest Sunday, and extracting email domains.

Extract the email domain from the email column with a formula, drag down results, and use string manipulation formulas 2 with ChatGPT guidance while exercising due diligence.

Learn how ChatGPT can generate and combine Excel formulas for mortgage calculations, including monthly payments, total payments, and total interest, while handling signs and building on prior results.

Explore how to fuse physics concepts with Excel formulas to build a physics calculator that computes fall time from initial velocity and height using a ChatGPT-assisted approach.

Learn to generate fake sample data in Excel with ChatGPT-3.5, creating a table of records, refining emails and area codes, and tailoring data to simulate real-world patterns.

Learn to create custom formatted cell types in Excel with ChatGPT, displaying numbers in millions with a dollar sign, thousands separators, red negatives in brackets, and no decimals.

Explain how ChatGPT clarifies complex Excel formulas, including nested IF statements and EDATE logic, to determine invoice due dates and enable easy formula editing.

Learn to create pivot tables in Excel with ChatGPT guidance, including setting the data range, arranging months as rows, years as columns, and aggregating sales.

Analyze data from Excel with ChatGPT to write formulas, create pivot tables, and answer questions like highest year-over-year sales increase or decrease, and advise on store closures.

Learn to enable and write macros in Excel using VBA, access the Developer tab, and automate complex, repeatable tasks with macros and ChatGPT guidance.

Create an Excel macro with ChatGPT to highlight cells over 1,000 in yellow, bold, and underlined, then extend to 2,000 with red while comparing to conditional formatting.

Create an Excel macro with ChatGPT to list customers with revenue over $2,000 into a VIP Customers sheet, copying headers from sheet 1 and removing blank rows.

Ensure Copilot is active in PowerPoint and reference the Word files stored in OneDrive. Update your license and PowerPoint, and use the online version at microsoft365.com if needed.

Create a deck from scratch using Copilot and PowerPoint, generating text, images, and speaking notes from prompts, with Designer layout tweaks for different slides.

Create a presentation from a corporate template using Copilot to enforce branding. Choose a minimal template and let Copilot populate slides while preserving formatting.

Learn how to add slides with Copilot Pro, prompt effectively, and tailor content with your own points on Europe’s coffee market dynamics and European consumer regulation.

Learn how to use Copilot to edit PowerPoint slides, add or remove bullet points, insert relevant images, and adjust text length and formatting for concise or detailed slides.

Explore how Copilot reads PowerPoint decks to answer questions, extract dates and references, and generate targeted takeaways, improvements, and slide insights for executive proposals.

Learn to summarize each slide and organize large decks with Copilot, generating slide-level summaries, creating sections with header slides, and improving quick navigation of your presentation.

Explore integrating Copilot with Outlook and verify setup in the web version, using draft with Copilot and coaching by Copilot, and understand admin enablement and environment setup.

Draft emails with Copilot in Outlook by turning quick notes into professional messages, choosing tone and length, and regenerating drafts as needed. Explore tone options, length, and draft regeneration.

Outlook with Copilot summarizes long email threads to deliver a concise overview at the top. Skip references, since Copilot here doesn't include them; switch to Microsoft 365 chat.

Leverage Copilot in Outlook to draft and reply to emails with context from the thread, choosing formal or casual tones and generating concise responses to save time.

Learn to draft formal email replies with Copilot, including executive summaries and long-message responses that address growth opportunities in Europe, product adaptation, and cultural events for a coffee line.

Use Copilot coaching in Outlook to analyze your drafted email and thread. Receive guidance to improve formality, tone, and detail, with suggestions like expressing gratitude, using bullet points for emails.

Learn how to enable and use Copilot for Teams, verify licenses, add M365 Chat, and configure meeting options and transcription settings in the admin center.

Learn to use Copilot in Microsoft Teams to summarize chats, extract highlights and key takeaways, identify approvals and actions, and generate structured tables for planning and follow-ups.

Catch up in meetings with Teams and Copilot Pro by recapping live transcripts, asking targeted questions, and generating structured notes and tables of pros and cons.

Learn to leverage Copilot in meetings to ask targeted questions, reference participants by name, and pull exact numbers and dates from transcripts using Microsoft 365 Chat in Teams.

Use Copilot during meetings to coach your participation by identifying holes in arguments, proposing smart follow-up questions, and guiding the discussion to move the meeting forward.