Excel has a really powerful tool that allows you to conduct optimization, solve systems of simultaneous equations, and perform complex multi-variable regression or non-linear regression. […]
How to Enable the Excel Solver Add-In Read More »
With many things we try to do in Excel, there are usually multiple paths to the same outcome. Some paths are better than others depending
Linear Regression in Excel: 4 Alternative Methods Read More »
Today’s post is the final installment in the creation of a mass moment of inertia calculator in Excel. In the first post I showed how
Mass Moment of Inertia Calculator in Excel, Pt. 3 Read More »
In my last post, I started demonstrating how to use advanced Excel features to make a simple engineering application that calculates mass moment of inertia
Mass Moment of Inertia Calculator in Excel, Pt. 2 Read More »
Today’s post kicks off a multi-part series where I will create a mass moment of inertia calculator in Excel. The calculations themselves are simple. However,
Mass Moment of Inertia Calculator in Excel, Pt. 1 Read More »
Making your spreadsheets easy for others to understand is an essential task for engineers. A natural outcome of improving your Excel skills is that your
3 Ways to Make Your Engineering Spreadsheets Easier to Understand Read More »
One of the things that makes Excel such a great tool is the ease at which you can automate certain tasks. This creates many opportunities
Dynamic Chart Titles in Excel Read More »
Recently I put together a post showing how to import data from the web using Excel 2016. But since many businesses haven’t upgraded to the
Web Data Import in Excel 2010 Read More »
You’ll also receive regular tips to help you master Excel for engineering.
