Excel Tips and Tricks for Engineers


Learn to use excel in order to solve engineering problems

What you’ll learn

  • Learn to do matrix math in excel

  • Learn to do derivatives and integrals in excel

  • Solve single and multivariable equations

  • Optimize systems using excel solver

  • Create better fitting curves for your data

  • Use the VLOOKUP function effectively

  • Learn to use conditionals and perform logic tests on data

  • Make interactive worksheets using sliders, checkboxes, comments and dropdown boxes


  • Must have excel installed on your computer.

The goal of this course is to teach you ways you can use excel in order to solve engineering problems in the real world and create worksheets that are easy to navigate. To follow along and make the most out of this course it is recommended that you have the latest version of Excel installed on your computer and have used excel at least once for an assignment or personal project. To enhance your learning experience, I went ahead created short review lessons for some of the math topics and included homework assignments in each lecture for you to check your understanding before proceeding to the next lecture. Moreover, I structured this course so that each lesson is independent from each other. This means you can skip ahead to the part that interests you the most. As far as the course syllabus goes, we are going to start by reviewing the basic matrix operations and calculus operations such as matrix addition, subtraction, derivatives etc. Afterwards, we will learn ways to solve multivariable systems of equations in excel using the excel solver module, create interactive graphs, program logic to our worksheets, and ultimately unlock the power of the VLOOKUP function. As you watch these lectures I highly encourage you to email me with questions if some part of the lecture is unclear or whether you would like some academic advice as you take your first steps as an engineer.

Who this course is for:

  • Engineering students who want to learn how to apply excel in their projects and reports.


Excel Tips and Tricks for Engineers, Free Tutorials Download

Download Excel Tips and Tricks for Engineers Free Links

Password :

Author: Ho Quang Dai

I am Ho Quang Dai, from Vietnam – A country that loves peace. I share completely free courses from major academic websites around the world. Hope to bring free knowledge to everyone who can’t afford to buy

Related Courses

Notify of
Inline Feedbacks
View all comments

Report Link Die

Please provide the most detailed information, we will re-upload as soon as possible