1
00:00:01,120 --> 00:00:05,170
Congratulations on completing the Excel VBA course.

2
00:00:05,260 --> 00:00:11,230
You now have the fundamental knowledge you need to write and execute VBA code to automate and enhance

3
00:00:11,230 --> 00:00:12,580
your Excel files.

4
00:00:12,730 --> 00:00:17,190
In this course we learned about what VBA is and how to use it.

5
00:00:17,200 --> 00:00:23,770
We've covered the basics of VBA which included variables arrays and routines and we covered basic objects

6
00:00:23,770 --> 00:00:29,920
in VBA while talking about file interactions which included the object hierarchy and the worksheet workbook

7
00:00:29,980 --> 00:00:31,570
and table objects.

8
00:00:31,630 --> 00:00:37,720
We cover the basic manipulators for math and string type variables as well as how to pass those variables

9
00:00:37,720 --> 00:00:40,090
between routines as arguments.

10
00:00:40,180 --> 00:00:46,270
We talked about loops with and with and if statements which are common concepts in all computer coding

11
00:00:46,870 --> 00:00:50,530
we covered how to build and use forms to enhance your user interface.

12
00:00:50,840 --> 00:00:55,990
And we talked about speeding up your code as well as debugging and testing your code to find and handle

13
00:00:55,990 --> 00:00:56,980
errors.

14
00:00:56,980 --> 00:01:01,960
Lastly we covered some more advanced topics like custom functions and events.

15
00:01:01,960 --> 00:01:05,880
This all begs the question What can you do now moving forward.

16
00:01:05,890 --> 00:01:11,530
The best thing you can do to develop your knowledge is to practice using it automate files you've already

17
00:01:11,530 --> 00:01:13,500
built that you're already familiar with.

18
00:01:13,510 --> 00:01:19,020
Ask yourself what aspects of your existing Excel files might have a cleaner user interface.

19
00:01:19,030 --> 00:01:25,240
If you use a form or if you could simplify long and complicated formulas by creating a custom function

20
00:01:25,690 --> 00:01:31,810
and of course always remember that nothing is impossible with excels VBA so you may be able to automate

21
00:01:31,810 --> 00:01:36,090
things you couldn't before or build capabilities that you couldn't before.

22
00:01:36,100 --> 00:01:40,080
Don't forget these reference sites as you go along in case you hit a bump in the road.

23
00:01:40,210 --> 00:01:46,450
Microsoft's help site is great at explaining VBA functions and object types and Stack Overflow is a

24
00:01:46,450 --> 00:01:51,250
community resource for answering specific questions or helping find code errors.

25
00:01:51,250 --> 00:01:57,190
Of course there are hundreds of helpful sites and references so when in doubt you can always try googling

26
00:01:57,190 --> 00:01:58,960
whatever it is you're having trouble with.

27
00:02:00,620 --> 00:02:03,310
Thanks for checking out this Excel VBA course.

28
00:02:03,320 --> 00:02:08,660
You are now ready to take your newfound knowledge back to your work or school or personal Excel files

29
00:02:08,900 --> 00:02:10,790
to automate and enhance them.

30
00:02:10,790 --> 00:02:11,510
Best of luck.