MMCT Training • 45 minutes

Microsoft Copilot for MMCT Staff

A practical class for finding information, drafting reports, analyzing spreadsheets, and keeping human judgment in control.

DemosExercisesReusable promptsVerification habits
Get class materials Start the workflow
Abstract professional illustration of staff using AI tools with documents, dashboards, and port operations motifs.

Class map

What we’ll cover in 45 minutes

0–5What Copilot is
5–12Better prompts
12–22Find information
22–32Draft reports
32–42Spreadsheets
42–45Guardrails

Outcomes

Staff leave with usable habits, not theory

Find faster

Locate and summarize work information with source checks

Draft better

Turn notes and data into report drafts and staff updates

Analyze tables

Ask stronger spreadsheet questions and create useful summaries

Stay safe

Verify facts, protect data, and keep human judgment in control

Prompting formula

Use G‑C‑S‑E for cleaner answers

Strong prompts tell Copilot the goal, context, sources, and expectations before it starts drafting.

G

Goal

What do you want?

C

Context

Who is it for and why?

S

Source

What files/data should it use?

E

Expectations

Format, tone, length, citations

Abstract source-grounded search illustration with documents and evidence pathways, no text.

Information finding

Ask for sources, then inspect the evidence

Ask

Name topic, source range, and desired output

Inspect

Open cited files and check dates

Challenge

Ask what is missing, conflicting, or uncertain

Use

Turn the verified answer into action

Prompt patterns

Latest status

Summarize the latest on [topic] from the last 30 days.

Compare docs

What changed between Draft A and Current Procedure?

Timeline

Create a timeline from emails and meeting notes since [date].

Action list

List decisions, owners, due dates, and unresolved questions.

Hands-on 1

Source-grounded answer

  1. Use a recent non-sensitive file or meeting recap
  2. Ask for a 5-bullet summary with sources
  3. Follow up: “What evidence supports bullet 2?”
  4. Identify one thing Copilot missed or overstated
Abstract report drafting illustration showing notes becoming a polished briefing, no text.

Reports

Turn notes and data into a report draft

Gather

Notes, spreadsheet, template, audience

Draft

Executive summary + sections

Refine

Tone, length, tables, recommendations

Verify

Numbers, dates, names, policy claims

Example report prompt

Using only the attached notes and spreadsheet, create a concise MMCT weekly operations summary with accomplishments, volume trends, bottlenecks, client/service impacts, recommended actions, and a “Needs verification” section.

  • Executive summary
  • Key metrics
  • Trends and bottlenecks
  • Risks / impacts
  • Recommended actions
  • Needs verification
Abstract spreadsheet and dashboard analysis illustration with chart shapes, no readable numbers.

Excel + data

Ask better questions of spreadsheets

Top categories

Counts by category

Resolution time

Average + outliers

Overdue items

Status + priority

Data quality

Missing values, duplicates, inconsistent formats

Useful spreadsheet prompts

Summarize

Explain this table for a non-technical manager.

Clean

Find missing values, duplicates, and outliers.

Calculate

Create formulas for SLA status and days open.

Visualize

Recommend the best charts and why.

Hands-on 2

Spreadsheet insight

  1. Open MMCT_Service_Requests_Sample.csv in Excel
  2. Format the data as a table
  3. Ask for trends, outliers, and chart ideas
  4. Create one chart or summary table
  5. Write a 3-sentence management takeaway and verify numbers

Guardrails

Copilot speeds the work. Staff own the judgment.

Quality-control checklist

  • Correct sources
  • Verified numbers, dates, and names
  • No unsupported claims
  • Professional tone
  • Privacy appropriate
  • Actionable next steps

Safe-use rules

  • GREEN: Use work account, approved files, and human review
  • CAUTION: Review sources, permissions, assumptions, and missing data
  • STOP: Do not paste sensitive info unless policy allows. Do not use AI as final authority for legal, HR, financial, or policy decisions.

Common mistakes

  • Vague prompts
  • No source named
  • Too many tasks at once
  • Accepting numbers without checking
  • Ignoring permissions/privacy
  • Copy/paste without review

Reusable workflow

The five-step pattern

1

Define deliverable

2

Gather sources

3

Prompt with G-C-S-E

4

Iterate format and evidence

5

Verify and finalize

Practice plan

One week of small reps

Day 1Summarize a meeting
Day 2Rewrite a long email
Day 3Compare two documents
Day 4Analyze a table
Day 5Draft and verify a report

What good looks like

  • Faster first drafts without lower standards
  • Clearer summaries with source trails
  • Better spreadsheet questions from non-analysts
  • Consistent reports and professional communications
  • Staff who know when to trust, verify, escalate, or stop

Microsoft 365 touchpoints

Where Copilot shows up

Chat

Q&A and source-grounded summaries

Word

Drafts, rewrites, outlines

Excel

Tables, trends, formulas, charts

PowerPoint

Draft decks from files or outlines

Outlook

Thread summaries and reply drafts

Teams

Meeting recaps and action items

Class materials

Download the training package

PowerPoint deckFull 45-minute class deck Facilitator guideTiming, notes, and success criteria Participant handoutReference notes for attendees Prompt cheat sheetReusable patterns and reminders Sample CSVPractice spreadsheet for Excel demo

Source basis

Research sources used for the class