MS Excel in Bangla

by

LearnVern

#1

See all ranking

MS Excel in Bangla

by

LearnVern

#1

See all ranking

with Certifications

of Recorded Content

4.7 Rated

Language

with Certifications

of Recorded Content

4.7 Rated

Read all Reviews

Language

About

Key Features

Content

FAQs

What's in it for You?

Key Features:

Topics you will learn

Getting started
- - How to Work with Menu Bar
- - How to use LearnVern
- - What is Quick Access Toolbar and How to Work with it
- - How to Work with Formula Bar
- - What is Status Bar and How to Work With it
- - How to Navigate within Sheet and Workbook
- - How to use Shortcuts
- - What is Format Painter and How to work with it
Data Entry
- - How to Enter Data in MS Excel
- - How to Use Autofill Functionality
- - How to Enter Date-Time
- - How to Use Undo-Redo
- - How to Work With Comments in MS Excel
- - How to Save Workbook in MS Excel
Creating Formulas
- - How to Create Formula in MS Excel
- - How to Copy Formula in MS Excel
- - How to Use Till Date Profit Formula
- - How to Work with Percentage Change Calculation
- - How to Use Absolute Value
- - How to Use Sum Average
- - Which are the Common Functions
Formatting
- - How to Format the Fonts
- - How to Adjust Rows and Columns
- - How to Use Alignment
- - How to Format the Borders
- - How to Format Numbers
- - How to Format Date-Time
- - How to Use Conditional Formatting
- - How to Format Tables
- - How to Format Shapes
Adjusting Layout
- - How to Resize Row & Column
- - How to Hide-Unhide Row & Column
- - How to Copy ,Move & Insert Data
- - How to Find and Replace Data
Print
- - How to Print
- - What is Page Break Preview & How to Set Page
- - How to Set Page
Charts
- - How to create Charts
- - Which are the different types of Chart
- - How to Format Charts
- - Which are the Chart Elements
- - How to Use Spark lines
Adjusting Workbook
- - How to Freeze-Unfreeze the Row & Column
- - How to Split the Sheet
- - How to Use Outline
Multiple work books
- - How to Manage Multiple Workbook
- - How to Use Rename Insert hide unhide sheets
- - How to Copy & Delete Sheets
- - How to Use Formula
- - How to Edit Links
If condition VLOOKUP
- - What is IF Condition and How to Use it
- - What is VLOOKUP and How to Use It
- - What is VLOOKUP Exact
- - How to Use COUNT IF
Protecting sheets
- - How to Protect Sheet
- - How to Secure Workbook
- - How to Set Password in Workbook
- - How to Share Workbook
- - How to Track Changes
Data Management
- - How to Perform Sorting
- - How to do Subtotals
- - How to Perform Filter
- - How to Spilt Data
- - How to Use Flash Fill
- - How to Remove Duplicate Data
- - How to Validate Data
Pivot Table
- - How to Create Pivot Table in MS Excel
- - How to Manipulate Pivot Table
- - How to Add Slicers
- - How to Perform Grouping of Pivot Table
Macros

What is Macro And How to Use It
Assignment
- - Assignment Q-1
- - Assignment Q-2
- - Assignment Q-3
- - Assignment Q-4
- - Assignment Q-5
- - Assignment Q-6
- - Assignment Q-7
- - Assignment Q-8
- - Assignment Q-9
- - Assignment Q-10

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

What is a sales technique?

A sales technique is a particular way of doing business in which the customer buys what is being offered. It can be anything from a product or service to an intangible thing like an idea. It can be the result of research, creativity, or many other skills that are beneficial to the seller to generate demand for their product or service. The techniques may vary depending on what is being sold. Therefore, it’s important to know the types of techniques to be recognized and researched prior to use by sellers to maximize their effectiveness.
What are the various types of sales promotion techniques?

Sales promotions are distinct from traditional marketing methods such as advertising, public relations, and social media. It is also significantly less expensive. They are no longer limited to promotional events at physical locations or mail-in coupons. They can now be managed via digital platforms such as email, website pop-ups, social media posts, and others. Consumer and trade are the two types of sales promotions. A consumer promotion is aimed at the consumer or end-user who will purchase the product, whereas a trade promotion is aimed at organisational customers and can result in immediate sales.
What are the basic sales techniques?

Sales promotion tools and techniques are a set of methods used by marketers to sell their products and services. They can be either directly or indirectly related to marketing. Understanding these effective sales techniques will enable you to sell your product or service in a way that ultimately benefits both your customers and your company. Some of the most widely-used sales techniques include: Identifying Prospects, Building Rapport, Identifying the Prospect’s Challenges and Qualifying Them, Presenting Solutions, Handling Objections, Closing the Deal, Maintaining the Relationship.
How do sales techniques influence customers?

The most common sales technique is upselling, which is the act of selling an existing customer by convincing them to buy more than what they originally intended to. This can be achieved by emphasizing on key features that their current product does not have or highlighting the benefits of a higher tier product. Sales techniques vary depending on industry and company size. It is important to note that there are no universal sales promotion tools and techniques that apply to every business, but rather there are some general guidelines for effective selling.
Is Effective Communication in Sales Course Certified?

LearnVern offers Skill India certification on successful completion of the Sales Communication Techniques Tutorial to its learners. Skill India is the National Skill Development Corporation's flagship project, and it is a coveted award recognised throughout the country.