Excel: The Complete VBA Programing

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

Learning Objectives

• aTo analyze how to develop macros.
• To discuss the format worksheets.
• To inspect how to create an interactive worksheet.
• To investigate work with multiple worksheets.
• To discuss how to perform calculations.
• To understand the basics of VBA language
• To understand properties window and user forms
• To learn the functions procedures and code modules.
• To understand how to write VBA codes
• To understand the common mistakes to be avoided while writing VBA codes
• To learn the logic of VBA
• To understand the important tools of VBA
• To learn how to use the VBA tools
• To learn the basics of VBA loops
• To understand various VBA loop statements
• To learn different types of VBA loops

Recommended For

• This excel CPE course is recommended for CPAs, CMAs, CIAs, CFAs, Accounting, and Tax Professionals, and Staff of Accounting or Tax Firm desiring to master VBA.
• This excel CPD course will prove beneficial for Canadian CPAs, Accounting and Tax Professionals, and Other Professionals using excel for their daily tasks.

Who Should Attend?

Webinar Qualifies For

• 3 CPE Credit for Qualification in Internal Audit Leadership (QIAL)
• 3 CE Credit for Maryland Tax Preparer (MRTP)
• 3 CPE Credit for Internal Audit Practitioner (IAP)
• 3 CPD Credit for Chartered Professional Accountant (CPA Canada)
• 3 PL Credit for Chartered Financial Analyst (CFA)
• 3 CPE Credit for Certified Valuation Analyst (CVA)
• 3 CPE Credit of Computer Software and Applications for Certified Public Accountants (CPA-US)
• 3 CPE Credit for Certified Management Accountants (CMA)
• 3 CPE Credit of Accounting & Auditing for Certified Internal Auditors (CIA)

FAQs content