How to Quickly Create an XY Chart in Excel
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 […]
How to Quickly Create an XY Chart in Excel Read More »
How to Document Equations and References in Excel
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
How to Document Equations and References in Excel Read More »
How to Create Dynamic Engineering Diagrams in Excel
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
How to Create Dynamic Engineering Diagrams in Excel Read More »
Functions in VBA
When you write functions and subroutines in VBA (Visual Basic for Applications), you’ll probably take advantage of some of the built-in worksheet functions of Excel
Formatting Engineering Worksheets for Clarity in Excel
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
Formatting Engineering Worksheets for Clarity in Excel Read More »
Finding Optimum Solutions with Excel Charts
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
Finding Optimum Solutions with Excel Charts Read More »
Finding an Equation Root Graphically in Excel
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
Finding an Equation Root Graphically in Excel Read More »
Excel Solver Overview
The Excel solver is a powerful add-in that allows you to do things like perform nonlinear regressions, solve systems of linear equations and non-linear equations,
Excel Solver Overview Read More »
