Dust · My workspace
Pull the Q2 numbers from our regional sales workbook and add a summary tab comparing each region to target.
dust
Completed in 14 sec
Using Microsoft Excel
I opened your Microsoft Excel workbook, read the regional Q2 figures, and built a new summary worksheet comparing actuals to target.
Q2 actuals vs. target by region
- North America. $1.42M actual against a $1.30M target, 109% of plan and the top performer for the quarter.
- EMEA. $980K actual against $1.10M target, 89% of plan and the only region trailing goal.
- APAC. $1.05M actual against $1.00M target, 105% of plan with the strongest quarter-over-quarter growth.
New Summary worksheet
- Created and populated. Added a 'Q2 Summary' tab with region, actual, target, % of plan, and variance columns ready to chart.
- Variance flagged. Total company actual of $3.45M lands 4% above the combined $3.40M target.
What you can do with Microsoft Excel
Pull data from any workbook
Locate the right file across your Excel library, list its tabs, and read exact cell ranges so the agent works from real worksheet values, not guesses.
list_excel_files
get_worksheets
read_worksheet
Build and update worksheets
Write values into specific ranges, spin up brand-new tabs, and clear out stale cells so the agent can populate reports and models directly in your workbook.
write_worksheet
create_worksheet
clear_range
Turn rows into a summary
Read across multiple tabs and write back a clean summary worksheet that rolls up totals, variances, and comparisons from your raw Excel data.
read_worksheet
get_worksheets
create_worksheet
write_worksheet
Supported actions in Microsoft Excel
Read & Search
- List Excel Files
- Get Worksheets
- Read Worksheet
Create & Update
- Write Worksheet
- Create Worksheet
- Clear Range
6 total actions available (3 read, 3 write)
Frequently asked questions about Microsoft Excel
Yes, Dust can access and work with Excel files stored in your connected Microsoft OneDrive.
Get started with Microsoft Excel
Connect Microsoft Excel to Dust and let AI agents handle your workflows.
14-day free trial. No credit card required.