Excel has two primary types of charts that graph data sets onto an axis: line charts and scatter charts. Depending on your settings, the two types of charts can look identical, but using the wrong one ...

If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet. The Consolidate Data wizard ...

After opening Excel, click File. At the bottom of the File menu, click Options. Click Add-Ins and then Go… . This opens an additional pop-up window that allows you to select the Analysis ToolPak.

Data can often feel overwhelming—rows upon rows of numbers, scattered information, and endless spreadsheets that seem to blur together. If you’ve ever stared at a dataset wondering how to make sense ...

Microsoft recently added a new optical character recognition feature to Excel that lets users import data from a photograph taken from a smartphone. Here's how to use it. I first started using ...

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes. Microsoft Power Query ...