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 »
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 »
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
How to Look Up Data in 3D Excel Tables Read More »
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,
Import a Text File into Excel Read More »
Although you’re probably familiar with basic cut, copy and paste operations in Excel, there are quite a few different options available when you paste data
Excel Paste Options and Their Effects Read More »