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.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

If the numbers you need to crunch come from the Web, then you’ll need an efficient way to get it into Microsoft Excel. There are several ways you can do this, and one method even allows for automatic ...

Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values.

If you find entering data into spreadsheets to be mind-numbing drudgery, then you probably don't know about these cool, time-saving tricks that make Excel 2010 do the heavy lifting for you.

How to Make Excel Data Horizontal. When you start fresh in Microsoft Excel, you have two options to enter data – horizontal and vertical. But after entering vertical or columnar data, it can ...

Here’s why not: The data-entry process is a lot more difficult in Excel. A real database, after all, gives you a form for entering data, which is a lot friendlier than a spreadsheet’s table ...

Enter the new data series in the cells next to or below the source data. If there are no empty cells, insert a new row by right-clicking the row below where you want to insert the new row.

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.

Visio Data Visualizer add-in for Excel will help you create Flowcharts & Organizational charts in & present your data in an attractive manner to easily visualize and analyze it.