Why I’m Not Going Back from Power Query
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 »
Data
Why Power Query Is the Excel Feature Engineers Can’t Ignore
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 »
Avoid These Power Query Pitfalls with Simple Steps
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 »
Inserting Rows into Tables of Data
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 »
How to Use the Excel Text Import Wizard
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 »
Scale, Offset, or Change the Sign of Data in Excel
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 »
Sensitivity Analysis Excel Calculation with Data Tables
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 »
Installing the Power Query Add In for Excel 2010/2013
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 »
