Excel has built-in tools that are very useful for troubleshooting formulas, even if the formulas are complex. The example worksheet will calculate the force in the components of a structure made of a steel bar encased in concrete. There is a uniform load applied across the top. This kind … Read more about Troubleshooting Engineering Formulas in Excel

## Trigonometric Functions in Excel

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 … Read more about Trigonometric Functions in Excel

## Save and Load Excel Solver Models

If you've used solver before, you've noticed that every time you close out the Solver dialog and reopen, your settings are preserved. This is handy because it allows us to quickly test and tune the model without having to reenter all the information again. However, what if you want to make a … Read more about Save and Load Excel Solver Models

## Transferring Excel Charts to Other Software

There are a few different options for transferring charts out of Excel and into applications like Word or PowerPoint. In this section, we'll copy the RC Circuit Response chart from Section 4 into a PowerPoint presentation. First, select the chart in Excel and type Ctrl-C. Switch to PowerPoint and … Read more about Transferring Excel Charts to Other Software

## Gaussian Fit in Excel

A Gaussian function has many different purposes in engineering although most people probably recognize it as a "bell curve". Most commonly, it can be used to describe a normal distribution of measurements. Sometimes it's necessary to fit a Gaussian function to data, so this post will teach you how … Read more about Gaussian Fit in Excel

## SUMPRODUCT and SUMSQ Excel Functions

There are two more advanced summing functions that we'll discuss – SUMPRODUCT and SUMSQ. SUMPRODUCT multiplies individual components in arrays together and then returns the sum of those components. The syntax is as follows: SUMPRODUCT(array1, [array2], [array3],…) array1: the first array … Read more about SUMPRODUCT and SUMSQ Excel Functions

## SUMIF and SUMIFS Excel Functions for Engineering Calculations

This section and the next will cover the advanced summing functions available in Excel. The SUMIF and SUMIFS functions enable you to sum values in a range of cells if they meet specified criteria. Values that don't meet the criteria are excluded from the sum. The syntax for SUMIF is as … Read more about SUMIF and SUMIFS Excel Functions for Engineering Calculations

## Solving Systems of Simultaneous Nonlinear Equations in Excel

Unlike simultaneous linear equations, simultaneous non-linear equations cannot be solved using linear algebra. However, we can extend the concept of using Goal Seek from solving a single implicit equation to solving systems of nonlinear equations. In our worksheet, we'll set up equations for flow … Read more about Solving Systems of Simultaneous Nonlinear Equations in Excel