15 Modern Excel Functions Worth Knowing in 2026 That Outclass Clunky Workflows

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...
How-To Geek on MSN

I always use Excel to create heat maps: Here's how you can too

Dynamically visualize your data.

8 New Excel Upgrades for 2026 : Smarter Formulas, Web Charts, Better Error Tips & More

Discover 8 2026 Excel updates, including AI formula creation and a year of change history, so your team works quicker with fewer mistakes.
JournalofAccountancy

Using Excel’s What-If Analysis with Data Table for data analysis

Q. You explained Excel’s Scenario Manager in your November 2024 Tech Q&A article and Goal Seek in your December 2024 Tech Q&A article. Can you please explain the final What-If Analysis tool: Data ...
Outlook Business

Anthropic’s New Feature Integrates Claude in Excel, Access Limited to Pro and Enterprise Plan Users

Anthropic has introduced a new feature named ‘Claude in Excel’ that integrates the AI model into the Excel workflow ...

11 cool things Copilot can do in Excel

As Microsoft ramps up Copilot’s capabilities in Excel, the AI tool is becoming genuinely useful for spreadsheet work.
JournalofAccountancy

Using Excel’s Goal Seek for data analysis

Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager?