Public Sector
Level Up Your Tech Skills
Make your workday easier with Microsoft 365 training tips suited to your role.
At Microsoft, we’re committed to empowering public sector workers with digital skills to drive government operations and enhance services, while supporting career development. Display our tutorials by role or task:
Administrative officer
Discover how Sara makes routine administrative tasks easier while staying organised and efficient.
Morning
Sara starts by reviewing her inbox, using Microsoft 365 Copilot in Outlook to quickly . To stay organised, she to move emails on which she’s copied to a separate folder for later review.
She then in Outlook to discuss a supplies contract.
Summarise emails
Quickly get an overview of your inbox, focusing on key items.
Create an Outlook Rule
Organise your inbox by automatically sorting copied (Cc’d) emails.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
Afternoon
Sara tackles her team budget. She uses Microsoft Excel to of forecasted spending and then to visualise the data.
Later, she prepares for a meeting by asking Microsoft 365 Copilot in PowerPoint to based on internal reports, complete with speaker notes and images.
Create a table
Organise your data in a clear, structured table.
Create a chart
Visualise your data in an easy-to-understand chart.
Generate a presentation
Quickly build a deck from existing content.
End of the week
Sara reviews a lengthy report, using Microsoft 365 Copilot in Word to . After finessing the tone and checking for accuracy, she uses Microsoft 365 Copilot in Outlook to to accompany the report.
Finally, she in Outlook so she can share the budget update monthly.
Summarise a document
Create a quick summary of a lengthy report.
Draft or rewrite an email
Quickly compose an email, including background and context.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
Contact centre agent
Discover how Elena uses technology to prioritise tasks, manage meetings and streamline her workflow.
Morning
Elena spends her morning interacting with many customers to help with their questions and service issues. This involves using pre-approved, standardised paragraphs to explain entitlements, which are often repetitive due to common customer queries. She efficiently uses keyboard shortcuts to quickly , as well as to .
Elena then in Microsoft Teams to discuss a customer issue with her supervisor.
Select, copy, and paste text
Quickly copy or move text using your keyboard.
Seamlessly navigate between applications
Switch from one open app to another using your keyboard.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
Afternoon
Following her customer calls and meetings, Elena uses Microsoft 365 Copilot in Teams to . She via Microsoft Teams and OneDrive, to notify them and ask specific questions.
Summarise meeting actions
Quickly generate meeting notes and record action items.
Share a document
Securely share documents with your team and others using OneDrive.
Use tags to notify people
Collaborate effectively by tagging individuals in Teams.
End of the week
Later in the week, Elena in Microsoft OneNote to log customer queries. She reviews and updates customer stats in Microsoft Excel, using the Excel wizard and then to support her upcoming performance review meeting.
Create a digital notebook
Organise your notes and resources using OneNote.
Create a chart
Visualise your data in an easy-to-understand chart.
Create a pivot table
Use a pivot table in Excel to analyse and summarise large datasets.
Health Commissioner
Discover how Alex uses technology to streamline everyday decision-making and manage his health policy work.
Morning
Alex reviews policy updates and health reports, then using Microsoft 365 Copilot in Outlook and identifies action items.
He in Microsoft Teams to discuss policies and afterwards uses Microsoft 365 Copilot in Teams to and summarise actions.
Summarise emails
Quickly get an overview of your inbox, focusing on key items.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
Summarise meeting actions
Quickly generate meeting notes and record action items.
Afternoon
Alex spends the afternoon analysing health data in Microsoft Excel, then to visualise key trends. He then decides to to analyse the data at a deeper level.
Alex then via Microsoft Teams to ensure policies are implemented in a co-ordinated way.
Create a table
Organise your data in a clear, structured table.
Create a pivot table
Use a pivot table in Excel to analyse and summarise large datasets.
Use tags to notify people
Collaborate effectively by tagging individuals in Teams.
End of the week
Alex in Microsoft Teams for a mental health project. Reviewing new research online, he decides to in Microsoft Edge.
He then asks Microsoft 365 Copilot in Outlook to summarising key insights from a recent conference.
Create a new Team
Easily share information with your team.
Use accessibility features
Adjust your Edge web browser settings for easier reading.
Draft or rewrite an email
Quickly compose an email, including background and context.
Nurse manager
Every day differs for Ciara, but she tackles routine tasks with tech. Discover how.
Morning
Ciara starts her day by asking Microsoft 365 Copilot in Outlook to and note key actions. She checks on patients and in Microsoft Teams to ensure seamless care across departments.
Ciara then reviews new healthcare guidelines, stores them in Microsoft OneDrive, and updates the nursing protocols. She uses Microsoft Word to summarise the changes and via OneDrive.
Summarise emails
Quickly get an overview of your inbox, focusing on key items.
Create a group chat
Set up a team chat to collaborate with colleagues and others.
Share a document
Securely share documents with your team and others using OneDrive.
Afternoon
Ciara discusses staffing and budgets with hospital admin. She uses Microsoft Excel to that shows proposed staff changes, auto-filling some of the table before asking Excel to .
Ciara ends her day by creating a training presentation about new patient care techniques. She asks Microsoft 365 Copilot in PowerPoint to .
Create a table
Organise your data in a clear, structured table.
Create a chart
Visualise your data in an easy-to-understand chart.
Generate a presentation
Quickly build a deck from existing content.
End of the week
Ciara on using new medical equipment. She then and uses Microsoft 365 Copilot in Teams to .
Create a team training session
Organise a team workshop.
Run inclusive meetings
Manage a virtual meeting effectively.
Summarise meeting actions
Quickly generate meeting notes and record action items.
Paramedic
Read how Liam uses technology to ease his daily duties, from responding to emergencies to leading community initiatives.
Morning
Liam begins his day by checking his equipment and reviewing emergency protocols. He uses Microsoft 365 Copilot in Outlook to and flag urgent tasks. He in Microsoft OneNote for his team briefing, then with hospital staff to co-ordinate on patient care.
Summarise emails
Quickly get an overview of your inbox, focusing on key items.
Create a to-do list
Efficiently organise your notes in a checklist.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
Afternoon
Later in the day, Liam attends a training session and in Microsoft Excel to track his team’s progress on key learnings.
He then reviews a hospital document containing new emergency protocols, using Microsoft 365 Copilot in Word, and via Microsoft OneDrive with his team.
Create a table
Organise your data in a clear, structured table.
Summarise a document
Create a quick summary of a lengthy report.
Share a document
Securely share documents with your team and others using OneDrive.
End of the week
Drawing on several reports, Liam for a community safety workshop using Microsoft 365 Copilot in PowerPoint.
Afterwards, he using Microsoft Excel to analyse paramedic response times, then to dive deeper and finally presents the findings to his leadership team with recommendations for improvement.
Generate a presentation
Quickly build a deck from existing content.
Create a table
Organise your data in a clear, structured table.
Create a pivot table
Use a pivot table in Excel to analyse and summarise large datasets.
Police officer
Noah uses technology to help him manage investigations, prioritise action items and stay organised during his demanding shifts.
Morning
Noah starts his day by asking Microsoft 365 Copilot in Outlook to , flagging urgent tasks and investigation updates. He then joins a team briefing, in Microsoft OneNote to capture key information and action points.
Next, he uses Microsoft 365 Copilot in Teams to from several witness interviews that were conducted virtually in Teams.
Summarise emails
Quickly get an overview of your inbox, focusing on key items.
Create a digital notebook
Organise your notes and resources using OneNote.
Summarise meeting actions
Quickly generate meeting notes and record action items.
Afternoon
Noah reviews case reports and using Microsoft 365 Copilot in Word. For some cases, he must analyse evidence and financial information, so he uses Microsoft Excel to and help him spot key data trends.
Noah then in Microsoft Teams with a neighbouring police force to co-ordinate on a multi-agency investigation.
Summarise a document
Create a quick summary of a lengthy report.
Create a pivot table
Use a pivot table in Excel to analyse and summarise large datasets.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
End of the week
Noah reflects on the week’s cases by reviewing financial loss data. He in Microsoft Excel to bring this information together, to rapidly complete some cells.
Noah then prepares for the coming week by using Microsoft 365 Copilot in Outlook to to witnesses regarding case updates.
Create a table
Organise your data in a clear, structured table.
Rapidly fill table cells
Use Auto-fill in Microsoft Excel to populate parts of your table.
Draft or rewrite an email
Quickly compose an email, including background and context.
Policy advisor
Find out how Luciano efficiently navigates policy reforms, manages consultations and collaborates with his team throughout the day.
Morning
Luciano starts by reviewing his email inbox, using Microsoft 365 Copilot in Outlook to and highlight urgent tasks.
He then in Microsoft Teams to discuss policy updates and also for better collaboration and communication.
Summarise emails
Quickly get an overview of your inbox, focusing on key items.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
Create a new Team
Easily share information with your team.
Afternoon
Luciano is developing new policy guidance with his team, so together they in Microsoft Word. He then and in Microsoft Excel to track the financial impact of proposed reforms.
Co-author a document
Collaborate on documents in real time with your team.
Create a table
Organise your data in a clear, structured table.
Create a chart
Visualise your data in an easy-to-understand chart.
End of the week
Luciano using Business Chat, powered by Microsoft 365 Copilot in Teams, to help build a briefing.
Afterwards, he using Microsoft 365 Copilot in PowerPoint, summarising key points for internal use, then using Microsoft 365 Copilot in Outlook to share the briefing with stakeholders.
Gather team feedback
Collate and summarise inputs for a quick briefing.
Generate a presentation
Quickly build a deck from existing content.
Draft or rewrite an email
Quickly compose an email, including background and context.
Social worker
Read how Fatima uses technology to manage her casework and work more effectively with clients and colleagues.
Morning
Fatima starts her day by asking Microsoft 365 Copilot in Outlook to and prioritise tasks.
She then to her calendar using Microsoft Outlook. Afterwards, she uses Microsoft 365 Copilot in Teams to and capture key actions, ensuring follow-up on important issues.
Summarise emails
Quickly get an overview of your inbox, focusing on key items.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
Summarise meeting actions
Quickly generate meeting notes and record action items.
Afternoon
To co-ordinate home visits and services, Fatima using Microsoft Teams. She then prepares for a community outreach event by with speaker notes and images using Microsoft 365 Copilot in PowerPoint.
Afterwards, she uses Microsoft 365 Copilot in Word to into a report for her supervisor.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
Generate a presentation
Quickly build a deck from existing content.
Summarise a document
Create a quick summary of a lengthy report.
End of the week
Fatima using Microsoft Word’s co-authoring feature. She then attends a workshop, where she using Microsoft OneNote to take organised and shareable notes. Later, she to update her case management progress.
Co-author a document
Collaborate on documents in real time with your team.
Create a digital notebook
Organise your notes and resources using OneNote.
Add pages to your notebook
Record new tasks and keep track of your progress.
Analyse spreadsheet data
Analyse spreadsheets fast with Copilot.
Generate presentation graphics
Quickly create visuals for documents or presentations using Copilot.
Write better Copilot prompts
Craft clear and effective prompts for Copilot.
Create Teams meeting notes
Summarise and share key meeting points with Copilot in Stream.
Add, subtract, multiply and divide
Do quick maths with simple formulas in Excel.
Link a workbook to Power BI
Quickly connect Excel data to Power BI dashboards.
Merge data into a cell
Combine text or numbers into one cell in Excel.
Remove duplicate data entries
Find and delete duplicate data in Excel with a few clicks.
Sort and filter data
Organise and view your spreadsheet data clearly.
Change your file view
Switch between list, tiles or photos in OneDrive.
Set expiry dates for shared files
Add expiry dates to shared OneDrive links for security.
Search with keywords and tags
Find files faster with tags and keyword searches.
Flag important emails
Mark your emails to follow up on them later.
Delay sending emails
Schedule emails to send at a later time.
Share an email to Teams
Post an Outlook email straight to a Teams chat.
Personalise mass emails
Create personalised bulk emails with Mail Merge.
Track projects efficiently
Assign tasks and keep projects on schedule with Planner.
Create dynamic graphics
Make your slides stand out with custom visuals.
Create a slide template
Save time with reusable slide layouts.
Add animation to presentations
Bring presentations to life with simple animations.
Make global slide changes
Update fonts, colours or logos across all slides.
Set up slide transitions
Enable smooth transitions between your slides.
Use meeting breakout rooms
Split meeting attendees into small discussion groups.
Create a document template
Make reusable templates for reports and letters.
Use bullets and numbering
Format lists clearly with bullets or numbered points.
Use Loop Components
Collaborate in Teams chats with editable Loop items.
Use Paste Special
Paste only the values, formatting or other details you need.
Use Polls in a team meeting
Run live polls in Teams to gather feedback fast.
Use the IF function
Apply the IF function to add logic to your Excel formulas.
Format dates and use DAYS
Work with dates and calculate time differences in Excel.
Explore the Procurement and Purchasing agent
See how Copilot helps streamline buying tasks.
Understand AI agents
Explore how Copilot agents work behind the scenes.
Co-create with Chat
Use Copilot Chat to draft, edit and refine ideas together.
Create a policy impact assessment
Use Copilot Chat to draft impact assessments faster.
Generate a presentation
Quickly build a deck from existing content.
Draft or rewrite an email
Quickly compose an email, including background and context.
Summarise meeting actions
Quickly generate meeting notes and record action items.
Summarise emails
Quickly get an overview of your inbox, focusing on key items.
Summarise a document
Create a quick summary of a lengthy report.
Use accessibility features
Adjust your Edge web browser settings for easier reading.
Use browser Favourites
Rapidly access your most visited web pages.
Rapidly fill table cells
Use Auto-fill in Microsoft Excel to populate parts of your table.
Create a pivot table
Use a pivot table in Excel to analyse and summarise large datasets.
Create a table
Organise your data in a clear, structured table.
Create a chart
Visualise your data in an easy-to-understand chart.
Apply conditional formatting
Auto-highlight key data in Excel based on rules.
Select, copy, and paste text
Quickly copy or move text using your keyboard.
Seamlessly navigate between applications
Switch from one open app to another using your keyboard.
Share a document
Securely share documents with your team and others using OneDrive.
Add pages to your notebook
Record new tasks and keep track of your progress.
Create a digital notebook
Organise your notes and resources using OneNote.
Create a to-do list
Efficiently organise your notes in a checklist.
Record audio clips
Record and save audio or video notes to your OneNote notebook.
Create a virtual meeting
Set up meetings and recurring meetings with ease.
Create an Outlook Rule
Organise your inbox by automatically sorting copied (Cc’d) emails.
Run a slide show
Present a slide show using speaker notes and presenter view.
Create a group chat
Set up a team chat to collaborate with colleagues and others.
Create a new Team
Easily share information with your team.
Create a team training session
Organise a team workshop.
Use tags to notify people
Collaborate effectively by tagging individuals in Teams.
Gather team feedback
Collate and summarise inputs for a quick briefing.
Run inclusive meetings
Manage a virtual meeting effectively.
Co-author a document
Collaborate on documents in real time with your team.