MS Excel Course

by

LearnVern

#1

See all ranking

MS Excel Course

by

LearnVern

#1

See all ranking

with Certifications

of Recorded Content

4.4 Rated

Language

with Certifications

of Recorded Content

4.4 Rated

Read all Reviews

Language

About

Key Features

Content

FAQs

What's in it for You?

Key Features:

Topics you will learn

What is MS Excel
- - Menu in Excel
- - How to use LearnVern
- - Quick Access Toolbar
- - Formula Bar in Excel
- - Status Bar in MS Excel
- - Navigation in MS Excel
- - Shortcuts in MS Excel
- - Format Painter in MS Excel
- - Excel Getting Started Quiz
Data Entry
- - Data Entry in MS Excel
- - Autofill in MS Excel
- - Data Entry for Date-Time in MS Excel
- - Undo-Redo in MS Excel
- - Comments in MS Excel
- - Saving File in MS Excel
- - Excel Data Entry Quiz
Creating Formulas
- - Creating Formula in MS Excel
- - Copy Formula in Excel
- - Till Date Formula in MS Excel
- - Pct Calculation in MS Excel
- - Absolute in MS Excel
- - Sum Average in MS Excel
- - Other Common Functions In MS Excel
- - Excel Creating Formulas Quiz
Formating
- - Formatting Fonts in MS Excel
- - Adjusting Rows & Columns in MS Excel
- - Alignment in MS Excel
- - Formatting Borders in MS Excel
- - Formatting Numbers in MS Excel
- - Formatting Date-Time in MS Excel
- - Conditional Formating in MS Excel
- - Formatting Tables in MS Excel
- - Formatting Shapes in MS Excel
- - Excel Formating Quiz
Adjusting Layout
- - Resizing Row & Column in MS Excel
- - Hide-Unhide Row and Column in MS Excel
- - Copy, Move, Insert Data in MS Excel
- - Find Replace in MS Excel
- - Excel Adjusting Layout Quiz
Print
- - Printing in MS Excel
- - Page Break Preview in MS Excel
- - Page Setup in MS Excel
- - Excel Print Quiz
Charts
- - Creating Charts in MS Excel
- - Types of Chart in MS Excel
- - Formatting Charts in MS Excel
- - Chart Elements in MS Excel
- - Sparklines in MS Excel
- - Excel Charts Quiz
Adjusting Workbook
- - Freezing Workbook in MS Excel
- - Splitting Sheets in MS Excel
- - Outline in MS Excel
- - Excel Adjusting Workbook Quiz
Multiple work books
- - Manage Multiple Workbook in MS Excel
- - Working with Sheets in MS Excel
- - Copy & Delete Sheets in MS Excel
- - Use of Formula in Worksheet
- - Edit Links in MS Excel
- - Excel Multiple work books Quiz
If condition VLOOKUP
- - If Condition in MS Excel
- - VLOOKUP in MS Excel
- - VLOOKUP Exact in MS Excel
- - COUNTIF in MS Excel
- - Excel If condition VLOOKUP Quiz
Protecting sheets
- - Protecting Sheets in MS Excel
- - Securing Workbook in MS Excel
- - Password to Workbook in MS Excel
- - Sharing Workbook in MS Excel
- - Track Changes in MS Excel
- - Excel Protecting sheets Quiz
Data Management
- - Sorting in MS Excel
- - Subtotals in MS Excel
- - Filter in MS Excel
- - Split Data in MS Excel
- - Flash Fill in MS Excel
- - Remove Duplicate in MS Excel
- - Data Validation in MS Excel
- - Excel Data Management Quiz
Pivot Table
- - Creating Pivot Table in MS Excel
- - Manipulating Pivot Table in MS Excel
- - Adding Slicers in MS Excel
- - Other Grouping of Pivot Table in MS Excel
- - Excel Pivot Table Quiz
Macros
- - Macro in MS Excel
- - Excel Macros Quiz
Assignment
- - Excel Assignment Q-1
- - Excel Assignment Q-2
- - Excel Assignment Q-3
- - Excel Assignment Q-4
- - Excel Assignment Q-5
- - Excel Assignment Q-6
- - Excel Assignment Q-7
- - Excel Assignment Q-8
- - Excel Assignment Q-9
- - Excel Assignment Q-10
Master Quiz

Master Quiz

Course Offerings

Certificate you will get

NSDC Certificate of Partnership with LearnVern.

Help build strong resume.

Great add-on to get Internship.

Upgrade your Job with this certificate proof.

After this Course

Pre Requsites

Course is for

No results found.

FAQ's

Is the Excel Course easy to learn?

Yes, at LearnVern, the course is made easy to learn for one and all. The course covers all topics in a video tutorial where all features of Excel are taught for practical use at work.
What is the scope of learning Excel?

This course is demanded as a skill for the jobs at all levels of management in companies. Administrative Assistant, Product Managers, Business Analysts, Market Research Analysts, etc., are some of the jobs where recruiters look for experts in Excel.
What are the benefits of doing a Free course for MS Excel?

If you do not want to pay hefty amounts to learn Excel, you must enroll at LearnVern. Here we only charge for the certificate, and Learning is Completely FREE. You will be able to pace your course at your sweet speed. Once you complete the course, you will be able to impress your boss with impeccable data management. If you are an entrepreneur, you will be able to manage valuable data and derive actionable insights. Job seekers will be able to land their dream job by learning MS Excel from LearnVern.
Who can join LearnVern’s Excel course?

Anyone who wants to learn MS Excel and has basic knowledge of computers can join the LearnVern course. This course is designed to support the skill enhancement needs of MS Excel practitioners, IT/corporate/HR professionals, accountants, research and business analysts, etc.
Is the LearnVern Excel course Free?

LearnVer’s course is free of cost for all. It is an initiative of the Skill India Campaign backed by the Government of India. Students from all backgrounds are encouraged to enrich their skill-set by offering the courses for free.
Which is the best course for Excel?

LearnVern’s MS Excel Course is the best course for learning the skill. This course imparts complete knowledge of various functions performed in Excel for various job purposes. The students can learn how to remove duplicates, how to merge cells, how to freeze a row, how to add drop-down and several other functions commonly used by the data handling experts. Thus, this course prepares you for jobs based on this skill.
How can I learn Excel?

You can learn the full course by enrolling in LearnVern. Here, all basic to advanced concepts as used by the professionals are demonstrated through a video tutorial. The video walk-through allows students to learn in a confusion-free manner and prepares candidates to use this skill professionally.
Can I Learn Excel within one week?

Yes, you can learn the skill within one week by joining this course for free at LearnVern. This course offers a self-paced way of mastering skills by making the tutorial available on mobile devices.
Where can I Learn Excel for Free?

You can learn for free at LearnVern.