How to Look Up Data in 3D Excel Tables
INDEX and MATCH are great functions to use for flexible lookups of data in either 1D or 2D tables, but they can also be used …
Excel
Complex Number Formatting in Excel
I received a couple of questions back-to-back recently related to my post on complex numbers in Excel, asking how to properly format these types of …
Excel Solver: Which Solving Method Should I Choose?
If you’ve ever ventured into the Excel Solver add-in, you probably noticed that there are many options and it can be a little overwhelming. In …
Excel Solver: Which Solving Method Should I Choose? Read More »
9 Smarter Ways to Use Excel for Engineering
As an engineer, you’re probably using Excel almost every day. It doesn’t matter what industry you are in; Excel is used EVERYWHERE in engineering. Excel …
Reynolds Number Calculator in Excel
In this post I’ll demonstrate how to create a Reynolds number calculator in Excel that can: Handle input values in a variety of different unit …
Import a Text File into Excel
Importing text files into Excel comes up very often in engineering because there are many different types of engineering software that export text files. Often, …
Logarithms in VBA: When a Log is not a Log
Sometimes the subtle nuances of Excel functions can get a little tricky. I ran across one of those situations just the other day when I …
Create From Selection Excel Technique: Name Multiple Cells Quickly
If you follow my blog or have read my ebook, you know that I’m a big fan of using Named Cells to make cell formulas …
Create From Selection Excel Technique: Name Multiple Cells Quickly Read More »
