Excel Pivot Tables: Two Fixes for Reports You Rebuild
Most pivot table pain comes from two setup choices nobody mentions. Here is how to build on a Table so a refresh picks up new rows, and how to let Show Values As handle your percentages.
-
-
Power BI for Excel Users: Two Steps to Your First Dashboard
Two concrete steps that take an Excel user from never having opened Power BI to a working, refreshable dashboard: clean the data in Power Query, then build visuals that one slicer drives.
-
Claude in Excel: Two Ways to Fix a Messy Export
Claude can clean up a messy Excel export and explain the formulas it writes. Two ways to use Claude in Excel that you can try this afternoon.
-
ChatGPT for Project Management: Two Prompts That Work
Two practical ways to put AI on a project: a ChatGPT prompt that pulls real commitments out of a meeting transcript, and a Copilot request that finds the tasks quietly slipping in your Excel tracker.
-
ChatGPT with Excel: Two Ways to Stop Fighting Formulas
ChatGPT cannot see your spreadsheet, which is exactly why most people get bad formulas out of it. Here are two prompts that work, with the exact wording to use and the gotchas to watch for.
-
Claude with Microsoft 365: Two Workflows That Save Hours
Claude does not bolt onto Office, and it does not need to. Two copy-and-paste workflows that turn an Excel export and a Teams transcript into finished work.
-
Copilot in Excel: Two Ways to Automate the Report You Rebuild Every Month
Copilot in Excel can build the automation for the report you rebuild every month. Two practical tips: having Copilot write a reusable Office Script, and getting a formula column you can actually trust.
End of content
End of content