# Excel

## Scale, Offset, or Change the Sign of Data in Excel

The Paste Special feature allows you to quickly do some basic mathematical operations on your data. When you’ve copied a cell, you can add, subtract, […]

## How to Fit an Equation to Data in Excel

You can use Excel to fit simple or even complex equations to data with just a few steps. Determine the Form of the Equation The

## Complex Matrix Multiplication in Excel

In a recent post, I showed how you can multiply matrices in Excel. That post led to a great question from an EngineerExcel subscriber: Is

## Pi in Excel

Of all the constants in Science, Engineering, and Mathematics, pi, or the ratio between a circle’s circumference and diameter is by far the most common.

## 3 Steps to Working with Array Formulas in Excel

Array formulas in Excel are a great tool for performing time-series calculations or sensitivity studies on input variables. An array is a group of cells

## Hyperbolic Curve Fitting in Excel

I’ve talked about the various procedures for fitting different types of curves on this blog before, but today I want to show you a technique

## Sensitivity Analysis Excel Calculation with Data Tables

All too often in engineering we tend to assume that the variables that affect our designs are (*fancy word alert*) “deterministic“. In other words, we

## Iteration in Excel with Goal Seek

Excel provides us with a quick and easy way to perform simple numerical iteration in Excel. The tool is called Goal Seek, and it first

Scroll to Top
Complete... 50%