## Cell Filling Shortcuts in Excel

In this post, you’ll see how to quickly fill series of data and formulas in a spreadsheet. To enter in data that have a regular […]

Cell Filling Shortcuts in Excel Read More »

In this post, you’ll see how to quickly fill series of data and formulas in a spreadsheet. To enter in data that have a regular […]

Cell Filling Shortcuts in Excel Read More »

If the function you want to integrate is known in terms of a variable, you can perform the integration using VBA instead of the tabular

Calculating the Integral of an Equation in Excel with VBA Read More »

There are two basic functions that allow you to pull data from tables you’ve created so that you can use them in a calculation: VLOOKUP

Basic Lookups in Excel with VLOOKUP and HLOOKUP Read More »

Array formulas allow you to use multiple cell inputs rather than a single cell input. There are two types of array formulas. One type of

Array Formulas in Excel for Engineering Calculations Read More »

There are additional logical functions that you can use along with the IF function to add even more logical decision-making capability. First, the AND function

AND and OR Functions in Excel Read More »

Inevitably, you will often reference other cells in your calculations. There are two different types of cell references in Excel: relative and absolute. This is

Absolute and Relative Cell References in Engineering Spreadsheets Read More »

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,

Scale, Offset, or Change the Sign of Data in Excel Read More »

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

How to Fit an Equation to Data in Excel Read More »