In Excel, three primary tools are available for performing What-If Analysis: Scenarios, Goal Seek, and Data Table. To recap the last couple of months, here are brief definitions of Scenarios and Goal ...

Learn how to create relationships between Excel tables in this quick overview guide that will have you at to speed in no time at all. Excel ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

One underutilized feature is Excel’s Recommended Pivot Tables. This functionality simplifies the Pivot Table creation process by offering pre-made layout suggestions based on your selected data.

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

Learn how to leverage the new pivot table feature in Excel for iPad to analyze and summarize your data effectively.

Tables can be really handy when trying to organize information in Excel or Google Sheets, but if you need to get rid of the formatting, here's how to do it.

Q. Is there a quick way to format tables in Excel? A. An AutoFormat option in Excel will format your table and allow you to choose from several options. Let’s use the completely unformatted table in ...

Learn how to use Excel pivot tables to QA bulk sheets, plus some tips and shortcuts to enhance your pivot table skills.

In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.