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.

How to select cells using Find All in Excel Selecting cells that contain specific values is probably a familiar task using Find, but I’m going to show you some options that you might not ...

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

How to Change Series Data in Excel. To update your Microsoft Excel worksheet, you can add a data series to the source data and also update the worksheet chart to make your data meaningful to your ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren't available.

This makes your data up to date with the changes. If you want to refresh a single data, right-click on it and select the Data type and click on Refresh. Geography Data missing in Excel If you are ...

To use Excel's scenario manager function, select the cells with the information you're exploring, and then go to the ribbon and select Data. Select What-If Analysis > Scenario Manager.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.

There are two situations in which you might need to merge two columns of data in Excel 2013. If you've imported two columns of data from separate sources, you might want to combine them into a ...