## Follow EngineerExcel Blog on Feedspot

or

EngineerExcel Blog by Charlie Young - 1w ago

The post below is a continuation from a previous post: Multiple Linear Regression in Excel Solver can also be used for a multiple linear regression analysis like the one in the previous section. For this section, we’ll be using the spreadsheet from the last section after working through the example so that we can compare… Read more about How to Use Excel Solver for Multiple Linear Regression
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 3w ago

Array constants can be used to create arrays, or to modify existing arrays in a worksheet. The worksheet is set up for a vertical array and a horizontal array. First, we’ll use array constants to fill in the x column of the vertical array. Select the cells in this column. An array is designated with… Read more about How to Use Array Constants in Excel
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 1M ago

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. Before you create a scatter chart in Excel, it’s best to have… Read more about How to Quickly Create an XY Chart in Excel
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 1M ago

It’s important in engineering to document your work and show how you got a result. One of the complaints engineers often have about Excel is that it’s difficult to understand the equations that are being used. One way to document references and equations is to use comments. It’s easy to add comments to any cell.… Read more about How to Document Equations and References in Excel
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 2M ago

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… Read more about How to Create Dynamic Engineering Diagrams in Excel
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 2M ago

When you write functions and subroutines in VBA, you’ll probably take advantage of some of the built-in worksheet functions of Excel itself. VBA has some functions of its own, but to get the most functionality in VBA, you’ll need to use worksheet functions like the ones you’ve been using throughout this course. In this post,… Read more about Functions in VBA
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 3M ago

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… Read more about Formatting Engineering Worksheets for Clarity in Excel
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 4M ago

The next few sections will show you some ways to perform design optimizations in Excel. The first method will be graphical optimization. This method works well when there are only one or two independent variables. Worksheet 06f contains an optimization for the dimensions of a soda can to minimize its cost. We’ll assume that the… Read more about Finding Optimum Solutions with Excel Charts
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 4M ago

The examples in this section and the next will use the Colebrook equation. This equation is used to find the Darcy Weisbach friction factor for flow in a pipe without having to look it up on a Moody chart. The inputs to the equation are the Reynolds number (Re), the hydraulic diameter (Dh), and the… Read more about Finding an Equation Root Graphically in Excel
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .
EngineerExcel Blog by Charlie Young - 5M ago

The Excel solver is a powerful add-in that allows you to do things like perform nonlinear regressions, solve systems of non-linear equations, and optimize designs. The Solver is an add-in that is not enabled in Excel by default. To turn it on, go to the Developer tab, then choose Excel Add-ins. In the window that… Read more about Excel Solver Overview

Articles marked as Favorite are saved for later viewing.
• Show original
• .
• Share
• .
• Favorite
• .
• Email
• .