As an engineer, you know the importance of precision, efficiency, and innovation. These principles not only guide our designs but also how we manage data. […]
Why I’m Not Going Back from Power Query Read More »
If you find yourself buried under heaps of data with Excel as your go-to tool, then buckle up because we’re heading into the world of
Why Power Query Is the Excel Feature Engineers Can’t Ignore Read More »
Power Query is an extremely powerful tool for efficient data analysis and decision-making processes. However, even the most experienced among us can sometimes overlook simple
Avoid These Power Query Pitfalls with Simple Steps Read More »
In this section, we’ll look at how to move entire rows of data and insert new ones. The example below is data from a pump
Inserting Rows into Tables of Data Read More »
In the last section, you saw how to do a basic text import. The Text Import Wizard offers a lot of options to customize this
How to Use the Excel Text Import Wizard 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 »
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
Sensitivity Analysis Excel Calculation with Data Tables Read More »
Power Query is a powerful data gathering tool included in all installations of Excel 2016. But what do you do if you’re not using Excel
Installing the Power Query Add In for Excel 2010/2013 Read More »
You’ll also receive regular tips to help you master Excel for engineering.
