Creating and Reusing Custom Chart Styles in Excel
Formatting charts can take a lot of time, but you can save time by reusing your formatting. We’ll look at how to do this using […]
Creating and Reusing Custom Chart Styles in Excel Read More »
Converting Graphs to Tables of Data
Importing text data into Excel for analysis is pretty straightforward, but what if you want to use data from a chart in a book or
Converting Graphs to Tables of Data Read More »
CONVERT Function for Simple Unit Conversions
Excel has a convenient function to convert between systems of units. The CONVERT function will save you the effort of looking up conversion factors elsewhere.
CONVERT Function for Simple Unit Conversions Read More »
Complex Number Functions in Excel
If you do any engineering calculations that involve complex numbers, you’ll probably appreciate the complex number functions that are built into Excel. Excel has many
Complex Number Functions in Excel Read More »
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 »
Calculating the Integral of an Equation in Excel with VBA
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 »
Basic Lookups in Excel with VLOOKUP and HLOOKUP
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 in Excel for Engineering Calculations
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 »
