Search
Close this search box.

MS Excel Course

by

Learnvern

This MS Excel Course course on LearnVern is completely free. It will provide a comprehensive understanding of the topic and its practical applications.
Free Course
Enroll Now
Share

#1

See all ranking

MS Excel Course

by

Learnvern

This MS Excel Course course on LearnVern is completely free. It will provide a comprehensive understanding of the topic and its practical applications.
Free Course
Enroll Now
Share

#1

See all ranking

3 Modules

with Certifications

2+ Hours

of Recorded Content

4.4 Rated

by 10000 Learners

Bangla

Language

3 Modules

with Certifications

2 + Hours

of Recorded Content

4.4 Rated

by 10000 Learners

Bangla

Language

About

Key Features

Content

FAQs

What's in it for You?

Key Features:

Available in multiples Languages
100% Self Paced Course
Lifetime access to all content
Downloadable Resources

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

Certificate Features

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

Curious Mind to learn new concepts
Strong internet connection

Course is for

Freshers

Professionals

Students

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.
The course focuses on MS Excel Course. It covers fundamentals through 3 interactive modules.
The course offers over 2 hours of recorded content.

Yes, there is a Paid Certification included with this course. The course material is entirely free; however, certification in this course requires payment of ₹999.

The course is currently available in Bangla.
Curious Mind to learn new concepts & Strong internet connection

The course is accessible on both web and mobile platforms.

This course is completely Free
To enroll in this course you can click on the Enroll Now button it will redirect you to course page, and on that page you can access the MS Excel Course course completely free.

Similar Courses

Learnvern

Stock Market And Stock Trading

2 Hours
4.3
10000
View Course
Learnvern

Soft Skills – Essentials to Start Career in Telugu

2 Hours
4.9
10000
View Course
Learnvern

Business English Course

2 Hours
4.6
10000
View Course
Learnvern

Soft Skills – Essentials to Start Career in English

2 Hours
4.6
10000
View Course
Learnvern

Soft Skills – Essentials to Start Career in Tamil

2 Hours
5
10000
View Course
Learnvern

Spoken English Course

2 Hours
4.7
10000
View Course
Learnvern

Soft Skills – Essentials to Start Career

2 Hours
4.7
10000
View Course
Learnvern

English Pronunciation Course

2 Hours
4.8
10000
View Course

Course Vendors

Categories

Quick Links

Follow us on !

Instagram Linkedin
Made with 💝 in India
© Copyright 
2024
, OJSANT Technologies Pvt. Ltd.

Share this course within your network

WhatsApp
Facebook
Telegram
LinkedIn
Threads
X

Page Link