Excel for Engineers
In Excel for Engineers, you'll learn ...
- Become familiar with terms used in Excel such as workbook, worksheet, chart sheet, cell address, etc.
- Become familiar with the user interface in Excel such as name box, formula bar, ribbon, sheet tabs, etc.
- How to create a worksheet
- Know the order of precedence of operators
This course covers the use of Excel in engineering. You will need a recent version of Microsoft Office or Microsoft Excel to follow examples in the course. You do not need prior knowledge in the use of Excel. The course covers terms used in Excel and the user interface.
You will learn how to make a worksheet and chart sheets (graphs) in Excel. The examples cover rectangular, semi-log and log-log graphs. The course covers many of the built-in Excel functions for converting units, statistics, and those used to solve simultaneous equations. It even covers how to insert special characters into Excel spreadsheets.
This course is an excellent starting point for new Excel users or for those who just need a refresher on the basic functions of the program. Excel 2007 is used for the illustrations in the course, however the functions discussed are applicable for any version of the program.
After purchase, a self-installing file can be downloaded to add the example worksheets to your hard drive. These files are compatible with most versions of Excel. You should have access to a version of Excel in order to work along with the course document.
Specific Knowledge or Skill Obtained
This course teaches the following specific knowledge and skills:
- Terms used in Excel such as workbook, worksheet, chart sheet, cell address, etc.
- The user interface in Excel such as name box, formula bar, ribbon, sheet tabs, etc.
- How to create a worksheet
- The order of precedence of operators
- How to create a chart sheet
- How to plot a rectangular graph based on an equation
- How to insert special characters in Excel
- How to plot a log-log graph, add a trend line and display the equation for the line on the graph
- How to plot a semi-log graph with trend line, equation and annotation
- How to use the CONVERT function in Excel
Certificate of Completion
You will be able to immediately print a certificate of completion after passing a multiple-choice quiz consisting of 20 questions. PDH credits are not awarded until the course is completed and quiz is passed.
|This course is applicable to professional engineers in:|
|Alabama (P.E.)||Alaska (P.E.)||Arkansas (P.E.)|
|Delaware (P.E.)||Idaho (P.E.)||Indiana (P.E.)|
|Kansas (P.E.)||Kentucky (P.E.)||Louisiana (P.E.)|
|Minnesota (P.E.)||Mississippi (P.E.)||Montana (P.E.)|
|Nevada (P.E.)||New Hampshire (P.E.)||New Jersey (P.E.)|
|New Mexico (P.E.)||North Dakota (P.E.)||Oklahoma (P.E.)|
|Oregon (P.E.)||Pennsylvania (P.E.)||South Carolina (P.E.)|
|South Dakota (P.E.)||Tennessee (P.E.)||Texas (P.E.)|
|Utah (P.E.)||Vermont (P.E.)||Virginia (P.E.)|
|West Virginia (P.E.)||Wisconsin (P.E.)||Wyoming (P.E.)|