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

Q. There are formulas that I am repeatedly having to create in my Excel workbook, and there are no built-in functions in Excel that can do these calculations. Is there a quicker way to reuse the same ...

Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

Numbers by themselves seldom convey the big picture. Excel Charts makes it easy to illustrate trends in your business, from past expenses and profit to sales forecasts based on previous sales. T*o* ...

The INDIRECT function has a rep for being a "nightmare," but for building reactive dashboards, it’s irreplaceable. Here is ...

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

Microsoft announced in early 2012 that it would extend support for aging Visual Basic 6 runtimes and code syntax for the entire life cycle of Windows Vista, Windows Server 2008, Windows 7 and the ...

Learn to simulate stock prices with Excel and gain predictive power over market trends. Our step-by-step guide enhances your analytic skills for better investment decisions.

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use those ...