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
Requirements
- Must have Microsoft Office Excel 2007, 2010, 2013, or 2016 installed
Description
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!
Who this course is for:
- Students, Adults, Professionals, Educators
Course content
- Preview04:14
- 03:28VBA: The programming language
- 10:19The VBA Environment
- 01:26Modules in VBA
- 17:50Procedures and Module Layout
- 08:02Functions (UDF: User Defined Functions)
- 08:50Sub Procedures
- 03:04Accessing Online VBA Help
Instructor
![Manish Narayan](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 4,687 Reviews
- 28,480 Students
- 13 Courses
Professor Manish Narayan had a passion for teaching since an early stage in his career and his vision is to share his wealth of knowledge and subject matter expertise with all students and professionals at any level across universities and companies world wide.
An educational background in Mathematical Physics (B.S.), Aerospace Engineering (M.S.) coupled with years of Software Architecture and Development, Professor Narayan currently lectures as a Professor of Mechanical Engineering, has taught various technical seminars at Fortune 100 companies including General Motors, Lockheed Martin, The Aerospace Corporation, and U.S. Air Force