Certified Advanced Excel, Macros and VBA Professional
- Offered byVSkills
Certified Advanced Excel, Macros and VBA Professional at VSkills Overview
Total fee | ₹3,499 |
Mode of learning | Online |
Credential | Certificate |
Certified Advanced Excel, Macros and VBA Professional at VSkills Highlights
- Government certification
- Certification valid for life
- Lifelong e-learning access
- Learning Hours: 31 hrs
- Get tagged as 'Vskills Certified' On Monsterindia.com
- Get tagged as 'Vskills Certified' On Shine.com
Certified Advanced Excel, Macros and VBA Professional at VSkills Course details
- The certification benefits managers, supervisors, executives and those responsible for using Excel for data collection, analysis and reporting activities and looking for a better role by proving their employers the value of their skills through this certification.
- It also benefits students wanting to improve their skill set and make their CV stronger
- The certification helps build your CV and acts as an additional qualification that significantly improves your chances of getting the desired role
- Vskills certification on Advanced Excel, Macros and VBA focuses on developing and certifying students skills in Microsoft Excel, VBA and Macros
- The certification helps professionals to not only increase their understanding of advanced concepts of Excel but also on Macros and VBA
- This Course is intended for professionals and graduates wanting to excel in their chosen areas
- It is also well suited for those who are already working and would like to take certification for further career progression
Certified Advanced Excel, Macros and VBA Professional at VSkills Curriculum
MS-Excel Basics
Workbook and Worksheet
Manipulating Data
Worksheet Formatting
Page Properties and Printing
Excel Formulas
Sort and Filter
Charts
Advanced Excel
Excel Cell Referencing
Excel Functions
Excel Formulas
Working with Ranges
The VLOOKUP function
Pivot Table
Advanced Excel Filter
VBA
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
Macros
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
Other courses offered by VSkills
Student Forum
Anything you would want to ask experts?