UrbanPro
true

Learn BI Reporting from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Built-in Functions In Excel

ITech Analytic Solutions
03/01/2018 0 0

i. Built In Functions:

MS Excel has many built in functions, which we can use in our formula. To see all the functions by category, choose Formulas Tab » Insert Function. Then Insert function Dialog appears from which we can choose the function.

ii. Functions by Categories:

Let us see some of the built in functions in MS Excel:

  • Text Functions:

    • LOWER: Converts all characters in a supplied text string to lower case.

    • UPPER: Converts all characters in a supplied text string to upper case.

    • TRIM: Removes duplicate spaces, and spaces at the start and end of a text string.

    • CONCATENATE: Joins together two or more text strings.

    • LEFT: Returns a specified number of characters from the start of a supplied text string.

    • MID: Returns a specified number of characters from the middle of a supplied text string.

    • RIGHT: Returns a specified number of characters from the end of a supplied text string.

    • LEN: Returns the length of a supplied text string.

    • FIND: Returns the position of a supplied character or text string from within a supplied text string (case-sensitive).

  • Date & Time:

    • DATE: Returns a date, from a user-supplied year, month and day.

    • TIME: Returns a time, from a user-supplied hour, minute and second.

    • DATEVALUE: Converts a text string showing a date, to an integer that represents the date in Excel's date-time code.

    • TIMEVALUE: Converts a text string showing a time, to a decimal that represents the time in Excel.

    • NOW: Returns the current date & time.

    • TODAY: Returns today's date.

  • Statistical:

    • MAX: Returns the largest value from a list of supplied numbers.

    • MIN: Returns the smallest value from a list of supplied numbers.

    • AVERAGE: Returns the Average of a list of supplied numbers.

    • COUNT: Returns the number of numerical values in a supplied set of cells or values.

    • COUNTIF: Returns the number of cells (of a supplied range), that satisfies a given criteria.

    • SUM: Returns the sum of a supplied list of numbers.

  • Logical:

    • AND: Tests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise.

    • OR: Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise.

    • NOT: Returns a logical value that is the opposite of a user supplied logical value or expression i.e. returns FALSE if the supplied argument is TRUE and returns TRUE if the supplied argument is FAL.

  • Math & Trig:

    • ABS: Returns the absolute value (i.e. the modulus) of a supplied number.

    • SIGN: Returns the sign (+1, -1 or 0) of a supplied number.

    • SQRT: Returns the positive square root of a given number.

    • MOD: Returns the remainder from a division between two supplied numbers.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

Skill Enhancement Program | Industry Training | Atreya Associates
“Education is not the learning of facts, but the training of mind to think.” - Albert Einstein Skills are crucial to allow any person to manage their daily lives in this ever-changing world....

Different Data File Formats in Big Data
Overview In this lesson I will be explaining the different kinds of Data File formats used in Big Data, These are widely used but unspoken of. Anyone aspiring to be a Data Engineer/Data Analyst/ML...

4 Key Things to Learn for Data Science
1. Theory:Use Coursera and EdX for theory, concepts, and applications of probability, statistics, linear algebra, calculus, and machine learning.2. Data Visualisation:Tableau and PowerBI are easy-to-use...

How to add bullets Point in MS-EXCEL
There is no direct option to add bullets in EXCEL. So we can create the bullets by the following steps: 1. Select the range where you want to apply the bullets.2. go to formate cell ==> Custom Formate.3....

Pradeep Agrawal | 21/07/2020

0 0
0

Tableau is a Good tool for Visualisation
Tableau is one of the best BI Tool we use to show the Data in a Visualization Mode. Tableau is a very Powerful & Fastly growing data visualization tool used in the field of Data Analytics. It will...

Harish TR | 11/11/2019

0 0
0

Looking for BI Reporting Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
Sponsored
X

Looking for BI Reporting Classes?

The best tutors for BI Reporting Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn BI Reporting with the Best Tutors

The best Tutors for BI Reporting Classes are on UrbanPro

Book a Free Demo

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more