Any time that we use a lookup function in Excel, we open the spreadsheet up to potential problems with errors. This is because lookup functions such as VLOOKUP (and the closely related function, HLOOKUP) are dependent on absolutely correct spelling. If anyone using the spreadsheet in the future … Read more about How to Use Excel Data Validation to Prevent Spreadsheet Errors

## Using Excel VLOOKUP to Pull Tabular Data into Calculations

In my last post, I showed how you can use web queries to pull refreshable tables of data into Excel. Now that we have the data, we can use the Excel VLOOKUP function to create formulas that will make use of this data. Since we have a table of linear thermal expansion coefficients by material, … Read more about Using Excel VLOOKUP to Pull Tabular Data into Calculations

## Using Queries to Create Data Tables from the Web

Let's just say we wanted to create a spreadsheet that could calculate the stress due to thermal expansion in a beam that is fixed on both ends. In addition to knowing the dimensions of the beam and the temperatures involved, we would also need to have the linear coefficient of thermal expansion of … Read more about Using Queries to Create Data Tables from the Web

## How to Quickly Add Data to an Excel Scatter Chart

Often, engineers need to display two or more series of data on the same chart. In this section, we'll add a second plot to the chart in Worksheet 02b. The first method is via the Select Data Source window, similar to the last section. Right-click the chart and choose Select Data. Click Add above … Read more about How to Quickly Add Data to an Excel Scatter Chart

## 3 Ways to Change the Data in an Excel Scatter Chart

At some point, you may need to change data that's already plotted in an XY scatter chart. In our worksheet, we have the data from the previous section already plotted, but there's an additional column of data in column D. In this section, we'll look at three ways to change the chart to use the new … Read more about 3 Ways to Change the Data in an Excel Scatter Chart

## Excel Paste Options and Their Effects

Although you're probably familiar with basic cut, copy and paste operations in Excel, there are quite a few different options available when you paste data or formulas. It can be difficult to understand all these options at first. When you copy and paste data, a Paste Options button will appear at … Read more about Excel Paste Options and Their Effects

## Linear Regression in Excel with Charts

There are many different tools available in Excel for linear and nonlinear regression. The method described in this post can be used on linear data in a chart. Excel can quickly find the equation of the line that fits your data using chart trend lines. Assume we have some measurements that were … Read more about Linear Regression in Excel with Charts