Need Help?

Contact Us!

For fastest service please enter your question or issue in the text box below. Enter your name and email address so we can reply to your question or concern. Be sure to give us enough info to identify the course or order that you need help with.

You may also call us at: 561-753-0105

Thank you. Your message has been sent. We will answer within one business day.

Important: We sent a receipt email to the address provided. If you do not receive that email, we did not receive your message.

Welcome to SunCam

SunCam: Online Continuing Education Classes

286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra

By: Kwabena Ofosu, Ph.D., PE, PTOE

If you are having problems opening or downloading the PDF files above, we can send them as an email attachment. (We cannot email streaming videos at the moment.) Send PDF Files via Email.

Course Objective

This continuing education course is written specifically for professional engineers with the objective of relating to and enhancing the practice of engineering.

Course Description

286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra

In their fields of specialty, Engineers are constantly challenged with solving a wide range of complex analytical and computational problems. These problems involve analysis methodologies and the management of data. The application of computers enables repetitive, time-consuming and often tedious calculations to be conducted rapidly, efficiently, and less prone to errors. The application of computer tools also enables the results and outputs of such engineering analyses to be readily transferred and incorporated into reports and other engineering documents. An even greater advantage—in terms of productivity and efficiency—is realized when these calculations and outputs are replicated across numerous projects. Competence in computer skills predisposes engineers to pursue and develop more creative and innovative solutions to problems.

Microsoft Excel is an electronic spreadsheet program developed by the Microsoft company, and is part of the software products. A spreadsheet is a grid that organizes data and calculations into columns and rows. The intersection of a column and a row is called a cell. An electronic spreadsheet enables users to store, organize, manipulate, and analyze data in the cells of the spreadsheet. As of this publication, the software is into the 2016 release.

Microsoft Excel is widely and increasingly being used as a tool to assist engineers in conducting and replicating intricate calculations and analysis, designing complex systems, and managing large data sets. This course presents a selection of engineering analysis topics and how to formulate, implement and solve them in Microsoft Excel.

This course presents fundamental principles and engineering applications of problems in linear algebra, and demonstrates the Excel tools, methods, and strategies that can be used to formulate and solve them.

Upon completion of this course, participants will have gained insight into applying Excel tools, methods, and strategies in analyzing, formulating and implementing a variety of engineering related problems, as well as managing large sets of complex data. Participants will also be able to identify professional situations where the application of innovative Excel techniques will be of great benefit and advantage, and will enable practitioners to significantly improve their productivity, efficiency, and the quality of their work product.

286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Theodore McAnlis
09/10/2018
Verified Buyer
The author certainly knew his matrix manipulations and excel solutions, but I invested considerably more than 4 hours in taking the course and testing. It would be valuable for anyone using matrixes in engineering calculations.
1 of 1 customers found this helpful.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Wm Dee Henrie
07/07/2018
Verified Buyer
This was a good course and the explanation and presentation were detailed enough to get started with using the MS Excel solver.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Maria Wall
05/29/2018
Verified Buyer
Very useful and practical example. Easy to understand course content.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Maria Wall
05/29/2018
Verified Buyer
Very practical content. Easy to apply to my role at a utility company.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Chris Budd
05/29/2018
Verified Buyer
Great class - thank you - Thank goodness for Excel
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Edward Woznicki
03/21/2018
Verified Buyer
AN EXCELLENT COURSE. brought me up to speed on aspects of Excel I was unaware of. however: I submit there are no correct answers for questions 23,24,25,&26.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Nick Rounds
01/10/2018
Verified Buyer
Great Course if you want to learn how MS Excel can help solve linear algebra problems
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Clark Fuller
12/09/2017
Verified Buyer
Excellent follow up to the the linear algebra course.
1 of 1 customers found this helpful.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
John Charles Thomas
12/08/2017
Excellent course. I will use the technology in my work.
1 of 1 customers found this helpful.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Mitch Warren
12/08/2017
Verified Buyer
Good review material and I learned a few new things as well!
1 of 1 customers found this helpful.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Clark Fuller
12/08/2017
Verified Buyer
Excellent material review after almost 50 years away from college engineering/math. Sure wish we had Excel back then!! Instructor did a great job of working you back into the use of matrices, and his methodology was excellent. Test was comprehensive for the information covered.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Gregory Hosford
11/25/2017
Verified Buyer
All in all a good course. Using 6X6 matrices was a bit tedious but a good exercise.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Lionel
11/20/2017
Verified Buyer
Very good. Didn't realize Excel had this capability. Don't use matrices often but when I do I have had to calculate them by hand. Takes forever. Now almost instantly.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
William Henrie
11/10/2017
Verified Buyer
Took me back to a good review of College math classes and how much I would have liked to have had the Current Excel program then.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Sergio Fagundo
10/25/2017
Verified Buyer
Very concise yet clear review of a complex topic.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Mohammad Sharifinassab
10/16/2017
Verified Buyer
Great course
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Monte
10/12/2017
Verified Buyer
Dr. Ofosu has prepared easily followed information that is quite helpful in the use of Excel Solver. I enjoyed the course and feel reasonably confident in the use of Solver.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Monte
10/10/2017
Verified Buyer
Well written
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Mohammad Sharifinassab
10/10/2017
Verified Buyer
Excellent Course
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Ben Rhodes
09/29/2017
Verified Buyer
Time consuming course for continuing ed. Very good content however for extended sudy
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Debi Zeno
09/24/2017
Verified Buyer
The course explained how to do a 3x3 matrix, but the test asked you to do a 6x6. Not fair.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Tristan Anderson
09/15/2017
Verified Buyer
Direct, easy to use format that lets you learn at your own pace. The information was very useful, I plan on using this information immediately in my practice for simple beam analyses and optimizations.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
William
09/13/2017
Verified Buyer
Very concise and detailed. Learned from the first lesson and excel is really easy now.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
JOHN R THORINGTON
09/12/2017
Verified Buyer
I was able to pass the exam only after new exam instructions appeared online after three frustrating weeks of trying to pass with incomplete exam instructions. Aside from that, I liked the examples and the creative way the author incorporated them into the instruction. I plan to use this course in my optimization work.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
William Lambert
08/29/2017
Verified Buyer
Well designed course.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
William J Lambert
08/27/2017
Verified Buyer
Great course. I think the answer sheet is incorrect on question 21. . . .
We agree with your observation about question 21 and have made the correction. Portions of the review have been removed because they disclosed the correct answer to a question.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
William Randall
08/26/2017
Verified Buyer
The course was well-presented. It started with the simple concepts and proceeded to the more difficult. The examples were relevant and made the points being illustrated. The examination tested exactly what was taught.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Pascal Hayes
08/23/2017
Verified Buyer
Well organized and straightforward for a topic that is not particularly straightforward (to me) in the first place. The scenarios used in the math modeling are clever real world applications that have a bit of life to them that help understand what's going on. The presentation of the material is excellent and step by step. The quiz is a well designed instrument as well with many "what-if" scenarios that aid in understanding the mechanics of the optimizations.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Pascal Hayes
08/22/2017
Verified Buyer
Excellent refresher on matrix algebra. Well organized and the test was well designed to reinforce the knowledge. I had never used the matrix functions in Excel before. I might add two things that may be useful to future students. It is possible to name the matrices so you don't have to select the arrays each time. . . .
Portions of the review have been removed because they disclosed the correct answer to a question.
1 of 1 customers found this helpful.
Was this helpful?
286-Engineering Methods in Microsoft Excel - Part 1: Linear Algebra
Andrew C.
08/17/2017
Verified Buyer
The course notes explained the premise quite well, but I'm concerned that some of the multiple choice questions do not have correct answers.
Was this helpful?
 
SAVE 20%
Order the Complete Set of 3 Courses for $288.00!

You Must Use This Button to Get The Savings
Price: $90.00
Quantity:
This Course Includes FREE Software
Course Code: 100236-08
Course PDH Hours: 4
Engineering Course Approvals
  • This course is accepted for engineering continuing education credit in all states except: Ohio

About Course Approvals

Other Courses by Kwabena Ofosu, Ph.D., PE, PTOE

Course Title Rating Hours Price
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
(4.6) 69 Reviews
4 $90.00
This Course Includes FREE Software




Need Help?

Contact Us!

For fastest service please enter your question or issue in the text box below. Enter your name and email address so we can reply to your question or concern. Be sure to give us enough info to identify the course or order that you need help with.

You may also call us at: 561-753-0105

Thank you. Your message has been sent. We will answer within one business day.

Important: We sent a receipt email to the address provided. If you do not receive that email, we did not receive your message.