Course Description.
Excel for Engineers was custom designed by Applied for Engineers and any individuals working within an engineering capacity. The goal of the course is to help Engineers of all disciplines increase their knowledge, productivity, and capabilities with Microsoft Excel, within the context of engineering. Examples and exercises utilized in the course are all engineering-related, further illustrating the point that Excel is a powerful tool within the engineering field.
Course Topics.
- General Techniques related to engineering
- Data Analysis
- Functions, Analysis & Graphs including pivot tables
- Advanced Operations (Linking, Queries, Macros, Conditional Formatting
This class is taught using Excel 2010.
Learning objectives.
With excel being used so regularly within modern businesses for multiple purposes, this course will be of interest to delegates of all fields that use excel on a regular basis and wish to expand their knowledge on the programed.
Upon successful completion of this course, participants will be able to:
- Create, modify and format a spreadsheet
- Use basic formulas and functions
- Calculate and manage multiple worksheets
- Create a chart
- Customize the print settings
Course Curriculum
| Section [1] – Basics for MS Excel. | |||
| Lesson [1] – Introduction to MS Excel. | 24 hours | ||
| This lesson will show you the introduction about Excel Program. | |||
| Lesson [2] – Excel Basic Formulas. | 24 hours | ||
| This lesson will show you the basics of excel formula. | |||
| Lesson [3] – Basic Data Setting & Error protection. | 00:00:00 | ||
| This lesson will show you the basic of Data setting and Error Protection. | |||
| Lesson [4] – Copying, and Filling Tricks. | 24 hours | ||
| This lesson will show you how to make a copy and filling Tricks. | |||
| Lesson [5] – Data Sorting & Filter using. | 24 hours | ||
| This lesson will show you how to make Data Sorting and Filter. | |||
| Lesson [6] – Logical Testing Function. | 24 hours | ||
| This lesson will show you how to test as a logic Numbers. | |||
| Lesson [7] – If Function. – Part [1]. | 24 hours | ||
| This lesson will show you how to use if function part 1. | |||
| Lesson [7] – If Function. – Part [2]. | 24 hours | ||
| This lesson will show you how to use If function part 2. | |||
| Lesson [8] – Fill series & Technics. | 24 hours | ||
| This lesson will explain you how to use Fill series and technical skills you need to use it | |||
| Section [2] – Engineering Designing Systems. | |||
| Lesson [9] – Construction Inventory Management System – Part 1. | 24 hours | ||
| This lesson will show you how to design construction Inventory management System. | |||
| Lesson [10] – Construction Inventory Management System – Part 2. | 24 hours | ||
| This lesson will show you how to design construction Inventory Management System Part 2. | |||
| Lesson [11] – Construction Inventory Management System – Part 3 | 24 hours | ||
| This lesson will show you how to design construction Inventory management System Part 3. | |||
| Lesson [12] – Construction Payroll System – Part [1]. | 24 hours | ||
| This lesson will show you how to design construction payroll System Part 1. | |||
| Lesson [13] – Construction Payroll System – Part [2]. | 24 hours | ||
| This lesson will show you how to design construction Payroll System Part 2. | |||
| Lesson [14] – Construction Payroll System – Part [3]. | 24 hours | ||
| This lesson will show you how to design Construction Payroll System Part 3. | |||
| Lesson [15] – Overtime Hours Cost Calculation. | 24 hours | ||
| This lesson will show you how to calculate Overtime Hours cost calculation. | |||
| Lesson [16] – Labor Attendance System – Biometric. | 24 hours | ||
| This lesson will show you how to design Labor Attendance System using BIOMETRICS Model. | |||
| Lesson [17] – Designing Construction Schedule (Grant Chart) – Part [1]. | 24 hours | ||
| This lesson will show you how to design construction schedule. Part [1]. | |||
| Lesson [18] – Designing Construction Schedule (Grant Chart) – Part [2]. | 24 hours | ||
| This lesson will show you how to design Construction Schedule Part [2]. | |||
| Lesson [19] – Equipment Rent System. | 24 hours | ||
| This lesson will show you how you can design your Own Construction Equipment Rent System. | |||
| Lesson [20] – Construction Accident Registration form design – Part [A]. | 24 hours | ||
| This lesson will show you how to design Construction Accident Registration Form. Part A. | |||
| Lesson [21] – Construction Accident Registration form design – Part [B]. | 24 hours | ||
| This lesson will show you how to design Construction Accident Registration Form - Part [B]. | |||
| Section [2] – Engineering Design Systems. | 24 hours | ||
| This is an online assessment based exam. | |||
| Section [2] – Engineering Design Systems. | 300:05 | ||
| Section [3] - Report Preparation. | |||
| Lesson [22] – Site Monthly Expense Report. | 24 hours | ||
| This lesson will show you how to prepare Site Monthly Expense Report. | |||
| Lesson [23] – Labor Production Report. | 24 hours | ||
| This lesson will show you how to prepare Labor Production Report. | |||
| Lesson [24] – Personal Expense Report. | 24 hours | ||
| This lesson will show you how to prepare your Own expense Report. | |||
| Lesson [25] – Monthly Material Usage Report. | 24 hours | ||
| This lesson will show you how to prepare Monthly Usage Report. | |||
| Excel for Engineering Final Exam. | 24 hours | ||
| This will be an assessment exam. | |||
| Excel for Engineering Final Exam. | 1, 00:00 | ||
Course Reviews
No Reviews found for this course.