A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of ...

For even the most new-to-the-program users, compiling a graph in Microsoft Excel is fairly intuitive. Excel offers a one-click option on its "Insert" menu to take data on a spreadsheet and render ...

Not everyone is familiar with Excel. You can protect the data input process by using Excel's UserForm object to collect data. Susan Harkins explains how.

How to Add an Overlay to Excel. Microsoft Excel 2010 can create a chart to illustrate numeric data from a worksheet. Excel's "Chart Tools" contain "Labels" that customize the chart area. Add an ...

When you first generate the 3D map, Excel will review your column headers and try to identify which column contains the geographical data you want to plot.

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.