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.

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.

When you use Excel, you have access to powerful tools that can help you make informed decisions based on different scenarios. Two of the most useful tools for this purpose are Goal Seek and the ...

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

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals. If you ask me, Excel’s what-if analysis tools are under-used. I often respond to ...

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 useful if you need to enter a lot of data into Excel ...

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.