Course description
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
Overview
Credit: 4 PDH
Length: 43 pages
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.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Who should attend?
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.
Training content
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
Costs
Quick stats about PDHengineer?
Trusted by over 60,000 engineers to meet PDH requirements
Earn reward tokens with each course purchase
Triple guarantee that courses will be accepted by your state licensing board
Contact this provider
Professional Engineers have trusted PDHengineer to provide high-quality PDH courses since 2003. A large library of PDH courses and live, interactive webinars means that engineers can find PDH course material covering all of the major engineering disciplines. Plus, all PDHengineer...