MS Excel Tutorial in Bangla

MS Excel is an incredible spreadsheet software developed by Microsoft. It is used by almost everyone today. Excel is used to store, analyze and manipulate valuable information. Learn MS Excel in Bangla with the best tutorials available online for free and how to work in Excel. Dive into LearnVern's MS Excel Course and explore all the features and functionalities of the software. As you progress from the fundamentals to the advanced features through our MS Excel Bangla tutorial, you shall excel in the use of this software. You will learn how to navigate around Excel, MS excel functions, Excel templates, Excel Macro, formulas in Excel, Excel spreadsheet formulas, Vlookup, Excel Pivot Table, Data Management and a lot more.

How to Use Excel?

Learning MS Excel in Bangla is fun as you upgrade your skills with this Microsoft Office product. MS Excel Formulas explained step-by-step in simple words will help you learn and make your life easier and more productive. The Excel application enables you to prepare reports and presentations successfully and saves considerable time and effort. It provides several features such as sorting, adding formulas, and more that enables you to analyze data which could be crucial for decision making. You would definitely find yourself standing out from the rest after having upgraded your Excel skills with this course. You can also impress your boss and colleagues by using this powerful tool.

Who Can Enrol in Our Free MS Excel Tutorial

This free MS Excel tutorial in Bangla is best for beginners and intermediate learners. Even if you have been using MS Excel for a while, it can help you transit from the basics to advanced features of the software.

Requirements for Taking Our Free Excel Tutorial in Bangla

You will need a computer system and a stable internet connection. Familiarity with MS Excel would be beneficial in learning the concepts more easily and quickly.

• Getting started
  • How to Work with Menu Bar play_circle_outline 00:05:39
  • How to Use Forums to Ask Questions play_circle_outline 00:02:02
  • What is Quick Access Toolbar and How to Work with it play_circle_outline 00:06:33
  • How to Work with Formula Bar play_circle_outline 00:02:35
  • What is Status Bar and How to Work With it play_circle_outline 00:05:33
  • How to Navigate within Sheet and Workbook play_circle_outline 00:03:00
  • How to use Shortcuts play_circle_outline 00:04:03
  • What is Format Painter and How to work with it play_circle_outline 00:02:25
• Data Entry
  • How to Enter Data in MS Excel play_circle_outline 00:04:58
  • How to Use Autofill Functionality play_circle_outline 00:05:32
  • How to Enter Date-Time play_circle_outline 00:06:11
  • How to Use Undo-Redo play_circle_outline 00:05:17
  • How to Work With Comments in MS Excel play_circle_outline 00:03:29
  • How to Save Workbook in MS Excel play_circle_outline 00:04:16
• Creating Formulas
  • How to Create Formula in MS Excel play_circle_outline 00:07:40
  • How to Copy Formula in MS Excel play_circle_outline 00:03:31
  • How to Use Till Date Profit Formula play_circle_outline 00:03:37
  • How to Work with Percentage Change Calculation play_circle_outline 00:05:22
  • How to Use Absolute Value play_circle_outline 00:06:00
  • How to Use Sum Average play_circle_outline 00:05:28
  • Which are the Common Functions play_circle_outline 00:07:39
• Formatting
  • How to Format the Fonts play_circle_outline 00:03:41
  • How to Adjust Rows and Columns play_circle_outline 00:03:57
  • How to Use Alignment play_circle_outline 00:07:03
  • How to Format the Borders play_circle_outline 00:02:56
  • How to Format Numbers play_circle_outline 00:03:52
  • How to Format Date-Time play_circle_outline 00:09:00
  • How to Use Conditional Formatting play_circle_outline 00:09:06
  • How to Format Tables play_circle_outline 00:09:01
  • How to Format Shapes play_circle_outline 00:06:49
• Adjusting Layout
  • How to Resize Row & Column play_circle_outline 00:07:02
  • How to Hide-Unhide Row & Column play_circle_outline 00:05:23
  • How to Copy ,Move & Insert Data play_circle_outline 00:05:28
  • How to Find and Replace Data play_circle_outline 00:06:32
• Print
  • How to Print play_circle_outline 00:08:33
  • What is Page Break Preview & How to Set Page play_circle_outline 00:05:21
  • How to Set Page play_circle_outline 00:04:57
• Charts
  • How to create Charts play_circle_outline 00:07:10
  • Which are the different types of Chart play_circle_outline 00:05:37
  • How to Format Charts play_circle_outline 00:06:31
  • Which are the Chart Elements play_circle_outline 00:07:42
  • How to Use Spark lines play_circle_outline 00:07:54
• Adjusting Workbook
  • How to Freeze-Unfreeze the Row & Column play_circle_outline 00:07:26
  • How to Split the Sheet play_circle_outline 00:06:50
  • How to Use Outline play_circle_outline 00:06:59
• Multiple work books
  • How to Manage Multiple Workbook play_circle_outline 00:06:37
  • How to Use Rename Insert hide unhide sheets play_circle_outline 00:04:38
  • How to Copy & Delete Sheets play_circle_outline 00:06:30
  • How to Use Formula play_circle_outline 00:09:04
  • How to Edit Links play_circle_outline 00:09:12
• If condition VLOOKUP
  • What is IF Condition and How to Use it play_circle_outline 00:06:25
  • What is VLOOKUP and How to Use It play_circle_outline 00:05:59
  • What is VLOOKUP Exact play_circle_outline 00:04:09
  • How to Use COUNT IF play_circle_outline 00:04:23
• Protecting sheets
  • How to Protect Sheet play_circle_outline 00:04:52
  • How to Secure Workbook play_circle_outline 00:06:07
  • How to Set Password in Workbook play_circle_outline 00:02:19
  • How to Share Workbook play_circle_outline 00:03:09
  • How to Track Changes play_circle_outline 00:05:34
• Data Management
  • How to Perform Sorting play_circle_outline 00:06:35
  • How to do Subtotals play_circle_outline 00:07:26
  • How to Perform Filter play_circle_outline 00:05:31
  • How to Spilt Data play_circle_outline 00:04:20
  • How to Use Flash Fill play_circle_outline 00:03:35
  • How to Remove Duplicate Data play_circle_outline 00:02:34
  • How to Validate Data play_circle_outline 00:06:51
• Pivot Table
  • How to Create Pivot Table in MS Excel play_circle_outline 00:11:06
  • How to Manipulate Pivot Table play_circle_outline 00:08:19
  • How to Add Slicers play_circle_outline 00:04:36
  • How to Perform Grouping of Pivot Table play_circle_outline 00:04:39
• Macros
  • What is Macro And How to Use It play_circle_outline 00:07:25
• Assignment
  • Assignment Q-1 play_circle_outline 00:01:10
  • Assignment Q-2 play_circle_outline 00:00:21
  • Assignment Q-3 play_circle_outline 00:00:34
  • Assignment Q-4 play_circle_outline 00:00:50
  • Assignment Q-5 play_circle_outline 00:00:48
  • Assignment Q-6 play_circle_outline 00:00:37
  • Assignment Q-7 play_circle_outline 00:00:47
  • Assignment Q-8 play_circle_outline 00:00:45
  • Assignment Q-9 play_circle_outline 00:00:37
  • Assignment Q-10 play_circle_outline 00:00:32

Why Must You Enrol for MS Excel Tutorial in Bangla with LearnVern

LearnVern offers a one-of-its-kind platform to its learners where they can take up video tutorials and pursue the lessons in a language of their choice. Many learners shy away from taking online lessons due to the exorbitant fees and the medium of instruction. LearnVern addresses these issues by offering online free excel courses and that too in a host of vernacular languages.

Our objective is to groom individuals, train them theoretically and practically and help them emerge as industry-ready professionals. To achieve this goal, we prepare our MS Excel course material in collaboration with the academia and industry experts to ensure that our learners are provided with the most accurate and industry-relevant learning material. Our tutors are experienced professionals who understand the nuances and expectations of the industry from new recruits and hence concepts that make our learners a ‘preferred candidate’ are inculcated into the course curriculum.

Practical learning is an absolute essential for any candidate to build a career. Hence, we ensure that we provide ample opportunities for our learners to get hands-on experience in MS Excel. Our MS Excel tutorial has quizzes and assignments that let our learners understand the scale of learning and identify areas that need improvement. In addition to this, LearnVern offers you the opportunity to earn a coveted certificate on successful completion of this course that can add tremendous value to your resume.

Why Should I Enrol with LearnVern to learn MS Excel?

LearnVern offers a unique platform for learners who have been shying away from taking online courses because of the high fees and limited language options. Our MS Excel Tutorial is absolutely free of cost and can be taken in Bangla. To ensure that our learners get an equal opportunity to get hands-on training as well as theoretical lessons, we prepare the curriculum meticulously and ensure that equal portions of theory and practical aspects are included. Our Excel course material has quizzes and assignments to test the technical knowledge of a learner and help them identify their weaknesses and strengths and work towards perfecting their skills.

Will Lessons be provided in Bangla Throughout?

Yes. This MS Excel in Bangla tutorial has been carefully put together to help learners who are comfortable learning in Bengali. Several people face the challenge of not being able to follow lectures on online tutorials because of their inability to understand English or Hindi. LearnVern understands this challenge and has created this course module for Bengali speakers. Practical examples and demonstrations are also provided in Bangla to ensure that you have a clear understanding of each subject.

What Skills Will I Learn Through this Tutorial?

Not everyone has taken formal training in the MS Office suite. Most people learn using the MS Office Suite on the job. As a result, they are unaware of the many features that the suite offers. The MS Excel tutorial in Bangla offers you in-depth learning of MS Excel to help you use spreadsheets effectively and become more productive at work. The structured MS Excel course module will help you learn Excel online and progresses by introducing you to the basics of Excel and gradually moving into more advanced concepts such as adjusting workbooks, data management and using Excel Macro.  At the end of this course, you will emerge as a thorough professional who can use Excel sheets to store and manipulate data to your advantage.

Will I Get a Certificate at the End of the Course?

Yes. The MS Excel tutorial in Bangla offered by LearnVern is free of cost. You can acquire a SkillIndia certificate, issued by the National Skill Development Corporation, by upgrading the course for a nominal cost of Rs 499. It is recognised across India and can help you secure promising internships and rewarding job opportunities. You can view a sample of the certificate here.

Can I Access the Tutorial Online?

To continue your Excel course even when you are travelling, you can download our app from the Android Play Store. You can download our course material for offline viewing and continue learning even on the go. You can also share this downloaded content with your friends and colleagues through our Ambassador programme.