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.
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.
Two things Claude does well for project managers: turning raw meeting notes into a status report you can actually send, and holding your plan in a Project so you stop re-explaining it in every chat.
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.
Two ways to make Copilot in Word genuinely useful: drafting from a file you already own, and reshaping paragraphs you have already written. Exact prompts and the gotchas included.
Two HR tasks that quietly eat the week: writing interview questions and answering the same handbook questions over and over. Here are the exact prompts I use for each one, and the gotcha that comes with them.
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.
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.
Copilot in Outlook can summarize a long email thread with clickable citations and draft the reply for you. Two concrete tips, plus how to get the same result out of a Teams meeting recap.
Two jobs HR teams still do by hand that Copilot and ChatGPT can do in minutes: rewriting job descriptions into one consistent format, and turning hundreds of open-ended survey comments into defensible themes.
Most people try Claude, are impressed for ten minutes, then quietly go back to the old way. That is a setup problem, not a tool problem. Here are two things you can put in place in about ten minutes each.
End of content
End of content