Online
- Duration / Course length: 1 To 2 Months Start now
- Certificates:
- Course delivery: This course is delivered in video format
Course details
Excel is the de-facto software used for data collection, analysis and reporting across organizations. It has wide spread usage due to programmatic and automation features like Macros and VBA.
Vskills certification on Advanced Excel, Macros and VBA focuses on developing and certifying your 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.
Why should I take Advanced Excel, Macros and VBA certification?
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. The certification helps build your CV and acts as an additional qualification that significantly improves your chances of getting the desired role.
Study & Learn
- Excel Basics
- Advanced Excel
- Macros
- VBA
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.
Benefits of Certification
- Government certification
- Certification valid for life
- Lifelong e-learning access
- Learning Hours: 31 hrs+
How It Works
- Select Certification & Register
- Receive Online e-Learning Access (LMS)
- Take exam online anywhere, anytime
- Get certified & Increase Employability
- Duration: 60 minutes
- No. of questions: 50
- Maximum marks: 50, Passing marks: 25 (50%).
- There is NO negative marking in this module.
- Online exam.
TABLE OF CONTENT
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
Eligibility / Requirements
Anyone can apply for the online certification
About Vskills
Vskills is the largest certification body of India. We conducts skills testing and certification exam to improve employability. The certifications are quite popular and top companies hire Vskills certified professionals.Companies have benefitted by hiring pre-certified candidates from Vskills and also use the certifications for their in house employee appraisals. Certification helps in distinguishing individuals to demonstrate their domain knowledge or skills needed for a specific profile. So a professional certification offers tangible benefits to both the individual and the employer.
Tests are conducted in a secure and unbiased manner, and certificates are awarded based on merit of the candidates who qualify tests.
Vskills certifications are for relevant qualifications that help students/employees quantify and prove those skills that are valued by the employer and are in great demand.
293 students have enrolled with Vskills through Laimoon
See all Vskills courses
