Course Description
There are several spreadsheet programs but from all of them, Excel is most widely used.Â
People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. The best part about Excel is, it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence.
Have you ever wanted to learn how to automate Excel so that even the most complex functions can be achieved quickly and simply?
Are you facing a repetitive cleanup of fifty tables in Word?Â
Do you want a particular document to prompt the user for input when it opens?Â
Are you having difficulty figuring out how to get your contacts from Microsoft Outlook into a Microsoft Excel spreadsheet efficiently?
A few of you must have backed off from trying VBA thinking that it involves difficult coding and structuring requirements. Well, here, we will learn how to work with VBA the best way!
Using a step-by-step approach, this highly popular CPE course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel.
Excel VBA is Microsoft’s programming for Excel and all the other Microsoft Office programs, like Word and PowerPoint. The Office suite programs all share a common programming language. While users cannot directly manipulate the main Excel software through VBA, they can, however, master the art of making macros to optimize their time in Excel.
To access the VBA window, press Alt + F11 within any Office program. When done properly, this will open a window with a file structure tree on the top left, properties on the bottom left, a debug pane at the bottom center and bottom right, and the coding section that takes up the majority of the screen in the center and top right.Â
This may seem overwhelming at first, but in reality, it’s simpler than it appears and this CPE webinar will help you with that. This CPE course is ideal for those with a good knowledge of MS Excel and would like to add additional functionality, with no programming knowledge.Â
With VBA you can create macros to automate repetitive word- and data-processing functions, and generate custom forms, graphs, and reports. VBA functions within MS Office applications; it is not a stand-alone product
The real power in programming comes from the options that you have to determine which lines of code to execute, based on one or more conditions that you specify. You can extend those capabilities even further when you can repeat an operation many times.Â
Join this excel CPE webinar to learn everything you need to know about VBA.
It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover in this CPE webinar will work similarly in Excel for PC and Mac