In this section, we’ll look at how to move entire rows of data and insert new ones. The example below is data from a pump manufacturer for each of their different pump sizes. Ultimately, we may want to use this data for a lookup table. Each column is a different size of pump (7, 10, …
In the last section, you saw how to do a basic text import. The Text Import Wizard offers a lot of options to customize this type of import. You can specify how you’d your text data to be imported, minimizing the amount of cleanup that you need to do on the data. In this section, …
Solver can also be used for a multiple linear regression analysis. For this section, we’ll be using the spreadsheet from the last section after working through the example so that we can compare the two methods. Copy the coefficients calculated with LINEST. Right-click the first cell below the coefficients and paste the values. This will …
How to Use Excel Solver for Multiple Linear Regression Read More »
Engineers often create charts to visually communicate data. Excel is able to make a number of different types of charts, and there are a lot of customization options. First, we’ll look at XY scatter charts, which are probably the most common for engineers. Scatter charts are a very great way to display data. You can …
Sometimes, a picture is worth a thousand words – especially in engineering. That’s why we have engineering drawings. Excel makes it easy to add diagrams to your worksheets to illustrate what’s going on in a problem using shapes. To add a shape, go to the Insert tab and choose Shapes: This will show a list …
How to Create Dynamic Engineering Diagrams in Excel Read More »
There are some formatting techniques that engineers need more often than the average Excel user. These techniques will help you format your spreadsheets, so they are clear and easy to understand, both for your own benefit as well as for other users. Proper documentation is the first step in clarifying a spreadsheet. Your input variables …
Formatting Engineering Worksheets for Clarity in Excel Read More »
Formatting charts can take a lot of time, but you can save time by reusing your formatting. We’ll look at how to do this using the charts from the beginning of this chapter. The example shown is an XY chart, but you could apply the same techniques to a bar, column or line chart too. …
Creating and Reusing Custom Chart Styles in Excel Read More »
Importing text data into Excel for analysis is pretty straightforward, but what if you want to use data from a chart in a book or some other reference? There’s a free tool that will let you convert graphical charts into text data: Engauge Digitizer. Go to https://markummitchell.github.io/engauge-digitizer/, and click “Latest Releases.” Choose the appropriate installer …
You’ll also receive regular tips to help you master Excel for engineering.
Learn advanced engineering techniques in Excel with this limited time free video training.
Click the button below to get started today.
