Case Study: Microsoft learns to build and analyse Excel staff rosters with RosterElf

Microsoft builds a staff roster in Excel in 10 minutes with RosterElf

Microsoft, a major technology company, sought to improve its process for creating staff rosters in Excel. The challenge was that while Excel is a familiar and flexible tool, manually building, analyzing, and formatting rosters is time-consuming, and ensuring compliance with Australian Modern Awards is complex and error-prone. They looked to RosterElf for guidance on leveraging Microsoft's own Copilot AI within Excel to assist with this task.

RosterElf provided a detailed guide on using Microsoft Copilot in Excel to draft, populate, and analyze staff rosters. The solution involved structuring data into Excel tables and using plain English prompts to have Copilot total hours, highlight overtime, and suggest formulas. While this method significantly sped up the roster creation and analysis process, RosterElf emphasized that Copilot cannot handle award compliance, a critical gap that their own purpose-built rostering software with automatic award interpretation is designed to fill.

Microsoft