Turning Spreadsheets into Stories (Without the Formulas)
We’ve all had that "Friday afternoon feeling": a massive export of sales data lands in your inbox, and your boss wants a summary of the "key trends" by Monday. Usually, this means hours of filtering, pivot tables, and mental gymnastics.
At Strata AI Solutions, we want to show you a better way. Today’s AI tools don't just "read" your data; they understand the story behind the numbers. Here is how to use the two most popular tools to do your data heavy lifting.
1. Microsoft Copilot: The "Agent" Inside Your Excel
If you live in the Microsoft 365 world, Copilot is your new best friend. It lives right inside the Excel ribbon.
How to Get Started:
Save to the Cloud: Ensure your Excel file is saved in OneDrive or SharePoint. Copilot needs to "see" it in the cloud to work its magic.
Make it a Table: This is the most important step for beginners! Highlight your data and press
Ctrl + T. AI works best when data is structured in an official "Table" format.Click the "Sparkle": Look for the Copilot icon in the Home tab ribbon.
The "White-Collar" Prompt to Try:
Once the side panel opens, don't just ask for a sum. Try this:
"Analyze this sales data and show me the top three performing regions this quarter. Can you also create a chart showing the month-over-month growth?"
Why it’s Great:
In 2026, Copilot features "Agent Mode." It doesn't just give you an answer; it guides you through the process, showing you exactly which cells it used to reach its conclusion. It can even generate a PivotTable for you with a single click—no dragging and dropping required.
2. Google Gemini: Your Personal Data Scientist
For those who prefer Google Workspace or have messy files they just want to "dump and analyze," Gemini is incredibly flexible.
How to Get Started:
Upload Directly: Go to gemini.google.com. Look for the "+" or "Add files" icon next to the chat box.
Drag and Drop: You can upload an Excel file, a CSV, or even a PDF of a report.
The "Deep Thinking" Toggle: In the latest 2026 version, you can toggle on "Deep Thinking" for complex datasets that require heavy reasoning.
The "White-Collar" Prompt to Try:
"I’m uploading our customer feedback spreadsheet. Can you identify the top three recurring complaints and suggest three ways we could improve our service based on this data?"
Why it’s Great:
Gemini excels at Multimodal Analysis. It can look at your data and simultaneously cross-reference it with real-time market trends from Google Search. It's less about "calculating" and more about "interpreting" the "Why" behind your data.
Copilot vs. Gemini: Which Should You Use?
FeatureMicrosoft CopilotGoogle GeminiBest ForDeep integration with your existing Excel workflow.Quick analysis of "messy" files and cross-referencing the web.VisualsExcellent for creating native Excel charts and PivotTables.Better at explaining insights in plain, conversational English.SetupRequires data to be formatted as a "Table."Can handle raw files and "unstructured" data easily.
The Strata AI "Safety First" Tip
When using these tools, remember: The AI is your intern, not your boss. Always double-check a few of the "big numbers" manually. If the AI says your revenue grew by 400%, take a quick peek at the raw data before you send that email to the CEO!