Microsoft Copilot Bootcamp - Microsoft 365 Copilot Training

Use Copilot to clean Excel data by removing banded rows, standardizing region text with proper case and trim, formatting numbers in columns I to L, and removing duplicates.

Use Copilot in Excel to add formula columns, extract invoice month in MMM format, and perform XLOOKUP against the TPL lookup table to compute profit (total sales minus COGS).

Learn to use Excel Copilot with conditional formatting to highlight sales over $30,000, bold rows where profit falls below $25,000, and add data bars while managing or editing rules.

Learn to organize large Excel datasets with Copilot, sorting by retailer A to Z and profit high to low, filtering by state and date ranges, then clearing filters for clarity.

Turn data into actionable insights using Copilot to build pivot tables and pivot charts, create dashboards, and visualize mega sales data in Excel.

Use Copilot to turn raw data into professional, readable spreadsheets. Apply header bolding, font size, auto-fit columns, borders, color highlights, and currency formatting for clear financial data.

Practice excel copilot skills by cleaning c to case, removing spaces, and mapping column i to days lookup; create total sales with 12% tax, orange bars, and sort by sales.

Use Copilot to clean text data, generate and rename columns, perform day lookups, compute total sales with tax, add orange data bars, and sort by total sales.

Use PowerPoint copilot to create engaging, professionally designed presentations quickly, even without design experience. Leverage auto-generated slides, speaker notes, and designer layouts to customize and elevate your content.

Enhance your PowerPoint with Copilot to add content, reorganize slides, and summarize key points. Organize slides into sections, generate an agenda, and explore design recommendations using simple prompts.

Turn a Word document or PDF into a polished PowerPoint presentation with Copilot, converting content and images into 18 slides with outlines, notes, and customizable layouts.

Craft slides with your company template in Copilot to stay on brand. Generate a complete presentation on Future of Food, then fine-tune images and layouts while preserving brand guidelines.

Open branded template, build PowerPoint presentation with Copilot using content from sales pitch meditation app file, organize two sections, refine visuals with designer tool, create summary slide.

Use Copilot to create a branded PowerPoint from a file, then organize slides and apply the company template with designer options, finishing with the summarize this presentation option.

Use Copilot in Word to draft well-structured documents with the right tone, auto formatting, and quick first drafts, illustrated by creating a New York travel guide.

Explore using Copilot in Word to edit, rewrite, and format documents with auto rewrite and three version choices, and use Inspire Me ideas and text-to-table conversion for polished, professional results.

Discover how Word Copilot summarizes long documents and finds exact information. Use the document summary feature to generate clear briefs from PDFs or Word files, then ask questions when needed.

Practice word Copilot skills by creating Market Insight newsletter, list recent developments, then use Auto Rewrite feature to expand conclusions and format developments into a table.

Use Copilot in Word to create a Market Insight newsletter. Generate content, set a casual tone, rewrite the conclusion, and visualize Recent Developments as a table.

Switch to the new Outlook to access Copilot features, locate Summary by Copilot for emails, draft and coaching options, and toggle between Classic View and Simplified View for efficient productivity.

Learn to transform thoughts into well crafted emails with Outlook Copilot, choosing the perfect tone and concise messages through drafts, prompts, and personalized sign-offs.

Learn how Outlook Copilot coaching analyzes tone, reader sentiment, and clarity to improve emails, apply suggestions to drafts, and craft clearer, more empathetic messages.

Learn to summarize emails with Outlook Copilot and craft replies quickly. Use Summary by Copilot to extract main points and select draft options like define project roadmap.

Discover how Copilot helps organize your inbox by creating inbox rules to move and flag messages to a subfolder, and to set a professional out-of-office reply.

Learn how Copilot turns email and file searches in outlook into an effortless, natural-language experience, locating attachments across inbox and subfolders and guiding you with direct email links.

Use Outlook Copilot to handle a customer complaint by emailing the prepared template, summarizing the letter, and drafting a formal, medium-length response, then review it with Copilot coaching for clarity.

Summarize lengthy emails, draft formal responses, and coach tone, reader sentiment, and clarity with Microsoft 365 Copilot for efficient customer communication.

Learn how Microsoft Teams Copilot streamlines chats, channels, meetings, notes, and documents, with prompts to summarize emails and files and design training agendas.

Explore how Copilot analyzes long chat content in Teams to summarize conversations, extract main points, and identify decisions, while guiding tone adjustments to professional messages.

Learn how Copilot automatically creates file summaries in Teams channels to enhance meeting preparation by sharing documents with a detailed overview before opening.

Enable transcription to let Copilot process in-meeting conversations, generate meeting notes, action items, and highlights, and use recap meetings so far for quick summaries after five minutes.

Discover how Copilot in OneNote transforms note taking by organizing content, generating summaries, improving writing, and creating agendas, project outlines, task lists, and even recipes.

Explore how Copilot in OneNote helps create a beginner Microsoft Excel course outline, then copy the output with Ctrl+V into your page.

Explore how Copilot in OneNote enhances notes by summarizing, rewriting, and generating concise content; syncs across platforms via OneDrive, and supports prompts, task lists, and copy-paste workflows.

Explore how to use Microsoft Whiteboard with Copilot to brainstorm and organize ideas in real time, share boards, and collaborate in Microsoft Teams meetings within Microsoft 365.

Share a Microsoft Whiteboard in a Teams meeting and use Copilot to generate a social media marketing plan, then insert and customize ideas on the canvas.

Discover how Copilot enhances whiteboard collaboration by automatically categorizing notes into topic groups, summarizing with loop components, and sharing organized ideas across teams.

Explore how Microsoft Loop acts as a central hub for real-time collaboration across Word documents, Excel spreadsheets, Outlook emails, and Teams, powered by Copilot to boost productivity.

Create and customize a summer party invitation using Copilot inside a multi-page workspace, drafting, revising, and versioning content for a 300-person event at Babylon Roof Gardens.

Create a task management loop component with columns task, team, and team member using Copilot, then share it via Outlook emails with real-time synchronization across Microsoft 365 apps.

Learn to use Copilot in Loop to summarize page content and extract specific ideas, like party themes, boosting real-time collaboration and teamwork across Microsoft 365 apps.

Master prompt engineering and practice regularly to maximize Copilot across Microsoft apps, staying updated on its rapid evolution. Celebrate your progress as you leverage Copilot to boost productivity.