New to Copilot at Work… How do I best utilize it for what I’m trying to do?
I have a ton of employees across multiple locations that work at night. I’m trying to automate the auditing of their timecards to when they actually start/stop working.
My current process is…
Output to Excel a payroll report showing employee names and their clock in and clock out activity.
Output to Excel a machine report showing when their machines started running.
Generate a report in Excel showing which employee was using which machine. This has to be done by hand since employees can use a different machine each night.
Combine all three reports in a single Excel workbook. One report per tab.
I then ask copilot to compare when employees clocked in to when they started on their machines and compare when the employees stopped their machines and clocked out. Copilot readily generates a variance report that I use for coaching opportunities.
My questions are:
Is there a better way?
How do I optimize this for local managers who all have different skill sets and work in different offices throughout our region?
What are some specific prompts that may be extremely beneficial that be missing?