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
Requirements
Must have excel installed on your computer.
Description
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.
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 13 lectures (1h 35m) | Size: 511 MB
Download
*
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
Requirements
Must have excel installed on your computer.
Description
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.
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 13 lectures (1h 35m) | Size: 511 MB
Download
*