Loading...

Follow EngineerExcel Blog on Feedspot

Continue with Google
Continue with Facebook
or

Valid

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
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
EngineerExcel Blog by Charlie Young - 1M 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
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
EngineerExcel Blog by Charlie Young - 4M 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
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Excel has logical functions to help your spreadsheets make decisions. The most common logical function is the IF function. This function can be used to return a result that is dependent on whether an argument is true or false. The syntax is as follows: IF(logical_test, [value_if_true], [value_if_false]) logical_test: the condition that will be tested value_if_true:… Read more about Excel IF Function for Engineering Spreadsheets
Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Most of my posts are dedicated to XY scatter charts because those are by far the most common chart types in Excel for engineers. However, there are a few more chart types that we’ll discuss in the next two sections. This section will cover three other types of charts: bar, column, and line charts. These… Read more about Excel Bar, Column, and Line Charts for Engineering
Read Full Article

Read for later

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

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview