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.

Looking to become an Excel power user? Excel has a number of features that will make it easier for you and your colleagues to enter data into your spreadsheets. If you’re developing a ...

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

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.