Excel Tips: Quick Fixes for Data Messes
Data Cleanup with Power Query One of the first things you need to do when handling complex engineering problems in Excel is to ensure your […]
Excel Tips: Quick Fixes for Data Messes Read More »
Data Cleanup with Power Query One of the first things you need to do when handling complex engineering problems in Excel is to ensure your […]
Excel Tips: Quick Fixes for Data Messes Read More »
In this post, you’ll learn how to display numbers in Excel using engineering notation, how engineering notation differs from scientific notation, and how custom formats
Engineering Notation in Excel Read More »
Every engineer knows that for the results of engineering calculations to be correct, the units of the input values must be correct. In the case
Unit Aware Calculations in Excel Read More »
Excel provides another way to ensure input values meet certain criteria other than data validation: form controls like combo boxes, list boxes, and radio buttons.
Using Excel Form Controls to Control Spreadsheet Inputs Read More »
Sometimes, a picture is worth a thousand words – especially in engineering. That’s why we have engineering drawings. Excel makes it easy to add diagrams
How to Create Dynamic Engineering Diagrams in Excel Read More »
There are some formatting techniques that engineers need more often than the average Excel user. These techniques will help you format your spreadsheets, so they
Formatting Engineering Worksheets for Clarity in Excel Read More »
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
9 Smarter Ways to Use Excel for Engineering Read More »
One of the tips in my eBook that gets a lot of response is to use the CONVERT function to convert units in Excel. It’s
Tips for Using the CONVERT Function in Excel Read More »