Entri Blog
No Result
View All Result
Sunday, March 26, 2023
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
    • Stock Market Course
      • Stock Market Course in Malayalam
      • Stock Market Course in Tamil
      • Options Trading Course
    • Spoken English Course
      • Spoken English Course in Malayalam
      • Spoken English Course in Hindi
      • Spoken English Course in Telugu
      • Spoken English Course in Tamil
      • Spoken English Course in Kannada
  • Others
    • GATE
    • MAT
    • KMAT
Try out Spoken English!
Entri Blog
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
    • Stock Market Course
      • Stock Market Course in Malayalam
      • Stock Market Course in Tamil
      • Options Trading Course
    • Spoken English Course
      • Spoken English Course in Malayalam
      • Spoken English Course in Hindi
      • Spoken English Course in Telugu
      • Spoken English Course in Tamil
      • Spoken English Course in Kannada
  • Others
    • GATE
    • MAT
    • KMAT
No Result
View All Result
Entri Blog
Spoken English
banner top article banner top article
Home Articles

Basic Excel Formulas and Functions with Examples

by Sreevidya M
March 20, 2023
in Articles, Data Science and Machine Learning, Entri Skilling
Basic Excel Formulas and Functions
Share on FacebookShare on WhatsAppShare on Telegram

Table of Contents

  • What are Basic Excel Formulas and Functions?
  • Common Functions
  • Numeric Function
  • String Functions
  • VLOOKUP and HLOOKUP Functions
  • Date Time Functions
  • Basic Excel Formulas and Functions FAQs

Microsoft Excel is the most preferred program for people who work in data-related careers like financial analysis, investment banking, data processing and financial modelling and presentation. It is very popular and one of the basics taught in computer classes. Microsoft Excel is often considered to be the best industry standard piece of software when it comes to data analysis. It is equipped to generate reports and business insights and hence is widely used in the industry. It even has built-in applications that make it more user-friendly. Excel is the best when it comes to doing calculations solving math and engineering problems etc. Therefore, learning basic Excel formulas and functions and mastering them is a very important step for people who aim to attain high proficiency in financial analysis.

Take your data science skills to the next level! Sign up for a free demo today!

What are Basic Excel Formulas and Functions?

Excel formulas are expressions which operate on values in a cell or over a range of cell addresses and operators. For example, the formula =A1+A2+A3 will give you the sum of values from cells A1, A2 and A3.

Predefined formulas in Excel are known as functions. Using them, we can skip the tedious process of manually entering formulas by giving them user-friendly names. For example, the same formula in the above example can be expressed as the function =SUM (A1: A3). Just like in the example above, this function sums all the values from cell A1 to cell A3.

There are many functions in excel that you can choose according to the operation you want to perform on the mentioned data set. Several basic Excel formulas and functions are listed by their categories below.

Attend our data science and machine learning course for free – schedule a demo today!

Common Functions

These are the most used among basic Excel formulas and functions.

Function Explanation Group Examples
SUM Perform addition on all the values in the mentioned range of cells Maths and Trigonometry =SUM(E1:E8)
MIN Finds the smallest value in the mentioned range of cells Statistical =MIN(E1:E8)
MAX Finds the highest value in the mentioned range of cells Statistical =MAX(E1:E8)
AVERAGE Computes the average of the value in the mentioned range of cells Statistical =AVERAGE(E1:E8)
COUNT Counts and return the number of cells in the mentioned range of cells Statistical =COUNT(E1:E8)
LEN Finds and Returns the number of characters in a string text on which the function is performed Text =LEN(B7)
SUMIF Perform addition on all the values in the mentioned range of cells that meet specific criteria.

=SUMIF(range,criteria,[sum_range])

Maths and  Trigonometry =SUMIF(D1:D8,”>=1000″,C1:C8)
AVERAGEIF Computes the average value in a range of cells that meet some specific criteria.

=AVERAGEIF(range,criteria,[average_range])

Statistical =AVERAGEIF(F1:F8,”Yes”,E1:E8)
DAYS Gives the number of days between two dates Date and Time =DAYS(D1,C1)
NOW Gives the current system date and time Date and Time =NOW()

Looking for a Data Science Career? Explore Here!

Numeric Function

These are the Excel functions that are used to operate on numeric data.

Function Explanation Group Example
ISNUMBER Gives True if the mentioned value is numerical and False if it is not Information =ISNUMBER(A4)
RAND Produces a random numeral between 0 and 1 Maths and Trigonometry =RAND()
ROUND Rounds off a decimal value to the mentioned number of decimal points Maths and Trigonometry =ROUND(3.34543,2)
MEDIAN Gives the number in the middle of the set of mentioned numbers Statistical =MEDIAN(1,4,5,2,4)
PI Gives the value of Maths Function PI(π) Maths and Trigonometry =PI()
POWER Gives the result of a number raised to a power. POWER( number, power ) Maths and Trigonometry =POWER(2,6)
MOD Gives the remainder when you divide 2 numbers Maths and Trigonometry =MOD(10,2)
ROMAN Transforms the mentioned number to roman numerals Maths and Trigonometry =ROMAN(19)

Sign up to upgrade your data science skills!

String Functions

Basic Excel formulas and functions used to handle text data are called string functions. Some string functions are given below.

Function Explanation Group Example Comment
LEFT Gives a specific number of characters from the start (left-hand side) of mentioned string Text =LEFT(“CATS85”,4) Left 4 Characters of “CATS85”
RIGHT Gives a specific number of characters from the end (right-hand side) of mentioned string Text =RIGHT(“CATS85”,2) Right 2 Characters of “CATS85”
MID Recovers a number of characters from the middle of a string from a specific start position and length.

=MID (text, start_num, num_chars)

Text =MID(“CATS85”,2,3) Recovering Characters 2 to 5
ISTEXT Gives True if the provided parameter is Text Information =ISTEXT(value) Value – The value to check.
FIND Gives the beginning position of a mentioned text string within another text string. The find function is case-sensitive.

=FIND(find_text, within_text, [start_num])

Text =FIND(“oo”, “Roofing”,1) Find ‘oo’ in “Roofing”, gives the result 2
REPLACE Substitutes part of a string with another specific string.

=REPLACE (old_text, start_num, num_chars, new_text)

Text =REPLACE(“Roofing”,2,2, “ss”) Replace “oo” with “ss”

VLOOKUP and HLOOKUP Functions

The purpose of the VLOOKUP function is to execute a vertical look-up in the leftmost column and then return a value in the same row from a column that you mention. The function HLOOKUP has the purpose of searching for a value in the top row of the table. It returns the value in the same column from a row you mention.

Study data science! Secure your dream career!

Date Time Functions

These are the basic excel function used for the manipulation of date values.

Function Explanation Group Example
DATE Gives the number that denotes the date in the excel code Date and Time =DATE(2023,2,4)
DAYS Find the number of days between the given two dates Date and Time =DAYS(D4,C4)
MONTH Gives the month from a date value Date and Time =MONTH(“4/2/2023”)
MINUTE Gives the minutes from a time value Date and Time =MINUTE(“12:31”)
YEAR Gives the year from a date value Date and Time =YEAR(“04/02/2023”)

Steps to Avoid Mistakes while using Basic Excel Formulas and Functions

  • Make sure the formula you entered is accurate according to BODMAS.
  • Make sure the cell address is correct by pressing F2 and then crosschecking the cell address.
  • The formula should always start with an equal sign. If not, you will get an error message.
  • Make sure to switch the cell format to general before entering the function. Formulas will not work if text format is chosen.
  • Space is counted as a character and hence you have to realise that a cell containing space is not the same as a blank cell.
  • Text value should be provided inside double quotes [inverted comma] if we enter text value instead of the cell address.
  • The numbers should not be enclosed in double-quotes.
  • All opening and closing parenthesis should match.
  • Copy the formula instead of retyping it.

Excel is one of the best spreadsheet applications. In this article, we have discussed the basic Excel formulas and functions with examples. It will be more productive to use the above-listed functions instead of writing formulas. Functions also have high accuracy as the chances of making mistakes are low.

Basic Excel Formulas and Functions FAQs

1. Which is the Excel function that performs addition?

Ans: SUM

2. What does the LEN function do?

Ans: Find the number of characters in a character and return the value.

3. Which function key is used for cross-checking cell addresses?

Ans: F2

 

Related links

Top 10 Benefits of Big Data Top 50 Data Analyst Interview Questions
How to Become a Data Analyst? Skills Required Explore Best Data Visualization Tools List
Principal Component Analysis in Machine Learning Data Engineer – Roles, Responsibilities and Skills Required
Data Wrangling vs Data Cleaning – Know the Difference Confusion Matrix in Machine Learning
Share61SendShare
Sreevidya M

Sreevidya M

Post-Graduate in English Language and Literature, freelance writer and an SSC aspirant. Provides updates on notifications, syllabuses and dates for government exams.

Related Posts

Rajasthan SET Admit Card 2023 Out
Admit Card

Rajasthan SET Admit Card 2023 Out, Direct Download Link

March 23, 2023
What are Question Tags - Uses and Examples
Articles

What are Question Tags – Uses and Examples

March 23, 2023
Kerala PSC Dental Hygienist Grade-II Syllabus and Exam Pattern 2023
Articles

Kerala PSC Dental Hygienist Grade-II Syllabus and Exam Pattern 2023

March 22, 2023
Next Post
Income Tax Department Cooperative Bank Recruitment

Income Tax Department Cooperative Bank Recruitment 2023 Out: Check Now

Discussion about this post

Latest Posts

  • Final Year Projects Ideas and Topics 2023
  • What is a Gerund? Definition, Examples and Usage
  • Best Career Options After Graduation
  • Leave Application For Office – Format and Samples
  • Career Options After MBA – Highest Paying MBA Jobs

Trending Posts

  • states of india and their capitals and languages

    List of 28 States of India and their Capitals and Languages 2023 – PDF Download

    150261 shares
    Share 60102 Tweet 37564
  • List of Government Banks in India 2023: All you need to know

    61860 shares
    Share 24744 Tweet 15465
  • TNPSC Group 2 Posts and Salary Details 2022

    39693 shares
    Share 15877 Tweet 9923
  • KSDA Recruitment 2023 Apply Online for 9264 FDA SDA Posts – Qualification

    2076 shares
    Share 830 Tweet 519
  • New Map of India with States and Capitals 2023

    28793 shares
    Share 11517 Tweet 7198

Courses

  • Data Science Course
  • Full Stack Developer Course
  • Data Science Course in Malayalam
  • Full Stack Developer Course in Malayalam
  • Full Stack Developer Course in Hindi
  • Full Stack Developer Course in Tamil
  • Full Stack Developer Course in Telugu
  • Full Stack Developer Course in Kannada

Company

  • Become a teacher
  • Login to Entri Web

Quick Links

  • Articles
  • Videos
  • Entri Daily Quiz Practice
  • Current Affairs & GK
  • News Capsule – eBook
  • Preparation Tips
  • Kerala PSC Gold
  • Entri Skilling

Popular Exam

  • IBPS Exam
  • SBI Exam
  • Railway RRB Exam
  • Kerala PSC
  • Tamil Nadu PSC
  • Telangana PSC
  • Andhra Pradesh PSC
  • MPPSC
  • UPPSC
  • Karnataka PSC
  • Staff Selection Commission Exam

© 2021 Entri.app - Privacy Policy | Terms of Service

No Result
View All Result
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
    • Stock Market Course
      • Stock Market Course in Malayalam
      • Stock Market Course in Tamil
      • Options Trading Course
    • Spoken English Course
      • Spoken English Course in Malayalam
      • Spoken English Course in Hindi
      • Spoken English Course in Telugu
      • Spoken English Course in Tamil
      • Spoken English Course in Kannada
  • Others
    • GATE
    • MAT
    • KMAT

© 2021 Entri.app - Privacy Policy | Terms of Service