Blog

As previously mentioned, one of the biggest complaints that engineers have against Excel is that it's difficult to understand formulas in a spreadsheet. Formulas refer to cell references like C6, D7, etc. However, Excel has a feature called Named Ranges that allows you to assign names to … Read more about Using Cell Names in Excel

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

Excel contains a variety of trigonometric functions: Basic functions Hyperbolic functions Inverse … Read more about Trigonometric Functions in Excel

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

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

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