Excel can do more than just render typed numbers in tables of cells. It can take two columns of numbers and show a pictorial representation of how they relate to each other through a graph.

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.

Padding Numbers In the previous example you saw that we can format numbers and force then to display a fixed number of decimal places. The 0.00 part of the custom format makes this happen. For example ...

Want to know how to create a scatter plot in Excel? Here's a guide on how we created a simple chart based on performance numbers.

2] Using custom formatting You can create your own custom format in Excel to highlight negative numbers. Select the range of cells containing the numbers. On the Home tab in the Numbers group ...

How to Make a Graph in Excel With Word and Number Variables. Microsoft Excel can perform numerous statistical functions, as well as create charts from statistical data. Statistical data includes ...

Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how.

However, Excel's random number functions are volatile, meaning they change constantly. In this article, I'll show you how to generate and fix random numbers and remove duplicates.