Loading...

Follow EngineerExcel Blog on Feedspot

Continue with Google
Continue with Facebook
or

Valid

Another way to increase your productivity in Excel is to take advantage of keyboard shortcuts. With one hand on the keyboard and one hand ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Often, it’s necessary to import data into Excel from a text file. Engineering software such data acquisition, remote measurement, and CAD ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

There’s another type of formatting in Excel that’s different than the static formatting that’s used to visually separate data. ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 type of import ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

The post below is a continuation from a previous post: Multiple Linear Regression in Excel Solver can also be used for a multiple linear ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 and ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Engineers often create charts to visually communicate data. Excel is able to make a number of different types of charts, and there are a ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

It’s important in engineering to document your work and show how you got a result. One of the complaints engineers often have about Excel ..read more

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview