|
Excel
2007 for Engineers
| |
|
Attention
New York Engineers:
This
course cannot be taken to fulfill your continuing education requirements
in the state of New York since the course does not fall under the category
of "Areas of Practice" or "Law/Ethics". For more
information, check the New
York State Board Requirements.
|
Robert
Duane Nickols, P.E.
Overview
This course covers the use of Excel in engineering. You will need Office 2007 or Excel 2007 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 341 built-in functions in Excel for converting
units, statistics and those used to solve simultaneous equations. It even covers how to insert special characters like Ω and φ into Excel.
Excel 2007 for
Engineers is an excellent starting point for new Excel users, for those
upgrading to Excel 2007 from other versions of the program, or for those who
just need a refresher on the basic functions of the program.
A self-installing file can be downloaded to add the example worksheets to your hard drive.
This course requires that you have Office 2007 / Excel 2007. Worksheet files should not be installed if you do not have the applicable program.
The student must take a multiple-choice quiz consisting of twenty (20) questions at the end of the course to obtain PDH credits.
Specific Knowledge or Skill Attained
This
course teaches the following specific knowledge and skills:
-
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
-
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
-
How to use statistical functions in Excel
-
Be familiar with other categories of functions
such as Math & Trig, Engineering, etc.
-
How to use matrix functions in Excel to solve simultaneous equations
Course
Click on the following
PDF attachment and review the document prior to taking a quiz for PDH credit.
Excel
2007 for Engineers
Excel
worksheets used in the course can be downloaded and installed on your hard drive
in the following manner:
1 -
RIGHT click the link below and select "Save Target As" (Internet
Explorer) or "Save Link As" (Firefox)
2 -
Save the file to your desktop
3 -
When completed, double click on the icon to install the files on your computer.
Worksheet
installation file for Excel 2007 for Engineers
Having Trouble Downloading the PDF File?
Right click on the link. Select "Save Target As..."
Then save on your desktop. To view the file, double click the icon on your
desktop and return to this page to take the quiz.
You may need Acrobat Reader to view this document.
Click on the link below to download a free copy of Acrobat Reader.
To obtain PDH credits for this course, you will need to take a quiz for
credit. Click on the link below.
(To take the quiz,
your web browser must be set to accept cookies. See how to
check your cookie settings.)
 
|
