課程資料
- 可獲發
- *證書的發放與分配,依課程提供者的政策及安排而定。
課程簡介
Spreadsheet Engineering
Transform Microsoft Excel into a Spreadsheet Engineering environment!
Are you a student or professional in the field of engineering, finance, management, or science and have not been able to utilize Excel to its fullest potential to setup, model and solve real-world problems? Don't worry as THIS IS THE COURSE FOR YOU!
Microsoft Excel is everywhere, at your home, university campus, or even at the workplace, but most users only utilize the basic functionality, rely on unstructured worksheets, and forget about the powerful tools that Excel is built upon.
In my course, I will teach you how to transform Excel into a spreadsheet engineering environment making use of structured worksheet designs, Visual Basic for Applications ("VBA"), complex spreadsheet function combinations, and best practices that will not only make your life easier when dealing with information/data but allow you to tackle those real-world problems whether at home, school, or in the professional field.
Take this course and show the world your transition from Excel User to Excel Engineer!
課程章節
- 6 個章節
- 37 堂課
- 第 1 章 Introduction
- 第 2 章 Introduction to Excel Engineering
- 第 3 章 Excel Engineering Data and Analysis
- 第 4 章 Structured Spreadsheets
- 第 5 章 Visual Basic for Applications (VBA)
- 第 6 章 Excel Engineering Optimization
課程內容
- Transform Excel into an engineering tool that will help solve real world problems in various industries
- Gain knowledge in Excel and Visual Basic for Applications (VBA)
- Create Structured Spreadsheet Designs
- Develop VBA Functions and Sub Procedures
- Expand the role of spreadsheets to improve processes
- Utilize Excel Engineering for Optimization and Uncertainty Analysis
- Introduce UserForms and User Controls for overall Project Control
此課程所涵蓋的技能
評價
-
MMebrahtu EMBAYE
Well structured tutorial that covers the content of the course and clearly explained benefits of being expert in excel as an engineer from real world engineering prospective.
-
GGlenn Estelle
Excellent class. I found the format easy to follow and the information directly applicable to my own Excel workbooks. I work in engineering and use Excel for calculating machine mass property characteristics.
-
CChrysante MOURE ENGONE
Wonderful, I'm really impressed by the course. It's clear and really feel ingeneering. I like it too much. Well explained. Easy to understand.
-
SSimone Agostinelli
I expected more advanced examples, but for student with a LOWER than BASIC knowledge of Excel is a nice and well structured course. Hope for more advanced examples in the 2nd part