Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 6 Minute(s)
Language
English
Taught by
Infinite Skills
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Master Visual Basic for Excel, learn to unlock the true power of Excel. Tutorial Taught by a leading Microsoft Expert
A Verifiable Certificate of Completion is presented to all students who undertake this course.
In this Visual Basic for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.
The tutorial extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This Visual Basic for Excel tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.
By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn Visual Basic for Microsoft Excel in this video tutorial.
Course Content
- 12 section(s)
- 90 lecture(s)
- Section 1 Getting Started
- Section 2 Macros
- Section 3 Procedures And Functions
- Section 4 Getting Started With VBA Programming
- Section 5 Manipulating Excel Objects
- Section 6 Working With Excel VBA Functions
- Section 7 Controlling Program Flow And Execution
- Section 8 Events
- Section 9 Debugging And Error Handling
- Section 10 Interacting With Users Through Forms
- Section 11 Running And Storing VBA Code
- Section 12 Summary
What You’ll Learn
Skills covered in this course
Reviews
-
GGilles Monette
Well explained and a good rhythm for the course. Enjoy the way it is presented. Also go through a lot of stuff and i guess now is practice Well done thanks.
-
BBrent Neppl
Pace of course suits my learning very well, and no presumed knowledge has seeped in. The example workbooks meant I could work alongside, by pausing the lectures, and checking my code back to paused screen. Thanks Guy
-
LLinda Haniford
I had never gotten a chance to learn how to do forms with Excel and although I had previously taken a VBA class I was confused as to where the code was supposed to go. Very clear instruction. Much thanks to the instructor-I wouldn't mind if he also would do a class on how to get parse text in Word into Tables and then place that into Excel and/or Access and to explain when it's better to leave information in Word/Excel/ or Access. Maybe a VBA class on how to change the look of Outlook would be good as well. Also how to get the most out of Outlook. Right now I use Yahoo but if I could get Outlook to look like Yahoo that would be great.
-
ZZain Nazir
The course teaches only basic stuff. It does not teach via real life problems like opening a text file etc. such common functions should be taught in the course. otherwise it is good.
