Vskills Certified Advanced Excel, Macros and VBA Professional (Govt. Certification) A GoI and GNCTD



Enroll Now

What is this course about

1. MS-Excel Basics
1.1 Workbook and Worksheet
1.2 Manipulating Data
1.3 Worksheet Formatting
1.4 Page Properties and Printing
1.5 Excel Formulas
1.6 Sort and Filter
1.7 Charts

2. Advanced Excel
2.1 Excel Cell Referencing
2.2 Excel Functions
2.3 Excel Formulas
2.4 Working with Ranges
2.5 The VLOOKUP function
2.6 Pivot Table
2.7 Advanced Excel Filter

3. VBA
3.1 VBA Basics
3.2 Variables, Comments, Constants and Data Types
3.3 Visual Basic Arrays
3.4 VBA Conditional Statements
3.5 VBA Loops
3.6 VBA objects
3.7 Subroutines
3.8 Functions
3.9 Labels and the On Error statement
3.10 VBA and Excel functions
3.11 Excel Objects
3.12 Excel Events

4. Macros
4.1 Recording a Macro
4.2 Perform the Macro
4.3 Running a Macro
4.4 Change macro security settings
4.5 Copy a macro module to another workbook
4.6 Copying a module from one workbook to another
4.7 Assign a macro to a Form or a Control button
4.8 Macro Virus Protection

What are the course deliverables ?

• Post registration get login credentials of your online profile for exam scheduling
• Access e-learning online LMS and online practice tests
• Receive hard copy reading material
• Post preparation, schedule exam date and exam center from your online profile within one year of order date.
• Clear the exam and get hard copy and soft copy certificate with LinkedIn recommendation and tagging on MonsterIndia.com and Shine.com

Program Schedule

• Self paced learning
• Query resolution in online e-learning LMS.
• Exam held every month.
• Prepare and appear for certification exam within one year

Program Highlights

Benefits of Vskills Certification
• Government certification
• Tagging on MonsterIndia.com and Shine.com for more visibility amongst employers
• No Minimum educational qualification
• No time commitment
• Improve employability
• Certification valued and approved by Industry
• Become a part of Vskills Job centre for life
• Enriched professional experience by being a Vskills Alumni

Desired Course Seeker Profile

• No minimum eligibility
• No experience needed