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?
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. Visual Basic for Applications is a computer programming language developed and owned by Microsoft.Â
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. 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
VBA becomes easy, once you learn its coding.Â
Writing VBA codes may seem tricky from the outside. But once you get the idea of coding, soon enough you will start generating your VBA databases.
Join this excel CPE webinar to learn how to write codes in 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