Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

Learn how to use Excel's What-If Analysis tools, including Goal Seek and Scenario Manager, to explore different scenarios and outcomes using ...

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

Before using the form, it is advisable to put your data into an Excel table. Tables in Excel offer many advantages, such as automatic formatting and the ability to easily add or remove rows.

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals.

How to Create a Form Using Microsoft Excel 2007. There are several ways to add forms in Microsoft Excel 2007, without the need to learn Visual Basic and type complex code. A basic form can be very ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

Excel's format painter doesn't just work with cell formatting—you can also duplicate formatting between shapes, charts, text boxes, and most other items in your spreadsheet.