Course Details


Course Name: Excel Micro Learning VBA
CPD Hours: 1
Type: Online/Video
Price: $60 $54


Description:
This course goes over Excel Micro Learning VBA.

This is an area that CPAs in both public practice and industry come across.

Overview:
- Tips and Techniques


Topics:
What is VBA?
How to Enable VBA in Excel
What a Macro is
How to Make a Macro
Create Command Buttons
Add Macros to the Toolbar
Running a Macro Without a Command Button
Absolute v Relative Macros
If Then Statements
Select Case Functions
Tax Rate Functions
Create Message Boxes
Create Message Box Functions
Create Input Boxes
Ordering Objects in VBA
Create a Case Specific Calculator
Modify Charts with Macros
Create a Range Object
Dynamic Range Macros
Change Fonts
Loops






Screenshots