Section 7: Lab: Copilot in Excel and Analyst
Analyse service data such as recurring issues, average service time and SLA attainment by site
Create summary tables and charts with natural-language requests
Use Analyst across several files and read through the analysis steps it shows
Lab: check that the analysis makes sense before using it
Section 8: Lab: Analysing the Sales Pipeline and Opportunities
Segment customers by value and churn risk
Identify sites or accounts to offer preventive maintenance or an upgrade project
Make a simple sales forecast from historical data
Lab: produce a customer health summary for the fictional customer
Section 9: Lab: Complaints and Service Recovery
Analyse the issues and sentiment in a complaint
Draft a response that takes responsibility, with a corrective plan and timeline
Capture lessons learned to prevent the problem recurring
Lab: answer the fictional customer's complaint and prepare points for a follow-up call
Section 10: Lab: Copilot Notebooks, Pages and the Monthly Report
Bring each customer's emails, files, meeting summaries and reports into one notebook and ask questions across them
Share working pages with the team using Copilot Pages
Produce a monthly service report (Monthly Service Report / QBR) in Word
Lab: create summary slides for a review meeting with the customer
Section 11: Lab: Building a Sales Team Agent with Agent Builder
Define the agent's role, instructions and starter prompts
Connect SharePoint knowledge such as the service catalogue, warranty terms, SOPs and quotation templates
Test, refine the answers and share the agent with the team in line with document permissions
What Agent Builder covers compared with Copilot Studio
Section 12: Master Workshop: Account 360 and an AI Adoption Plan
Extend the Customer Account Pack with the customer health summary and monthly report
Build a prototype "sales assistant" agent that answers service questions and helps draft initial quotations
Choose quick-win use cases and set measures such as time saved and speed of customer response
Usage governance and the team's data security practices
Present the work and each group's 30-day AI adoption plan