Increase Efficiency with Keyboard Shortcuts
Another way to increase your productivity in Excel is to take advantage of the many shortcuts in Excel such as keyboard shortcuts. With one hand […]
Increase Efficiency with Keyboard Shortcuts Read More »
Excel
Importing Data into Excel from the Web
Excel’s data importing capabilities aren’t limited to data that is stored locally on your computer. It can also be used to pull data from sources
Importing Data into Excel from the Web Read More »
Importing Data into Excel from Text Files
Often, it’s necessary to import data into Excel from a text file. Engineering software such data acquisition, remote measurement, and CAD programs often export data
Importing Data into Excel from Text Files Read More »
Identify Trends or Out of Range Data in Excel Worksheets
There’s another type of formatting in Excel that’s different than the static formatting that’s used to visually separate data. Conditional formatting will highlight cells that
Identify Trends or Out of Range Data in Excel Worksheets 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 »
How to Use Excel Solver to Optimize Engineering Designs
In this post, you’ll see how to apply the Solver to the soda can optimization problem. Rather than optimizing the dimensions of the can graphically,
How to Use Excel Solver to Optimize Engineering Designs Read More »
How to Use Excel Solver for Multiple Linear Regression
Solver can also be used for a multiple linear regression analysis. For this section, we’ll be using the spreadsheet from the last section after working
How to Use Excel Solver for Multiple Linear Regression Read More »
How to Use Array Constants in Excel
Array constants can be used to create arrays, or to modify existing arrays in a worksheet. The worksheet is set up for a vertical array
How to Use Array Constants in Excel Read More »
