MS Excel in Bangla > Creating Formulas

Which are the Common Functions

24.5k

  • SUM Function.
  • Count Function.
  • CountA Function.
  • LEN Function.
  • TRIM Function.
  • RIGHT, LEFT, and MID Function.
  • VLOOKUP.
  • IF Statements.

The other common functions in MS Excel are the following:

  • SUM: Adds up the numbers in a list of cells.
  • AVERAGE: Averages values, for example, to calculate the average of a list of numbers.
  • MAX: Finds the largest value in a list of numbers.
  • MIN: Finds the smallest value in a list of numbers.
  • IF: This function is used to do calculations based on conditions you specify, such as "IF cell A1 has a value greater than 5".

Despite the fact that every Excel feature has a use case, no one uses every Excel feature. After sifting through the 500+ functions, there are only about 100 or so actually useful features and functions for the majority of current knowledge workers.

  • single function (Injective function)
  • There is only one function.
  • Onto – perform (Surjective Function)
  • Into – operation
  • Polynomial function.
  • Linear Function.
  • Similar Functions
  • Quadratic Function.

Budgeting, creating graphs and charts, and storing and categorising data are the three most popular general purposes for spreadsheet software. Spreadsheet software is used in the corporate world to anticipate future performance, calculate taxes, do basic payroll, create charts, and compute revenues.

Learner's Ratings

4.7

Overall Rating

  • 83%
  • 10%
  • 5%
  • 2%
  • 0%

Reviews

A
AB Nazim
5

good

I
Ibrahim Khalil
5

Very good

S
Sathi Nanda
5

Very good teaching quality

S
Soibol Debnath
5

It a very good course.

S
syed enterprise
5

thank you dear

S
Srijib Bhadra
5

MS Excel is a very important course, and it has helped me a lot in many ways

S
Sakibul Hasan Akash
5

"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple

S
Sayeed Arshif
5

Best

S
SUSANTA BARMAN
4

best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video

P
Prabhat Yadav
5

Superb and amazing 😍🤩 enjoyable experience.

Show More
Course Content

  1. How to Work with Menu Bar
    5m 39s
  2. How to use LearnVern
    3m 20s
  3. What is Quick Access Toolbar and How to Work with it
    6m 33s
  4. How to Work with Formula Bar
    2m 35s
  5. What is Status Bar and How to Work With it
    5m 33s
  6. How to Navigate within Sheet and Workbook
    3m
  7. How to use Shortcuts
    4m 3s
  8. What is Format Painter and How to work with it
    2m 25s

  1. How to Enter Data in MS Excel
    4m 58s
  2. How to Use Autofill Functionality
    5m 32s
  3. How to Enter Date-Time
    6m 11s
  4. How to Use Undo-Redo
    5m 17s
  5. How to Work With Comments in MS Excel
    3m 29s
  6. How to Save Workbook in MS Excel
    4m 16s

  1. How to Create Formula in MS Excel
    7m 40s
  2. How to Copy Formula in MS Excel
    3m 31s
  3. How to Use Till Date Profit Formula
    3m 37s
  4. How to Work with Percentage Change Calculation
    5m 22s
  5. How to Use Absolute Value
    6m
  6. How to Use Sum Average
    5m 28s
  7. Which are the Common Functions
    7m 39s

  1. How to Format the Fonts
    3m 41s
  2. How to Adjust Rows and Columns
    3m 57s
  3. How to Use Alignment
    7m 3s
  4. How to Format the Borders
    2m 56s
  5. How to Format Numbers
    3m 52s
  6. How to Format Date-Time
    9m
  7. How to Use Conditional Formatting
    9m 6s
  8. How to Format Tables
    9m 1s
  9. How to Format Shapes
    6m 49s

  1. How to Resize Row & Column
    7m 2s
  2. How to Hide-Unhide Row & Column
    5m 23s
  3. How to Copy ,Move & Insert Data
    5m 28s
  4. How to Find and Replace Data
    6m 32s

  1. How to Print
    8m 33s
  2. What is Page Break Preview & How to Set Page
    5m 21s
  3. How to Set Page
    4m 57s

  1. How to create Charts
    7m 10s
  2. Which are the different types of Chart
    5m 37s
  3. How to Format Charts
    6m 31s
  4. Which are the Chart Elements
    7m 42s
  5. How to Use Spark lines
    7m 54s

  1. How to Freeze-Unfreeze the Row & Column
    7m 26s
  2. How to Split the Sheet
    6m 50s
  3. How to Use Outline
    6m 59s

  1. How to Manage Multiple Workbook
    6m 37s
  2. How to Use Rename Insert hide unhide sheets
    4m 38s
  3. How to Copy & Delete Sheets
    6m 30s
  4. How to Use Formula
    9m 4s
  5. How to Edit Links
    9m 12s

  1. What is IF Condition and How to Use it
    6m 25s
  2. What is VLOOKUP and How to Use It
    5m 59s
  3. What is VLOOKUP Exact
    4m 9s
  4. How to Use COUNT IF
    4m 23s

  1. How to Protect Sheet
    4m 52s
  2. How to Secure Workbook
    6m 7s
  3. How to Set Password in Workbook
    2m 19s
  4. How to Share Workbook
    3m 9s
  5. How to Track Changes
    5m 34s

  1. How to Perform Sorting
    6m 35s
  2. How to do Subtotals
    7m 26s
  3. How to Perform Filter
    5m 31s
  4. How to Spilt Data
    4m 20s
  5. How to Use Flash Fill
    3m 35s
  6. How to Remove Duplicate Data
    2m 34s
  7. How to Validate Data
    6m 51s

  1. How to Create Pivot Table in MS Excel
    11m 6s
  2. How to Manipulate Pivot Table
    8m 19s
  3. How to Add Slicers
    4m 36s
  4. How to Perform Grouping of Pivot Table
    4m 39s

  1. What is Macro And How to Use It
    7m 25s

  1. Assignment Q-1
    1m 10s
  2. Assignment Q-2
    21s
  3. Assignment Q-3
    34s
  4. Assignment Q-4
    50s
  5. Assignment Q-5
    48s
  6. Assignment Q-6
    37s
  7. Assignment Q-7
    47s
  8. Assignment Q-8
    45s
  9. Assignment Q-9
    37s
  10. Assignment Q-10
    32s
Enroll For Free