Certificate in Microsoft Excel at VSkills Overview
Duration | 11 hours |
Total fee | ₹3,499 |
Mode of learning | Online |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
Certificate in Microsoft Excel at VSkills Highlights
- Earn a certificate of completion from Vskills
- Get Lifelong e-learning access
Certificate in Microsoft Excel at VSkills Course details
- For professionals and graduates wanting to excel in their chosen areas
- For those who are already working and would like to take certification for further career progression
- For business workers and students who want to present themselves as truly knowledgeable
- For managers who hire candidates with a VSkills Excel Professional Certification are helping minimize training costs
- Excel Professional Certification helps demonstrate an individual's overall comprehension and expertise of Microsoft Office programs
- Vskills Excel Professional Certification holders have more than a working familiarity with Microsoft Office programs—they are technically skilled to take advantage of the breadth of features efficiently and effectively
- Earning VSkills Excel Professional Certification can help candidate differentiate in today's competitive job market, broaden their employment opportunities by displaying their advanced skills, and result in higher earning potential
- Certified individuals have increased competence, productivity, and credibility with their employers, co-workers, and clients
Certificate in Microsoft Excel at VSkills Curriculum
Creating Data and Content
Worksheet Basics
Enter and edit cell content
Navigate to specific cell content
Locate, select, and insert supporting information
Insert, position, and size graphics
Analyzing Data
Filter lists using AutoFilter
Sort lists
Insert and modify formulas
Use statistical, date and time, financial, and logical functions
Create, modify, and position diagrams and charts based on worksheet data
Formatting Data and Content
Apply and modify cell formats
Apply and modify cell styles
Modify row and column formats
Format worksheets
Managing Workbooks
Create new workbooks from templates
Insert, delete, and move cells
Create and modify hyperlinks
Organize worksheets
Preview data in other views
Customize Window layout
Setup pages for printing
Print data
Organize workbooks using file folders
Save data in appropriate formats for different uses
Organizing and Analyzing Data
Use subtotals
Define and apply advanced filters
Group and outline data
Use Data Validation
Create and modify list ranges
Add, show, close, edit, merge, and summarize scenarios
Perform data analysis using automated tools
Create PivotTable and PivotChart reports
Use Lookup and Reference functions
Use Database functions
Trace formula precedents, dependents, and errors
Locate invalid data and formulas
Watch and evaluate formulas
Define, modify, and use named ranges
Structure workbooks using XML
Formatting Data and Content
Create and modify custom data formats
Use conditional formatting
Format and resize graphics
Format charts and diagrams
Collaborating
Insert, view, and edit comments
Protect cells, worksheets, and workbooks
Apply File security settings
Share workbooks
Merge workbooks
Track, accept, and reject changes to workbooks
Managing Data and Workbooks
Import Data to Excel
Export data from Excel
Publish and Edit Web worksheets and workbooks
Create and edit templates
Consolidate data
Define and modify workbook properties
Customizing Excel
Customize toolbars and menus
Create, edit, and run macros
Modify Excel default settings
Other courses offered by VSkills
Student Forum
Anything you would want to ask experts?