1
00:00:00,850 --> 00:00:05,500
Hey there and welcome to the Excel VBA course in this course.

2
00:00:05,500 --> 00:00:12,100
You will learn how to effectively use Microsoft's Visual Basic for applications or VBA programming language

3
00:00:12,100 --> 00:00:15,250
to enhance and automate your Excel spreadsheets.

4
00:00:15,250 --> 00:00:19,570
My name is Jillian Weiner and I'll be teaching this VBA course.

5
00:00:19,570 --> 00:00:25,360
I graduated from the University of Central Florida in Orlando with a degree in aerospace engineering.

6
00:00:25,360 --> 00:00:30,460
Upon entering the workforce I saw an immediate need my company for automating some of our more repetitive

7
00:00:30,520 --> 00:00:33,180
tedious tasks that we did in excel.

8
00:00:33,250 --> 00:00:39,760
So with my engineering background I went out and learned Microsoft's VBA to cut our 400 plus our process

9
00:00:40,120 --> 00:00:42,230
down to a 30 minute process.

10
00:00:42,340 --> 00:00:47,370
That's a ninety nine point nine percent reduction in time and thus in cost savings.

11
00:00:47,380 --> 00:00:53,740
Now I use my passion for engineering and for improvement processes to help teach others about VBA and

12
00:00:53,740 --> 00:00:58,270
how to use it effectively to get similar results in their own companies.

13
00:00:58,330 --> 00:01:04,720
As I mentioned before using VBA can result in significant time and cost savings by automating your Excel

14
00:01:04,720 --> 00:01:06,280
work and processes.

15
00:01:06,460 --> 00:01:13,240
It can also significantly reduce human error found in your files simplify long and complex Excel formulas

16
00:01:13,570 --> 00:01:19,870
and it allows you to build your own custom formulas and processes to fit your specific needs as you

17
00:01:19,870 --> 00:01:20,910
go through the course.

18
00:01:20,920 --> 00:01:26,590
I recommend you follow along in Excel I'll give step by step instructions and note places where you

19
00:01:26,590 --> 00:01:32,350
can pause the video to copy down the code and the best way to learn is by actually doing it.

20
00:01:32,350 --> 00:01:38,260
The nice thing about VBA is that it's very simple as far as programming languages go so it generally

21
00:01:38,260 --> 00:01:41,190
doesn't take people too long to catch on.

22
00:01:41,230 --> 00:01:47,740
I recommend using VBA to automate or simplify tasks that you do regularly and excel that you are already

23
00:01:47,740 --> 00:01:49,840
very familiar with to start off.

24
00:01:49,840 --> 00:01:55,270
Even if they don't need to be automated or simplified These are great practice cases since you know

25
00:01:55,300 --> 00:01:59,160
you already have all the information you need to be successful.

26
00:01:59,200 --> 00:02:04,570
I hope you're ready to jump in and start learning Visual Basic and Excel if you have any questions as

27
00:02:04,570 --> 00:02:05,320
you go along.

28
00:02:05,320 --> 00:02:06,610
Feel free to ask.