Microsoft 365 Copilot Training - Western Tractor
You're about to embark on a hands-on learning journey through four carefully designed activities that will help you master Microsoft 365 Copilot. Each activity is structured to give you multiple approaches to solving real-world business challenges.
Throughout these exercises, you'll work with actual Western Tractor scenarios, using realistic data and situations you might encounter in your daily work. This isn't just about learning Copilotβit's about discovering how AI can enhance your productivity and help you deliver better results for our customers.
What makes this training unique: Each activity includes multiple prompting approaches, so you can compare different methods and discover which techniques work best for different situations. You'll also explore various analysis types and learn to identify key insights that drive business decisions.
Explore a real-world decision scenario: Western Tractor faces a supply chain crisis due to US tariffs. Follow Sarah Chen, Supply Chain Manager, as she must decide whether to use Microsoft 365 Copilot to navigate the crisis.
Read Case Study βDuration: 20 minutes | Focus: Technical Documentation & Guides
Why this matters: Create clear, user-friendly technical documentation that helps customers maintain their equipment properly. You'll learn how to organize complex information in ways that are accessible and actionable.
Customer_Communication_Template_Group5.txt
This file contains all the customer information you'll need, including purchase details, contact information, and service department details. Open it before you begin and familiarize yourself with the content.
Use Word Copilot to create a one-page maintenance guide for your assigned customer. Your goal is to create a communication that feels personal, professional, and aligned with Western Tractor's brand values.
This approach involves providing Copilot with comprehensive background information upfront. By giving detailed context, you help Copilot understand the full picture and generate more accurate, relevant output.
Try this prompt:
Create a comprehensive one-page maintenance guide for [Equipment Model]. Include: first service requirements (50 hours or 3 months), regular service intervals (every 250 hours or 6 months), winter preparation checklist, spring preparation checklist, and contact information for our service department. Format it as a clear, easy-to-follow reference document.
Analysis Focus: Notice how providing detailed context upfront results in a more complete output. Compare the specificity and relevance of this approach to the others you'll try.
This method starts with a simple prompt and gradually adds detail through follow-up requests. It's useful when you're exploring ideas or when you want to see how Copilot's output evolves with additional guidance.
Step 1 - Basic Prompt:
Create a maintenance guide for a tractor.
Step 2 - Add Details: After reviewing the initial output, ask Copilot to "Make it more personal and include specific information from the customer data file."
Step 3 - Refine Format: Finally, request "Adjust the format to be more professional and easier to read."
Analysis Focus: Compare the final result with Approach 1. Which method produces better results? Consider the time investment versus output quality.
This approach provides Copilot with a clear structure to follow. It's particularly effective when you need consistent formatting or when working with established document types.
Try this prompt:
Create a maintenance guide with these sections: 1) Introduction and equipment overview, 2) First service requirements, 3) Regular maintenance schedule, 4) Seasonal preparation checklists, 5) Service department contact information. Format each section clearly with headings and bullet points.
Analysis Focus: Notice how structured prompting ensures all necessary elements are included. Compare this approach's completeness to free-form prompts.
Duration: 20 minutes | Focus: Sales Data Analysis & Trend Identification
Why this matters: Data analysis is at the heart of informed business decisions. In this activity, you'll learn how Copilot can help you quickly identify patterns, trends, and insights from sales data that would take hours to discover manually. You'll explore different analytical approaches and discover which questions yield the most actionable results.
This CSV file contains Q4 sales data with information about transactions, locations, equipment types, customer categories, and payment methods. Open it in Excel before starting your analysis.
Use Excel Copilot to analyze Q4 sales data and identify key trends for management. Your goal is to uncover insights that can inform Q1 strategy and help leadership make data-driven decisions.
This approach involves asking a series of questions to explore the data from different angles. It's like having a conversation with your data, where each answer leads to new questions.
Try these prompts in sequence:
Analysis Focus: Notice how each question builds on the previous one, revealing different aspects of the data. This exploratory approach helps you discover insights you might not have initially considered.
This method focuses on comparing different segments of your data to identify differences, similarities, and patterns. It's particularly useful for understanding performance across locations, customer types, or time periods.
Try this prompt:
Compare sales performance across all four locations. Create a summary showing: total sales by location, average transaction value, most popular equipment category per location, and payment method preferences. Highlight any significant differences or trends.
Analysis Focus: Notice how comparative analysis provides actionable insights by showing relative performance. This type of analysis helps identify best practices and areas for improvement.
This approach uses historical data to identify trends and patterns that suggest future opportunities or challenges. While Copilot can't predict the future, it can identify patterns that inform strategic planning.
Try this prompt:
Based on the Q4 sales data, what trends suggest opportunities for Q1? Identify which customer types, equipment categories, or locations show growth potential. Provide recommendations for sales strategy.
Analysis Focus: Consider how well Copilot identifies forward-looking insights from historical data. Evaluate whether the recommendations are practical and aligned with Western Tractor's business model.
Duration: 20 minutes | Focus: Action Item Management
Why this matters: Master the skill of extracting and organizing action items to improve team accountability. You'll discover how Copilot can help identify tasks, assign owners, and track deadlines from unstructured meeting discussions.
Service_Meeting_Transcript_Group5.txt
This transcript contains a realistic service department meeting discussion. Read through it to understand the context, then use Copilot to extract the information you need.
Use Teams Copilot or Word Copilot to Extract and organize action items. Your output should be clear, well-organized, and immediately useful to team members who weren't present at the meeting.
This approach creates a complete overview of the meeting, capturing all major discussion points, decisions, and outcomes. It's ideal when you need a full record of what happened.
Try this prompt:
Extract all action items from this meeting transcript. List them with owners and deadlines if mentioned. Format as a clear action items document with columns for: action item, owner, deadline, and status.
Analysis Focus: Evaluate how comprehensive the output is. Does it capture all important points? Is anything missing that should be included?
This method asks Copilot to extract specific types of information and organize it in a structured format. It's useful when you need particular details formatted consistently.
Try this prompt:
Identify and extract all action items from this meeting. For each action item, determine: who is responsible, what the deadline is (if mentioned), what the expected outcome is, and what dependencies exist. Create a prioritized list.
Analysis Focus: Notice how structured prompting ensures consistent formatting and complete extraction. Compare this to the comprehensive summaryβwhich approach better serves your needs?
This approach creates a concise, high-level overview suitable for busy managers who need key information quickly. It focuses on what matters most and why it's important.
Try this prompt:
Create a concise action items summary for management. Highlight: critical actions that need immediate attention, owners and deadlines, potential blockers, and expected impact. Format as a brief executive summary.
Analysis Focus: Compare the executive summary to the comprehensive summary. How does the level of detail differ? Which format is more appropriate for different audiences?
Duration: 10 minutes | Focus: Business Proposal Writing
Why this matters: Create a compelling business proposal that presents a clear case for investment. This activity demonstrates how Copilot can help you structure arguments, present data, and craft persuasive business communications.
This reference data may be helpful for your scenario, but feel free to be creative and think beyond what's provided. The goal is to solve the problem effectively, not to use every available resource.
Draft a proposal for a bulk equipment purchase. Think creatively about how Copilot can help you build something practical and useful for Western Tractor's operations.
Start by clearly defining what the solution needs to do. This approach ensures you build something that meets actual business needs rather than just being technically impressive.
Try this prompt:
Draft a proposal for a bulk equipment purchase. Include: equipment specifications, quantity, pricing, delivery timeline, financing options, and benefits to Western Tractor. Format as a professional business proposal.
Analysis Focus: Evaluate whether the output meets all functional requirements. Is it complete? Does it solve the problem effectively?
After creating a basic version, iterate to add enhancements that make the solution more powerful and user-friendly. This demonstrates how Copilot can help you refine and improve your work.
After creating the basic version, try:
Enhance the proposal by adding: cost-benefit analysis, risk assessment, implementation timeline, and success metrics. Make it more persuasive and complete.
Analysis Focus: Notice how iterative prompting allows you to build complexity gradually. Compare the enhanced version to the basic oneβwhat improvements were made?
This approach explores how your solution can connect with existing data sources, making it more powerful and reducing manual data entry. It demonstrates Copilot's ability to help you think about system integration.
Try this prompt:
Create a proposal that references current market pricing and competitor analysis. Include data-driven justifications for the bulk purchase.
Analysis Focus: Consider how data integration makes your solution more powerful. What additional capabilities does this approach enable? How practical are these integrations?