Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 52 Minute(s)
Language
English
Taught by
Manish Narayan
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
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!
Course Content
- 5 section(s)
- 61 lecture(s)
- Section 1 Visual Basic for Applications (VBA)
- Section 2 Programming Details of VBA
- Section 3 Object-Based VBA
- Section 4 Useful Properties and Methods
- Section 5 Project Control
What You’ll Learn
- 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)
- Develop VBA Functions and Sub Procedures
Skills covered in this course
Reviews
-
RRobert Taylor
Good and clear explanation of material with examples
-
GGlenn Estelle
This is a great introduction to the tools within Excel vba. It doesn't include any projects that will help get you proficient at coding, but there are examples for everything that can serve as reference as you skills develop.
-
NNaveen S N
Extremely good narration and examples for demonstration
-
SSimone Agostinelli
It has been an useful course to learn how to program VBA, but has nothing to do with engineering applications making. I would suggest the introduction of more examples about the use of this application to solve engineering problems.
