IIRF Online > Office Productivity > Microsoft > Excel VBA > Certified Advanced Excel, Macros and VBA Professional
Certified Advanced Excel, Macros and VBA Professional by Vskills
Course Highlights
- Government certification
- Certification valid for life
- Lifelong e-learning access
- Learning Hours: 31 hrs
- Life Time Job Support
- Job Profile Tagging
Skills you will learn!
Curriculum
7 Topics
Workbook and Worksheet
Manipulating Data
Worksheet Formatting
Page Properties and Printing
Excel Formulas
Sort and Filter
Charts
7 Topics
Excel Cell Referencing
Excel Functions
Excel Formulas
Working with Ranges
The VLOOKUP function
Pivot Table
Advanced Excel Filter
12 Topics
VBA Basics
Variables Comments Constants and Data Types
Visual Basic Arrays
VBA Conditional Statements
VBA Loops
VBA objects
Subroutines
Functions
Labels and the On Error statement
VBA and Excel functions
Excel Objects
Excel Events
8 Topics
Recording a Macro
Perform the Macro
Running a Macro
Change macro security settings
Copy a macro module to another workbook
Copying a module from one workbook to another
Assign a macro to a Form or a Control button
Macro Virus Protection
Certified Advanced Excel, Macros and VBA Professional
Related Excel VBA Courses
Thank You!
Your review has been submitted successfully.