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 ...

Pivot tables are one of several Excel tools for extracting meaning out of large groups of numeric data. They can be applied whenever raw data in a spreadsheet or database has to be summarized.

An AutoFormat option in Excel will format your table and allow you to choose from several options.

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.

Table Style Options in Excel. Microsoft Excel tables are a way to organize complex data into rows and columns, making your information easy to understand.

How To Automate a Table in Word Using Excel. As the world's leading business productivity suite, Microsoft Office provides many useful features including the ability to automatically display data ...

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

You can delete a pivot table in Excel with a few clicks on a Mac or Windows PC. Here are two ways to do it.

You may have used Excel for years without delving into Styles (or stylesheets). We’re going to cover Cell Styles, and Smart Art, Drawing, Graphics, Picture, and Chart Tools.