How to Make an X-Y Scatter Plot in Microsoft Excel. Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers. You can give spreadsheet ...

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Adding Data Sets One at a Time Launch Excel and load the spreadsheet containing the data you want to plot. Select the first set of X and Y axis data for your chart.

Excel’s PivotTable feature is a fantastic option for data analysis, allowing users to consolidate and analyze data from various sources in a single, dynamic table.

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.

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.

As I mentioned in my post on how to format tables in Excel, before I do anything with raw data, I format it as a table. To do that, add a row above your headings by right-clicking on the row ...

1] How to subtract multiple cells in Excel by using a formula Here we will talk about how to subtract data arranged in multiple cells in a particular row and column from a single cell in Excel.

Let's say you're working in an Excel worksheet and realize that you need to insert additional rows of data. Luckily, Excel has a built in feature to allow users to insert multiple blank rows.