ENGINEERING ANALYSISWITH VBA
Get the simple step-by-step system to make you an expert at quickly solving complex engineering problems with VBA in Excel.
Engineers: Are You Tired of Reinventing
the Wheel Every Time you Open Excel?
If there is such a thing as a “universal” tool in engineering, it can ONLY be Excel. After all, it is THE go-to tool for engineering calculations when no other software will get the job done, or when you just need to be able to share your work with anyone.But a universal analysis tool requires tedious, meticulous setup. That’s because the last thing you need is a million-dollar error in the final design that’s your fault.So, you spend hours upon hours, typing formulas and selecting cells.Checking. Troubleshooting. Testing.At night you lay awake wondering if there might be a mistake in that formula you entered today for the 957th time in your career: “Did I type (B2+B3)*B4 or was it (B2 + B3*B4)?”And when that project or task is done? You move on to the next one and repeat the process all over again, retyping each of the calculations you so painstakingly entered 957 times before.And so it goes…Hour after hour (50… 60… 80 hours per week)Day after day (Vacation? What vacation?)Plodding through boring, difficult, and repetitive calculations and re-inventing the wheel on every single spreadsheet.
Does this sound familiar to you?
You know that you could use VBA to create custom functions, tools, and programs in Excel so that you could boost your efficiency by automating repetitive calculations (and avoiding errors in the process).You also know VBA and Excel can be combined to create a powerful tool for engineering that would enable you to do things that can’t be done in a typical spreadsheet. But you are intimidated by VBA and lack the confidence and skills to put it to use.You’ve read forums, searched Google, and watched hours of YouTube videos. But no one can show you how to use VBA for engineering analysis and you certainly don’t have the time to piece it all together yourself.
BOTTOM LINE: You are so busy trying to get work done that you don’t have time to learn how to do it better.
What if you could use VBA to harness the full power of Excel?
If you understand how to use VBA to fully leverage the capabilities of Excel for engineering, you will be able to create custom functions and programs to handle your most complex engineering problems with ease.You will be able to automate repetitive calculations and tasks so you can eliminate boring manual work. You will supercharge your efficiency so you can accomplish more with less effort.You can increase the capabilities of Excel for engineering so you can model complex systems without specialized software. Finally, your VBA skills will enable you to succeed in your engineering career. By learning how to use VBA for engineering calculations and other tasks, you will gain the programming and analysis skills that more than 61% of today’s engineering jobs require.
Introducing Engineering Analysis with VBA
Engineering Analysis with VBA is the simple step-by-step system to make you an expert at quickly solving complex engineering problems with VBA in Excel.
What do you get when you enroll?
Engineering Analysis with VBA will jumpstart your success at creating custom engineering tools and automating your repetitive calculations in Excel using VBA. There’s no information overwhelm and no unnecessary theory; just a practical system for learning the ins and outs of VBA for engineering numerical analysis.
Engineering Analysis with VBA is a Focused System for Learning VBA for Engineering
- Short and effective step-by-step online videos that you can watch (and rewatch!) no matter how much time you have available in your schedule.
- A practical approach that won’t waste your time with unnecessary theory.
- Capability to pick up wherever you leave off because the online course software automatically tracks progress for you.
- 24/7 access from any internet-connected device or download the videos to watch on-the-go.
- Lifetime access to watch the videos as many times as you want.
- A 110% 365-Day Money Back Guarantee
“I’m blown away by your teachings. Thank you so much!” – Jeremy P.
The Detailed Framework of Engineering Analysis with VBA
Engineering Analysis with VBA is made up of seven distinct modules. Each one makes up a piece of the frameworkthat you need to solve almost any engineering problem with VBA.
Module 1: VBA Fundamentals
To begin automating engineering calculations and creating custom engineering tools with VBA, it is essential to understand the fundamentals. In this module you will learn how to: • Create customer engineering tools using VBA subroutines and functions• Read data from a worksheet to VBA or write from VBA to a worksheet• Use loops and conditional statements to add automatic iteration and decision-making to your procedures• Successfully use VBA arrays: declare, fill with values, read values, and everything else!• Build flexibility into procedures so they can be re-used without modifying for each unique situation
Module 2: Root Finding and Equation Solving
Every field of engineering has a unique set of problems that can be solved quickly by using root-finding methods. In this module, you will be introduced to several techniques for solving equations. You’ll learn how to:
• Solve equations when the bounds of the roots are known using stable and reliable methods in VBA• Quickly find roots using special methods when speed is critical
Module 3: Linear Algebra
Many systems in engineering can be described by linear equations. For those systems, engineers can use linear algebra to solve the equations. This module will teach you how to:
• Create matrices via code in VBA or from the worksheet
• Multiply matrices without errors in VBA
• Solve systems of linear equations
Module 4: Optimization
Ensuring that designs are optimal is an important aspect of an engineer’s responsibilities. That’s why finding inputs that can maximize or minimize a result is the core focus of this module. You will learn how to:
• Maximize or minimize a function in a single variable with a quick and easy procedure
• Find globally-optimum results for complex multi-variable optimization problems with a robust algorithm
• Ensure that unrealistic results are ignored by applying constraints
Module 5: Curve Fitting
When raw data is not enough to solve a particular problem, engineers need to be able to fill in the “gaps”. This module will teach you how to:
• Fit an equation to data using regression
• Accurately estimate data between known points with cubic spline interpolation
Module 6: Integration and Differentiation
Being proficient at calculus is a fundamental requirement for successful engineering problem solving. Thankfully, we can let a computer do the hard work and avoid the hard work of solving these problems by hand! This module will teach you how to:
• Easily find the integral of a table of data by creating a program that chooses the best integration method for the application
• Calculate highly accurate integrals for equations by creating an algorithm that adapts to the characteristics of the equation
• Determine the derivative of data with the highest accuracy possible with an automated, flexible procedure
Module 7: Ordinary Differential Equations
Having the ability to solve systems of ordinary differential equations opens up a world of possibilities for simulation and advanced modelling with VBA. In this module you will learn how to:
• Solve an ordinary differential equation with VBA procedures
• Ensure that the ODE solution is accurate by managing the parameters of the program
• Model complex systems by expanding the software to solve systems of many differential equations
You’ll also learn…
Throughout the course you will also learn essential VBA techniques for engineers such as:
• Creating and modifying charts using VBA• Extracting columns and rows from large arrays• Sorting data with VBA• Preventing and handing errors
Engineering Analysis with VBA is a Focused System for Learning VBA for Engineering
Unlike one-off videos or web pages that lead down a rabbit trail of overwhelm and confusion, the course will provide a clear path so you can learn to create custom engineering tools and automate your calculations with VBA in less time than you ever thought possible.The online, self-paced course is a step-by-step system that will make you an expert at quickly solving complex engineering problems with VBA in Excel.When you enroll in Engineering Analysis with VBA you’ll get:
- Short and effective step-by-step online videos that you can watch (and rewatch!) no matter how much time you have available in your schedule.
- A practical approach that won’t waste your time with unnecessary theory.
- Capability to pick up wherever you leave off because the online course software automatically tracks progress for you.
- 24/7 access from any internet-connected device or download the videos to watch on-the-go.
- Lifetime access to watch the videos as many times as you want.
- A 110% 365-Day Money Back Guarantee
“Your presentation style is outstanding…the best I’ve seen for video-based courses.” – Duff H.
Get These Exclusive Bonuses When You Join Engineering Analysis with VBA
Numerical Analysis VBA Code Library
Avoid Matlab by using VBA instead. With a library of ready-to-use numerical analysis procedures for VBA, you can get to work right away creating customized engineering applications in Excel without expensive software.
$2150 value
Certificate of Completion
When you’ve completed the course, you can download a personalized certificate of completion. You can hang it in your office, display it on your LinkedIn profile, or use it as documentation of professional development hours (PDH) for your engineering licensure (in most states).
$210 value
Case Studies from Mechanical, Electrical, Civil and Environmental Engineering
Each module contains case studies from mechanical, civil, and electrical engineering. You’ll see how the numerical analysis techniques you are learning can be applied to real-world engineering problems.
$147 value
Get My Secrets to Engineering Success with VBA
Charlie Young
Licensed Professional Engineer and Founder of engineerexcel.com
Hi there! I’m Charlie Young, a licensed Professional Engineer and founder of EngineerExcel.com.I’ve helped millions of engineers around the world solve challenging engineering problems with Excel through my website and have had the privilege to instruct engineers at world class companies like Dell, Marathon Petroleum, DuPont, Con Edison, and more. I’ve had success with Excel for engineering because I learned to use VBA to maximize Excel’s capabilities.But it hasn’t always been that way.At first, I was intimidated by VBA. Sure, I could hold my own in the spreadsheet interface, but I knew that there was so much more capability to be gained in Excel by using VBA. One day I struggled my way through creating a simple VBA function that simply automated a calculation I had always entered in a cell manually. Trust me, it wasn’t pretty. The function broke a lot of “programming rules” and certainly had bugs. But it drastically decreased the time it took to perform the calculation. When other engineers on my team were reaching for their calculators or manually re-typing a complex formula in a spreadsheet, I simply called my custom function and got an accurate answer in seconds.From then on, my relationship with Excel completely changed. I was no longer intimidated by VBA. Instead, I saw it as a powerful tool for creating custom programs that could model complex systems and automate repetitive calculations to increase my productivity. Oh, and it cut down significantly on errors, too.Since creating that first function, I’ve gone on to create hundreds of other custom VBA programs that have saved months of development effortand performed thousands of analyses that wouldn’t have been possible without the benefit of automation through VBA. Understanding VBA has enabled me to create award-winning engineering models and develop patented systems. And now, for the first time ever, all that knowledge has been condensed into a step-by-step system that will make you an expert at quickly solving complex engineering problems in Excel with VBA.
Trusted by Engineers at the World’s Best Organizations
Christian Andersson
Process Engineer
Thank you very much for an awesome course. You have really managed to fit a tremendous amount of tips, techniques, and productivity boosts into the training. I very much enjoyed it and some of the tools are true game changers and applications that I have really been wanting for a looong time. Also I think it is super-nice that almost every lessons can be applied to your work directly. Finally, great that you use applications from various fields of engineering and not just your own specialty. It makes the training accessible for both electrical, mechanical and chemical engineers. So, thank you! I will make good use of the knowledge you have shared!
Mike K.
Simulation Engineer
The course is fantastic. I’ve been using Excel for years and have picked up things here and there that I’ve used, but this course takes all of them and adds tons of new tricks, and then connects all of the dots to paint a coherent picture of how I can use Excel as a powerful engineering tool. In college I never really learned how powerful Excel could be for engineering calculations. Thank you for this course, it has revolutionized the way I set up, perform, and document my work!
Derek D.
Design Engineer
After working through the program, I gained confidence with advanced functions and know that I will increase productivity when doing various calculations for projects at work. The progressive format gave me the ability to work at my own pace. Course content is delivered in a way that is easy to understand and apply, and the option to work alongside the videos in excel worksheets makes it a hands-on learning experience.
Thamer K.
Design Engineer
I must say that you condensed years of Excel experience into brief and effective videos which can be quickly understood and quickly-if not immediately- applied to real-world Excel worksheets. The examples are clear, concise and easy to follow-which makes the course enjoyable and insightful. Kudos for eloquently and concisely putting together an effective course!
Jamison H.
Design Engineer
Taking the course showed me how many useful tools and features in Excel that I was not using or not using to their full potential. The videos walked me through the fundamentals and shortcuts up through the most complicated parts of Excel. The instructor is very concise and easy to understand while the on-screen key guides make sure you know what is being typed on the keyboard. Overall I thought the videos were amazing and I learned a lot of things in Excel that I didn’t know existed or how I was half using the tools wrong. I would recommend these videos to any level user of Excel!
*Engineering Analysis with VBA is a new course. These testimonials are from students in other EngineerExcel courses.
Is Engineering Analysis with VBA right for you?
If you want to keep getting the same results you always have, enjoy doing manual repetitive work, are OK with the potential for introducing errors in every new spreadsheet you create, or prefer to spend 80 hours on a project that could be done in 20, then this course is probably not for you.
But if any of the following ARE true, then Engineering Analysis with VBA is for you :
You need to create custom engineering tools in Excel like custom functions, programs, or calculators
You need to automate repetitive calculations or tasks so you can eliminate repetitive manual work
You need to increase the capabilities of Excel for engineering so youcan model complex systems without specialized software
You need to create custom engineering tools in Excel like custom functions, programs, or calculators
You need to increase efficiency so you can accomplishmore with less effort
You are self-motivated and ready to learn new things
You want to expand your skills and succeed as an engineer
No matter your engineering field, Engineering Analysis with VBA will give you the tools you need to succeed:
Save with this Exclusive Limited-Time Offer When You Join Engineering Analysis with VBA Today
Save US$ 500 off the regular price when you join Excel Master Class for Engineers during this special limited-time offer. You’ll receive everything listed below (a US$ 3300 value) for as low as one payment of US$ 297. To get started, please choose a payment option below and click “ENROLL NOW”.
SAVE 20%!
$797 US
One Time Payment
- 7 Step-By-Step Video Learning Modules
- 3 Free Bonuses (worth $2507)
- LIFETIME 24/7 Access
- 110% 365-Day Guarantee
$327 US
3 Monthly Payments
- 7 Step-By-Step Video Learning Modules
- 3 Free Bonuses (worth $2507)
- LIFETIME 24/7 Access
- 110% 365-Day Guarantee
- SECURE CHECKOUT
- 110% 365-DAY GUARANTEE
Get the Skills You Need to Master VBA for Engineering
Even if you are short on time, Engineering Analysis with VBA will flatten the VBA learning
curve and jumpstart your success so you can:
Automate routine calculations in Excel
Create custom engineering tools
Accomplish more without working more
Increase your confidence in VBA
Eliminate errors in your calculations
Succeed in your engineering career
Answers to Your Questions About Engineering Analysis with VBA
Will I receive any physical products?
Engineering Analysis with VBA is a 100% digital course. Because it takes place online, you have the flexibility to login 24/7 via your username and password to learn on your own schedule and at your own pace.Need to be offline? All the materials (videos, spreadsheets, etc.) are downloadable for you to consume and learn offline as well.
Can I download the videos and all the other bonuses?
I care about your success and feel that it is most important for you to have the flexibility to learn on your own terms. Therefore, all materials (videos, spreadsheets, handouts, course manuals, etc.) are downloadable for you to consume and learn when you need to be offline such as while travelling, etc.
How long does it take to go through the course?
Everyone’s pace is different, but you should plan approximately 8-10 hours to complete the entire course. With 24/7 access you can do it all at once or little by little as you have time.
When does the program start and finish?
Engineering Analysis with VBA is a self-paced, 100% digital course. After making your secure purchase, you’ll create a password and be granted access automatically so that you can start learning IMMEDIATELY or whenever it is convenient for you.Further, you’ll have LIFETIME access to the materials so you can come back and review any topic as often as you need for life.
What exactly do I get with the course?
Great question. As soon as you purchase, you will get immediate access (via user name and password) to the entire Engineering Analysis with VBA program:•Lifetime access and login 24/7 (it is all digital + downloadable so you can login to access the content & download the course to take it with you on the go)•Self-paced and conforms to your busy schedule.•Content is available in video format
You get:•7 Step-By-Step Video Modules•3 Added Bonuses
Bonuses:Numerical Analysis VBA Code Library (a $2150 value)Avoid Matlab by using VBA instead. With a library of ready-to-use numerical analysis procedures for VBA, you can get to work right away creating customized engineering applications in Excel without expensive software.Certificate of Completion (a $210 Value)When you’ve completed the course, you can download a personalized certificate of completion. You can hang it in your office, display it on your LinkedIn profile, or use it as documentation of professional development hours (PDH) for your engineering licensure (in most states). Case Studies from Mechanical, Electrical, Civil and Environmental Engineering (a $147 Value)Each module contains case studies from mechanical, civil, and electrical engineering. You’ll see how the numerical analysis techniques you are learning can be applied to real-world engineering problems.
Do I get access to everything all at once or do I have to wait?
Yes, you get access to everything right away (except for the Certificate of Completion, of course!). You can consume the material at any pace you want, although staying in order is recommended.
Is Engineering Analysis with VBA really step-by-step?
Absolutely! There is no guesswork whatsoever. Just follow the system.
What if I buy and want a refund? What’s the policy?
I pride myself on high quality products. You’ll have 365 days to evaluate the course. If, during that time, you are unhappy for any reason, just email and let me know. You will receive a full refund plus an ADDITIONAL 10%. You can keep the spreadsheets and any other downloaded material as my free gift.
I have a question, who should I ask?
You can send an email directly to: support (at) engineerexcel.com and we will be happy to help you out.
Do I get lifetime access?
Yes, you’ll have lifetime access to the materials so you can come back and review any topic as often as you need for life.
“Your course is well worthwhile and continues to assist me when using Excel for scientific purposes.” – Victor C.
There is Absolutely ZERO RISK When You Purchase Engineering Analysis with VBA
You can be confident with a 110% 365-day guarantee.
SAVE 20%!
$797 US
One Time Payment
- 7 Step-By-Step Video Learning Modules
- 3 Free Bonuses (worth $2507)
- LIFETIME 24/7 Access
- 110% 365-Day Guarantee
$327 US
3 Monthly Payments
- 7 Step-By-Step Video Learning Modules
- 3 Free Bonuses (worth $2507)
- LIFETIME 24/7 Access
- 110% 365-Day Guarantee
- SECURE CHECKOUT
- 110% 365-DAY GUARANTEE
© engineerexcel.com
