In this post, you’ll learn how to display numbers in Excel using engineering notation, how engineering notation differs from scientific notation, and how custom formats work in Excel Table of ContentsContentsVideoEngineering Notation in ExcelEngineering Notation BackgroundWorksheet InputsWorksheet OutputsHow to Display Engineering Notation in ExcelCustom Format for Engineering NotationEngineering Notation vs. Scientific Notation in ExcelHow Engineering …
In this post, you’ll learn how to create a catenary cable tension calculator in Excel by solving an implicit equation. The example will show specifically how to use Goal Seek for finding roots of equations in Excel. Table of ContentsVideoCatenary Cable BackgroundSolving for Catenary Cable Tension in ExcelHow to Calculate Catenary Cable Tension in ExcelStep …
In this post, you’ll learn how to create custom Excel functions to store engineering constants by creating a user-defined function in VBA that can store the yield strength of steel and return it to the spreadsheet. You’ll also learn how to save your custom functions in an Excel template so they are available whenever you …
Custom Excel Functions for Engineering Constants Read More »
Excel’s Solver add-in can be used to find the best-fit line for nonlinear data. Worksheet 07f contains the flow and pressure data that was used in a previous example to illustrate fitting with LINEST. Delete the coefficients that are in the table from that example. For Solver to work, you’ll need to enter guess values …
In this post, you’ll learn how to perform constrained optimization in Excel through an example where we will maximize the flow rate in an open channel. The example will show that there is an optimal relationship between the channel dimensions that maximizes the flow rate for any required cross-sectional area. If you aren’t interested in …
Constrained Optimization in Excel – Maximize Open Channel Flow Read More »
Every engineer knows that for the results of engineering calculations to be correct, the units of the input values must be correct. In the case of a calculation like F=ma, the units must be consistent with each other (e.g. N, kg, m/s^2) and in the case of a unit-specific calculation like P=Tn/5252, the equation requires …
Excel provides another way to ensure input values meet certain criteria other than data validation: form controls like combo boxes, list boxes, and radio buttons. To add form controls, we have to enable the Developer tab, because it’s not turned on by default when you install Excel. Go to File > Options > Customize Ribbon. …
Using Excel Form Controls to Control Spreadsheet Inputs Read More »
Excel contains a variety of trigonometric functions: Basic functions Hyperbolic functions Inverse functions Miscellaneous SIN SINH ASIN PI() COS COSH ACOS RADIANS TAN TANH ATAN DEGREES SEC SECH ASINH CSC CSCH ACOSH COT COTH ATANH The inverse functions are those usually denoted with a superscript -1 in math (i.e. ASIN is the Excel function for …
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.
