Course Description
Excel is one of the most widely used spreadsheet programs in the world.Â
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.Â
Sometimes, some of the Excel tasks look redundant and take a lot of your time.Â
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 course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel.
Excel VBA is Microsoft’s programming abo 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.Â
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
Join this Excel CPE Webinar to understand VBA to create macros for automating repetitive tasks in Excel.