Hey there and welcome to the Excel VBA course in this course.
You will learn how to effectively use Microsoft's Visual Basic for applications or VBA programming language
to enhance and automate your Excel spreadsheets.
My name is Jillian Weiner and I'll be teaching this VBA course.
I graduated from the University of Central Florida in Orlando with a degree in aerospace engineering.
Upon entering the workforce I saw an immediate need my company for automating some of our more repetitive
tedious tasks that we did in excel.
So with my engineering background I went out and learned Microsoft's VBA to cut our 400 plus our process
down to a 30 minute process.
That's a ninety nine point nine percent reduction in time and thus in cost savings.
Now I use my passion for engineering and for improvement processes to help teach others about VBA and
how to use it effectively to get similar results in their own companies.
As I mentioned before using VBA can result in significant time and cost savings by automating your Excel
work and processes.
It can also significantly reduce human error found in your files simplify long and complex Excel formulas
and it allows you to build your own custom formulas and processes to fit your specific needs as you
go through the course.
I recommend you follow along in Excel I'll give step by step instructions and note places where you
can pause the video to copy down the code and the best way to learn is by actually doing it.
The nice thing about VBA is that it's very simple as far as programming languages go so it generally
doesn't take people too long to catch on.
I recommend using VBA to automate or simplify tasks that you do regularly and excel that you are already
very familiar with to start off.
Even if they don't need to be automated or simplified These are great practice cases since you know
you already have all the information you need to be successful.
I hope you're ready to jump in and start learning Visual Basic and Excel if you have any questions as
you go along.
Feel free to ask.