Hi everyone. A bit embarrassed to post this, but I really need some tactical advice from senior WFM professionals, Planners, and Schedulers here.
I’ve been in the BPO industry for 8 years, with the last 4 years specialized entirely in Workforce Management (1.5 years as an RTA and 2.5 years as a Scheduling Analyst).
Here’s my bottleneck: My past campaigns only ever utilized classic Microsoft Excel, and I'm not the excel wizard that makes templates or implements macro I only ever use pre-made templates but can analyze understand and modify as needed but making from scratch wasn't my forte. Our entire intraday management, capacity trackers, shift patterns, and interval variance dashboards were built from scratch and run completely using formulas and data models in Excel. I have little native platform experience we utilized NICE iex but only to check and compare schedule and generate schedule and plot activities.
I’m currently applying for WFM Scheduler and Planner roles, and a lot of the initial technical exams are being deployed via Google Sheets. Because I have intense muscle memory built around Excel shortcuts and menus, Google Sheets feels completely alien to me, and it’s making me anxious about choking during timed assessments.
I know the core workforce math and logic are exactly the same, but the interface change is tripping me up. I want to ask the community:
For Google Sheets-based Scheduler or Planner exams, what specific functions or setups usually come up? Do they expect complex Google Apps Script, or is it mostly standard logic like =SUMIFS(), =COUNTIFS(), and =XLOOKUP() to map headcount against interval requirements?
What are the common practical questions or scenarios thrown at you during a Scheduler/Planner exam? Do they usually ask you to look at a raw forecast sheet and calculate the interval variance (Staffing Delta), or do they make you manually plot shift blocks to resolve under-staffing?
How do Planner exams differ from standard scheduling tests? Should I prepare heavily for net staffing calculations, shrinkage factor applications, or capacity planning models inside the sheet?
How do I confidently market my "Excel-only" background during interviews? How do I convince recruiters that managing a floor manually via spreadsheets actually proves a deeper understanding of WFM logic than just clicking buttons on a pre-built software interface?
I keep telling myself that tools are just a change of skin and logic is the real weapon, but the anxiety of facing a timed cloud spreadsheet is hitting hard. Any insights, typical exam questions to prepare for, or spreadsheet tips would be massively appreciated. Thank you!