Section 4: Excel/Google Sheets, data analysis and reporting

This section focuses on the real workflows of office workers who use Excel or Google Sheets every day. Excel Copilot, Google Sheets Gemini, the Google Sheets AI function, ChatGPT data analysis and Claude’s file creation features are covered, along with the step of checking the results. [69] [70] [71] [72]

• Scenario 31: Adding a formula and lookup column to a disorganized sales file
• Scenario 32: Cleaning up names, dates and duplicates in a customer list
• Scenario 33: Turning a field sales file into a table with Gemini
• Scenario 34: Grouping open-ended survey responses into themes
• Scenario 35: Creating a verifiable chart from a CSV sales export
• Scenario 36: Creating an Excel report with formulas from a CSV
• Scenario 37: Creating a factory production summary with a PivotTable and chart
• Scenario 38: A simple trend and forecasting exercise for weekly demand
• Scenario 39: Preparing a weekly KPI summary from multiple tabs
• Scenario 40: Converting PDF invoice line items into an editable table