Geeky Gadgets

How to create Excel spreadsheets that automatically update themselves

It’s the end of the month, and you’re staring at a mountain of Excel spreadsheets that need updating. You sigh, knowing that hours of tedious work lie ahead. But what if I told you there’s a way to ...

Microsoft Copilot Builds Full Excel Dashboards from Text Prompts

Build a fully interactive Excel dashboard with Copilot to automatically track sales trends and revenue by region. Update ...

Excel's "Table" feature is too convenient | How to use it so formulas and formatting expand automatically when adding rows

Do you find yourself copying formulas, adjusting colors, or fixing aggregation ranges every time you add a row to the end of a table each month? Using Excel's "Table" feature eliminates almost all of ...

Automatically Calculating Paid Leave Entitlement in Excel | Having Generative AI Create the Formula and Verifying It for 207 Employees

October 13, 2026Key points of this article You can leave monthly calculations to Excel by having AI create an Excel formula for paid leave entitlement. When we verified the formula created by AI ...