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?

This amazing new Excel function will make you retire SUMIF forever! In this video, I'll show you Excel's brand new GROUPBY ...

Common Excel visuals like pies, 3D charts, and dual axes often mislead more than they clarify data.

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Learn how to use Excel Power Query’s extract and split column features to extract delimited strings into their components with this step-by-step tutorial. You might receive foreign data in the form of ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find. LAMBDA functions are new to Microsoft ...

Many people working in the corporate world need at least a passing familiarity with Microsoft Excel. Maybe you only indicated that you're skilled with Excel on your resume because it feels like one of ...

Understanding some statistics is important for general science literacy. Below are some common statistics resources that may be useful for your project work. To support your professional development, ...