Excel Tips: Quick Fixes for Data Messes
Data Cleanup with Power Query One of the first things you need to do when handling complex engineering problems in Excel is to ensure your […]
Excel Tips: Quick Fixes for Data Messes Read More »
Engineering Calculations
Calculate Slope in Excel
It’s easy to calculate a slope in Excel using the SLOPE function, but it’s also possible to use chart trendlines and simple arithmetic as well.
Calculate Slope in Excel Read More »
Engineering Notation in Excel
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
Engineering Notation in Excel Read More »
Unit Aware Calculations in Excel
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
Unit Aware Calculations in Excel Read More »
Using Excel Form Controls to Control Spreadsheet Inputs
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.
Using Excel Form Controls to Control Spreadsheet Inputs Read More »
Using Excel Data Validation to Avoid Errors
Excel’s data validation tool allows you to constrain a cell’s inputs to meet certain criteria. This can help prevent errors from occurring. In the example
Using Excel Data Validation to Avoid Errors Read More »
Solving Non-Linear Equations in Excel with Goal Seek
In addition to solving nonlinear equations like the Colebrook equation graphically, you can also solve them numerically using a feature called Goal Seek. Our worksheet
Solving Non-Linear Equations in Excel with Goal Seek Read More »
Solving a System of Simultaneous Linear Equations in Excel
Systems of linear equations can be solved in Excel using formulas that perform matrix calculations. This worksheet is set up to find three unknowns in
Solving a System of Simultaneous Linear Equations in Excel Read More »
