Let’s see how Copilot can streamline workflows and reduce operational costs for Truckers with the below examples.<\/p>\n
- \n
- For better understanding, we have attached an image below which has the expenses of the vehicle. As you are aware, Microsoft 365 Copilot is an integrated solution, so we have saved that Excel Spreadsheet in OneDrive and will ask the prompt in Copilot Business chat.
![\"Excel](\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/03\/Excel-Spreadsheet-in-OneDrive-Copilot.png\")
<\/li>\n - Make sure the file is saved in OneDrive in your tenant:
\n![\"file](\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/03\/file-saved-in-OneDrive-in-your-tenant.png\")
<\/li>\n - Open Copilot Business Chat\n
- \n
- After uploading the Excel spreadsheet to OneDrive,<\/li>\n
- Launch Copilot Business Chat and refer to the file (Expenses of Vehicles.xlsx) by using the forward slash (\/)
\n![\"Open](\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/03\/Open-Copilot-Business-Chat.png\")
<\/li>\n<\/ul>\n<\/li>\n - Choose the right file.\n
- \n
- When you find the file of your choice select the file as shown in the image below:
\n![\"Choose](\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/03\/Choose-the-right-excel-file.png\")
<\/li>\n<\/ul>\n<\/li>\n - Give the right prompt.You may now prompt copilot and pull expenditure data such as total cost spent on fuel and toll on a specific date, and much more.<\/li>\n<\/ul>\n
Prompt Given to Copilot<\/h2>\n
Expenses of Vehicles.xlsx<\/span>\u202fAnalyze my recent truck-related expenses (fuel, tolls) from 2\/5\/2024 to 3\/29\/2024 and provide a breakdown of the total amount spent on each category. Additionally, calculate the total spent in all combined. The corresponding screenshot can be found below.<\/p>\n
![\"Prompt](\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/03\/Prompt-Given-to-Copilot.png\")
<\/p>\nOutput Given By Copilot<\/h2>\n
According to the data in the file “Expenses of Vehicles.xlsx”, the total amount spent on fuel and tolls for all trucks from 2\/5\/2024 to 3\/29\/2024 is as follows:<\/p>\n
- \n
- Fuel: $400<\/li>\n
- Tolls: $30.5<\/li>\n<\/ul>\n
The total amount spent on fuel and tolls combined during this period is $430.5. Is there anything else you would like to know?<\/p>\n
Prompt II Given to Copilot<\/h2>\n
Expenses of Vehicles.xlsx<\/span>\u202fHow many Trucks have sent less amount than $15 for tolls provide and the merchant\u2019s name as well in a table format, refer to the below screenshot.<\/p>\n
![\"Prompt](\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/03\/Prompt-II-Given-to-Copilot.png\")
<\/p>\nOutput Given By Copilot Based on the Prompt II<\/h2>\n
According to the data in the file “Expenses of Vehicles.xlsx” 1, the following trucks have spent less than $15 on tolls from 2\/5\/2024 to 3\/29\/2024:<\/p>\n
Truck Name\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Amount\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Merchant<\/p>\n
The Midnight Hauler\u00a0 \u00a0 \u00a0$12.5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0State Toll Authority<\/p>\n
The Fuel Efficient\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $7.5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0City Bridge Authority<\/p>\n
The Blue Oval\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $10\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 State Toll Authority<\/p>\n
The Volvo Viking\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0$8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 City Tunnel Authority<\/p>\n
Brake Check\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $11\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 State Toll Authority<\/p>\n
Is there anything else you would like to know?<\/p>\n
Conclusion<\/h2>\n
Microsoft 365 Copilot isn’t just a tracking tool\u2014it’s a strategic asset for the trucking industry. By seamlessly managing expenses and offering insightful breakdowns, it empowers businesses to confidently navigate financial complexities, gain a competitive edge, and meet evolving customer demands. With its precision in categorizing and assessing expenses, Microsoft 365 Copilot stands as an indispensable ally in optimizing financial management for sustained industry leadership.
\n
- When you find the file of your choice select the file as shown in the image below: