Top 10 Most Important Excel Formulas - Made Easy!

Summary

This educational video tutorial covers 10 essential Excel functions for data analysis. It begins with the AVERAGE function for calculating the mean of numbers, followed by SUM for total addition. The SUMIF function is highlighted for conditional summing. The COUNT and COUNTA functions are introduced for counting cells with numbers and non-empty cells, respectively. The COUNTBLANK function is also mentioned. The COUNTIF function is explained for counting specific criteria. The CONCATENATE function is showcased for combining text from different cells. The IF function is used for conditional logic, and VLOOKUP is demonstrated for retrieving data based on lookup values. Lastly, creating a drop-down list for easy data selection is discussed. The video is aimed at enhancing viewers' Excel skills for various applications.

Takeaways

• 📊 The AVERAGE function in Excel calculates the mean of a set of numbers, either by highlighting a range or by manually entering them separated by commas.
• 🔢 The SUM function adds up numbers in a specified range or adds up individual numbers when entered directly into the formula.
• 🚗 The SUMIF function is used to sum numbers based on a specific condition, such as summing only the values associated with a particular category within a range.
• 🔡 The COUNT function tallies the number of cells containing numbers within a specified range, excluding cells with text or empty cells.
• 📄 COUNTA counts the number of non-empty cells in a range, including cells with text or numbers.
• 📑 COUNTBLANK counts the number of empty cells in a given range, which can be useful for identifying unused or available slots in a dataset.
• 🔍 The COUNTIF function is similar to SUMIF but is used to count the number of cells that meet a certain criterion within a range, rather than summing them.
• 🔗 The CONCATENATE function combines text from two or more cells into one cell, which can be useful for creating full names or merging data from different columns.
• 🔧 The IF function performs logical tests and returns one value if the condition is true and another if it is false, which can be used for conditional formatting or calculations.
• 🔎 The VLOOKUP function is used to look up data based on a given value, returning a value from a specified column in a table, which is helpful for retrieving associated information.
• 📋 The creation of a drop-down list in Excel simplifies data entry by allowing users to select from a predefined list, reducing errors and maintaining consistency.

Q & A

What is the AVERAGE function used for in Excel?

The AVERAGE function in Excel is used to calculate the average of a set of numbers. You can input a range of cells or specific numbers, and Excel will compute the mean value.

How do you calculate the sum of a list of numbers using Excel?

To calculate the sum of a list of numbers in Excel, you use the SUM function. You can either highlight the range of cells containing the numbers or input the numbers directly into the function separated by commas.

What does the SUMIF function allow you to do in Excel?

The SUMIF function in Excel allows you to calculate the sum of values based on a specific condition. You specify a range, a criteria, and the actual range of numbers to sum. It's useful for summing items that meet certain criteria.

How can you count the number of cells containing numbers in a range using Excel?

In Excel, you can use the COUNT function to count the number of cells in a range that contain numbers. It will return the count of cells with numerical values, ignoring any empty or non-numeric cells.

What is the purpose of the COUNTA function in Excel?

The COUNTA function in Excel is used to count the number of cells that are not empty within a specified range. It counts cells containing any type of data, including numbers, text, and logical values.

How does the COUNTBLANK function assist in Excel?

The COUNTBLANK function in Excel is used to count the number of empty cells in a specified range. This can be helpful when you need to determine how many cells in a dataset are not filled with any data.

What does the COUNTIF function enable you to do in Excel?

The COUNTIF function in Excel enables you to count the number of cells within a range that meet a specific criterion. You define the range and the condition, and Excel will count how many cells satisfy that condition.

Can you explain the CONCATENATE function in Excel and how it's used?

The CONCATENATE function in Excel is used to combine the text from multiple cells into one cell. You specify the cells you want to combine, and Excel will join their contents together. You can also include additional text or spaces between the concatenated values.

How is the IF function utilized in Excel for conditional calculations?

The IF function in Excel is used for conditional calculations. It tests a condition and returns one value if the condition is true and another value if it's false. This can be used to perform different calculations or display different messages based on the result of the logical test.

What is the VLOOKUP function and how can it be used to find information in Excel?

The VLOOKUP function in Excel is used to search for a specific value in the leftmost column of a range and return a value in the same row from a different column. It's useful for looking up information based on a key value, such as finding an email address or phone number based on a person's name.

How can you create a drop-down list in Excel to simplify data entry?

In Excel, you can create a drop-down list by selecting the cell or range where you want the list, going to the Data tab, and choosing Data Validation. Under 'Allow', select 'List' and either type the items directly or use the 'list' option to select from a range of cells containing the items.

Outlines

00:00

📊 Excel's AVERAGE and SUM Functions

This paragraph introduces two fundamental Excel functions: AVERAGE and SUM. The AVERAGE function calculates the mean of a set of numbers. The script demonstrates how to use this function by highlighting a range of cells and applying the formula, resulting in an average value. Additionally, it shows how to quickly average two or three numbers by directly inputting them into the function. The SUM function is used to add up a list of numbers. The tutorial explains how to sum a range of cells and also how to sum just two or three individual numbers by entering them directly into the SUM formula. Both functions are essential for basic data analysis in Excel.

05:00

🔢 Advanced SUM with SUMIF Function

The second paragraph delves into the SUMIF function, which is used for conditional summing. Unlike the basic SUM function, SUMIF allows users to add numbers based on a specific criterion. The tutorial illustrates this by showing how to sum values associated with a particular car type, such as Mazda, by using a range for the condition and a separate range for the values to sum. The function dynamically updates based on the criterion set in a specified cell, making it a powerful tool for filtering and summing data in Excel.

10:01

🔡 Counting Cells with COUNT, COUNTA, and COUNTBLANK

This section discusses various counting functions in Excel: COUNT, COUNTA, and COUNTBLANK. The COUNT function tallies cells containing numbers within a specified range. The COUNTA function extends this by counting all non-empty cells, including those with text or numbers. The COUNTBLANK function, as the name suggests, counts empty cells. The script provides examples of using these functions on different types of data, demonstrating how they can be utilized to get insights into the quantity and type of data present in a dataset.

15:03

📋 Conditional Counting with COUNTIF

The fourth paragraph focuses on the COUNTIF function, which is used for conditional counting. Similar to SUMIF, COUNTIF allows users to count the occurrences of specific items that meet a certain criterion within a range. The tutorial shows how to count the number of times a particular car brand, such as Toyota or Mazda, appears in a list. The function is dynamic, updating the count based on the criterion set in a specified cell, which can be changed to count different items as needed.

20:03

🔗 Combining Data with CONCATENATE Function

The fifth paragraph introduces the CONCATENATE function, which is used to combine text from different cells into one. The tutorial demonstrates how to concatenate first and last names from two separate columns into a full name in a third column. It also explains how to include a space or other characters between the concatenated texts for clarity. This function is particularly useful for creating a single field from multiple pieces of related information in a spreadsheet.

25:07

🤖 Making Decisions with IF Function

This section covers the IF function, which is used for making logical decisions based on conditions. The tutorial shows how to use the IF function to return 'true' or 'false' based on whether a cell contains a specific value, such as checking if a cell contains the word 'orange'. It also demonstrates how to use the IF function to perform calculations or return different values based on the condition, such as multiplying a number by 10 if it's greater than 30 or dividing by 10 if it's not. The IF function adds a layer of interactivity and decision-making capability to Excel spreadsheets.

🔍 Retrieving Data with VLOOKUP Function

The sixth paragraph introduces the VLOOKUP function, a powerful tool for retrieving data based on a lookup value. The tutorial demonstrates how to use VLOOKUP to find an individual's email, phone number, and annual revenue from a table based on their name. It explains the function's parameters, including the lookup value, table array, column index number, and range lookup argument. The VLOOKUP function is essential for quickly accessing and displaying related information from a database-like structure in Excel.

📑 Creating Interactive Dropdown Lists

The final paragraph discusses how to create interactive dropdown lists in Excel, which can be used to simplify data entry and improve user experience. The tutorial explains how to set up data validation to create a dropdown list from a set of predefined names. It shows how selecting a name from the dropdown automatically updates other cells with associated information, such as email, phone number, and revenue. This feature is particularly useful for creating user-friendly forms and reducing the risk of data entry errors.

Keywords

💡Average Function

The Average function in Excel is used to calculate the mean of a set of numbers. In the video, it's demonstrated by typing '=AVERAGE' followed by the range of cells containing the numbers to be averaged. The function is showcased with a list of numbers, and the result is the average of those numbers, which is 53.125 in the given example. This function is essential for data analysis, as it helps in understanding the central tendency of numerical data.

💡Sum Function

The Sum function in Excel adds up a range of numbers. The script illustrates the use of '=SUM' followed by the cells containing the numbers to be summed. It's shown with a static list and also dynamically with individual numbers, such as '=SUM(100, 200, 300)', which returns 600. This function is fundamental in financial calculations and any scenario where the total of a set of values is required.

💡Sum If Function

The Sum If function is a conditional version of the Sum function, allowing the user to add numbers based on a specific criterion. In the script, it's used to find the sum of values associated with 'Mazda' vehicles. The formula '=SUMIF(range, criteria, [sum_range])' is used, where 'range' is the set of criteria ('Mazda'), 'criteria' is the condition ('Mazda'), and 'sum_range' is the cells with the values to sum. This function is valuable for filtering and totaling data based on conditions.

💡Count Function

The Count function in Excel counts the number of cells in a range that contain numbers. The video uses '=COUNT' to count ten cells with numerical data. This function is useful for quickly determining the quantity of numeric entries in a dataset, which can be important for statistical analysis or for ensuring data completeness.

💡Count A Function

The Count A function counts the number of non-empty cells in a range. Unlike the Count function, it includes cells with text. In the video, it's used to count all filled cells, including those with text. This function is helpful for inventory checks or any scenario where the total count of entries, regardless of type, is needed.

💡Count Blank Function

The Count Blank function counts the number of empty cells in a range. In the script, it's used to identify three empty cells. This function is particularly useful for identifying gaps in data entry, which can be crucial for data cleaning and preparation before analysis.

💡Count If Function

The Count If function counts the number of cells within a range that meet a certain condition. The video demonstrates '=COUNTIF(range, criteria)' to count how many times 'Toyota' appears in a list. This function is instrumental for frequency analysis, such as counting occurrences of specific items or events within a dataset.

💡Concatenate Function

The Concatenate function combines text from two or more cells into one cell. In the video, it's used to merge first and last names from separate columns into a full name. The formula '=CONCATENATE(text1, text2, ...)' is used, where 'text1' and 'text2' are the cells to be combined. This function is beneficial for creating complete records from separate data fields, such as full names or addresses.

💡If Function

The If function performs a logical test and returns one value if the test is true and another if it's false. The video shows '=IF(condition, value_if_true, value_if_false)' being used to return 'Yes' or 'No' based on whether a fruit is a lemon. This function is versatile for making decisions based on conditions, such as applying different calculations or outputs based on data values.

💡VLookup Function

The VLookup function searches for a specified value in the first column of a range and returns a value in the same row from another column. The script uses '=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])' to find an individual's email, phone number, and revenue based on their name. This function is essential for lookups in databases or spreadsheets where you need to retrieve associated information based on a key value.

💡Drop-Down List

A drop-down list in Excel provides a user-friendly way to select from a predefined list of options. In the video, it's created using 'Data Validation' with 'List' as the criteria, allowing the user to choose names. This feature enhances data entry by providing a controlled set of inputs, reducing errors and ensuring consistency in the data.

Highlights

Introduction to the average function in Excel for calculating the mean of a set of numbers.

Demonstration of averaging a list of numbers by using the AVERAGE function and highlighting the data range.

Quickly averaging two numbers using the AVERAGE function with direct input.

Averaging three numbers by directly inputting the values into the AVERAGE function.

Explanation of the SUM function to calculate the total of numbers in a list.

Using the SUM function to add two numbers by directly inputting the values.

Adding three numbers together using the SUM function with direct values.

Introduction to the SUMIF function for conditional summing based on a criteria.

Example of using SUMIF to calculate the sum of Mazda vehicles' values based on a criteria in a cell.

Automatic adjustment of SUMIF function when changing the criteria to different car types.

Introduction to the COUNT function for counting the number of cells containing numbers.

Explanation of the COUNTA function to count non-empty cells, including those with text.

Use of the COUNTBLANK function to count the number of empty cells in a range.

Introduction to the COUNTIF function for counting occurrences based on a specific condition.

Example of COUNTIF function counting the number of times 'Toyota' appears in a list.

Adjusting COUNTIF to count different car types by changing the criteria.

Introduction to the CONCATENATE function for combining text from two columns.

Using CONCATENATE to merge first and last names with a space in between.

Introduction to the IF function for performing calculations based on logical tests.

Example of IF function returning 'true' or 'false' based on whether a cell contains 'orange'.

Using IF function for conditional calculations like multiplying a value by 10 if it's greater than 30.

Introduction to the VLOOKUP function for looking up information based on a given value.

Example of VLOOKUP being used to find an individual's email address based on their name.

Adjusting VLOOKUP to find different information such as phone numbers and annual revenue.

Introduction to creating a drop-down list in Excel for easy data entry.

Demonstration of a drop-down list updating connected cells with relevant information.

Transcripts

in this video we're going to talk about

10 functions that are typically used

in excel

so the first one that we're going to go

over

is the average function so let's say we

have a group of numbers 15

27

42

93 56

84 75

33

and

49

if you want to find the average of these

numbers type in equal

average

parentheses

and then highlight

the column of data that you want to

average

and so the average of these numbers is

53.125

and so that's a very simple way in which

you can use the average function in

excel

now let's say if you want to average two

numbers quickly you can type in equal

average and then let's say we want to

average 100 and 200. so type in 100

comma 200 close parenthesis

and you get 150.

if you want to average three numbers

you can type in the three numbers let's

say a hundred

two hundred and three hundred

the average of those three numbers is

two hundred

and so that's another way in which we

can use

the average function

in excel

now the next function that we're going

to talk about

is the sum function

so let's say if we want to add up some

numbers

so if we wish to find a sum

of the numbers in this list we can type

in equal

sum parentheses

and then highlight the column that you

want to

find the sum of

and so the sum of those numbers is 429

and just like before if we want to we

can just find the sum of two numbers

let's say

50 and 125.

50 plus 125 is 175.

you can also type in equal 50 plus 125.

and as you can see you'll get the same

answer

now let's say if you want to find the

sum of three numbers you can type in

equal sum

100 comma 200 comma 300

and that will give you 600 or you can

write it this way equal 100 plus 200

plus 300

and so there's different ways in which

you can

add up numbers

using the sum function

and so that's the second function that

we're going to talk about

in this video

now the third function

is going to be

the sum if function

so let's compare that with the sum

function

the sum function allows us to calculate

the sum

of a range of values let's say

if we want to find

basically the sum of all of these

vehicles we can just use the sum formula

but let's say

if we want to use the sum if formula how

will that help us

let's highlight this particular

cell so i'm going to

give it a yellow color so let's say

if we want to find the sum of only the

mazda vehicles so we don't want to find

the sum of all these numbers but just

basically a selected sum we want to find

the sum of a certain element in this

list

so what we need to do is type in equal

sum if

parenthesis

and then we need to select a range

so the range

will be

the car type and then comma the criteria

will be based on whatever is in this

cell cell b14

and then

comma

the sum range so these are the numbers

that we wish to add

close parenthesis enter

this should be the card type actually

instead of mazda

now we're going to put the word mazda in

this cell

and so notice that we get the total sum

of all the mazda vehicles so that's 125

plus 142 plus 425 and you can check it

if you type in equal

sum 125

comma

142 comma

425

it will give you 692.

now you could change it let's say if we

want to find the sum of the honda

vehicles

it's automatically going to adjust

there's only one type of honda vehicle

in this list so it's 174.

if we want to find the sum of all the

toyota vehicles just type it in

and it automatically gives us a sum

so we have

326 for toyota

89 and 274. so if we type in equal 326

plus

89 plus the other one which is 274 we

get 689

so the sum if function

helps us to find the sum of a certain

element in this list rather than the sum

of all of these numbers in that list

now let's move on to our four function

which is going to be

the count function

so how can we use the count function

the count function allows us to count if

you read it it says it counts the number

of cells in a range that contains

numbers

so we can use it to count

uh this column

and so we have a total of ten cells that

contains numbers so this is the first

one second third fourth fifth sixth

seventh eight nine ten

so there's ten ten cells that contain

numbers

now if you try to use it with a column

of data that don't contain numbers

you're gonna get a value of zero

so that's the four function account

function it helps you to count the

number of cells with numbers

the next one

is

the count function or count a function

and so this function

allows you

to basically

count the number of cells that are not

empty

so these could be cells with

a text or a number

so if we highlight these cells

we're going to get a count of 10. now

let's say if we have mazda if we have a

number 25

let's say we have toyota

and then

37

and then let's say it jim

let's say carla

12.

if we try to use

the count function on this

it's only going to count

two numbers

because

it counts 25 and 37 it doesn't

count this one which contains the

letters and numbers

so that's the count function if we use

the count function or the count a

function

it'll count every function that is not

empty

and so it counts all of these

functions

if we try to use it on this entire range

it still gives a six

it doesn't count the empty cells

now there is a function that does count

the empty cells

and that is the count

blank

function

so notice that we have three empty cells

one two three

and so that's the count blank function

so now you know how to use the count and

account a function

in excel

so number six

will be

the count

if function

so the countif function is very similar

to the sum if function

it allows us to count a certain a

selection

in this entire column

so let's change this to

countif and so this is going to be equal

count if

and then we need to select the range

so this will be the range

and then the criteria which is a cell

will be whatever is in a cell b14

so notice that it tells me how many

times toyota is listed in this list

and so we have one

two three

now let's choose moz actually let's

choose something different

let's choose

honda honda should be listed once

now i'm going to add another mazda to

list

so we have one two three four

so

actually let's replace toyota with mazda

because the selection stops here

so i have a total of

four mazda car types in this list

so if i change it to mazda it will count

four

now i only have two toyota vehicles in

this list so if i change it to toyota

i will get two and so that is the count

in function

so instead of counting

all the card types that we have here

which should be about 10

if we use the count function

the countif function allows us to count

a certain selection in that list it can

allow us to count only the toyota

vehicles or only the mazda vehicles

and so that's how you can use the count

if function in this example

next up we have

our next function

which is number seven

can can

tonight

so let's uh

increase

the width of that column

and let's

turn this back into a white cell

so how can we use the concatenate

function

let's say if we have a list of names

the first name in column b

and the last name

in column c

and let's write some names so let's say

we have

the name john smith

let's say

kelly

williams

and then

jackie garcia

and then we'll say lisa clark

and

let's say

david

johnson

now let's use the concatenate function

so i'm going to type in

equal

can can

tonate

and then parentheses

text one

and then comma

text to

close parentheses and so notice that it

puts the information

in column or in cell b2

and it connects it with the information

in cell c2 and if i want to i can extend

this information

now instead of doing that

notice that we need a space in between

so to put that space

go ahead and type in equal

concatenate again

and then we'll type in

cell b2 you can just highlight it and

then comma

in quotations type in your quotation

mark space

quotation mark

and then comma

cell c2

close parenthesis

so now it's going to put a space

between

columns b and c

and so the concatenate function allows

you

to basically combine the information in

two columns

and connect it in one column and you

could put anything in between so you can

put a space

or any other uh data that you want to

put in between those two columns so

that's number seven the concatenate

function

now number eight

the if function

how can we use that

so let's say if

we have the name of a fruit

let's say apple

orange

lemon

or

let's say banana

so equal if

so the logical tests will be based on

uh cell b3 so if b3

is

let's say an orange

i want excel to tell me that it's true

if it's not an orange

i want it to tell me that it's false

so here this is false because it's not

orange

and i'm going to extend it

notice that i do get a true statement

for this being orange

if i change this to orange it becomes

true

if i change that to an apple it becomes

false and so that's one way in which you

could use

the if statement

you can also use it to say something

other than true and false

so let's say if

cell

b3

is

a lemon

so for words you need to put in

quotation marks comma now instead of

typing true

i want to type in yes so i have to put

quotations yes

and the next one i can type in no or i

could say

it

is not a lemon whatever

i decide to write here it's going to

replace the word false with that

statement if it's not true

so

here i don't have a lemon so it is not a

lemon and now i can

extend this this one is a lemon so i get

an output of yes

now there's some other ways in which we

can use the if function

so let's say if we have some numbers 15

25 50

and 84.

so let's say if

equals if

cell

b9

let's say if that is

greater than

30

if that statement is true

i want excel

to basically perform a calculation

rather than saying yes or no

and so that calculation will be

let's see

if it's true i want excel to multiply

b9

by

10.

if it's false

i want it to return a value of zero

and so in this case

b9 is not greater than 30 15 is less

than 30 so i got a value of zero and now

let's extend it

here

50 is greater than 30 so

this cell it performed the calculation

that i wanted to do that is 50 times 10

i got 500

and here 84 is above 30 so it multiplied

84 by 10 giving me 840.

now let's do something else so let's do

if

and let's start with b9 again

so let's say b9 is less

than 30. so this time

i'm gonna want excel

to basically take b9

and multiply it by

or rather subtract it

by 10. let's do something different and

if it's false

i want it to

divide

b9 by 10.

so here

we know that 15 is less than 30 so we

have the true statement

and thus we're going to subtract the 9

by 10 giving us 5

and this is less than 30 so we do 25

minus 10 giving us

15.

now

for this statement is false so we get

the calculation that's involved with the

false statement

50 is not less than 30. so for the false

statement i wanted cell b11 to be

divided by 10. so 50 divided by 10 is 5

and the same is true for this one 84

divided by 10 is 8.4

and so you can

make excel perform certain calculations

if the information in this cell is true

or false based on your parameters

so let's say if

we're analyzing this cell and let's say

it has two options yes or no

so we can write

if cell

b14

let's say if it's yes so let's put that

in quotations

so if we have a yes entry in cell b14

what we're going to do is we're going to

take the sum

of this column

and if the statement is false meaning

let's say if we don't have a yes

such as let's say if we have a no

then instead of taking the sum

i'm going to take the average

of this column

so this is a yes

which means

i get the sum of those numbers so if i

type in equal

15 plus 25 plus 50

plus 84 i get 174. now if i type in no

i'm going to get the average instead so

if we type in equal

average 15

25

50 and 84

you'll get 43.5

and so by changing yes or no i can

basically cause excel to perform a

certain calculation

the calculation if the statement is true

in this case sum or the calculation if

the statement is false in this case

average

and so that's how you can use the if

function

in excel

now number nine

is the vlookup function

so that's the next one we're going to

talk about

so how can we use the vlookup function

well first let me

fill in some information so we're going

to write the name of the individual

the email address

let's say a phone number

and also their annual

revenue

i'm gonna have to make this column

bigger and this one

smaller

so let's say once again we have john

smith let's say

lucy johnson

aaron

clark

david wilson

and

ronald james

let's say the email for this person

john.s at msn.com

let's say

lucy

well

i don't want to do that

let's say lucy j at

live.com

and then erin.c

gmail.com

david w

at

hotmail.com

and finally ronald

dot j ads

let's say

yahoo.com

and let's fill in some numbers so let's

say this is 2

4 3

and then 1 125-7463

you could fast forward this if you like

i'll be done shortly

and let's say the revenue

for john is

56 000 per year

and lucy's revenue is

74 000 per year

and aaron's revenue is

82 000 per year let's say david

is 93 000 per year and ronald is

let's say 47 000 per year

now let's talk about how we can use the

vlookup function to look up information

for these individuals

and so here we're going to have the

person's name

email

phone number

and revenue

so let's say we want to look up

john smith

now let's look up his email address

using

the vlookup function

so if you type in equal vlookup

parentheses

notice that you have this lookup value

and it's going to be whatever we look up

in cell c8

next we have the table array

so let's select

this entire table

and then the column index number

so column a is not the first

column

because we only the first column is

column b because that's the first

selection in our table array

now the email address is in column c

which is our second column that is

highlighted

and the range we have two options true

or false but we're going to choose false

for an exact match

and so we have john's email john.s

msn.com

so if we change his name to let's say

lucy

johnson

automatically the email address will be

updated

now let's adjust the vlookup function

for the next cell

so the lookup value will still be cell

c8

the table array will be the same

and the column index number

will now be column three for the phone

number that's column d

that's the third column that is

highlighted

and then let's choose false

for an exact match

and so we get lucy's number three five

two four five two

nine seven two one

now the last thing we're going to look

up is the revenue

so our lookup value is still cell c8s

this same table array

column index number

the fourth column that is highlighted

and then

let's choose false again

so her revenue is 74 000. and let's

adjust the number format

let's click more counted formats

and then let's put currency with zero

decimal places

so her revenue is seventy four thousand

so if we change the name from lucy

johnson

to let's say erin clark

we're going to get all the information

for erin clark her email address phone

number and her annual revenue so that's

how you can use the vlookup function

the next one that we're going to talk

about number 10

is the use of a drop down list

now the reason why this is useful is

because let's say if you don't want to

type in the information if you want to

just pull the name from a drop down list

you can do that

and so a quick and simple way to make a

drop down list

is to click data

and then go to data validation

and then under the section validation

criteria

allow a list

instead of any value and then you can

type in the names that you want or you

can click in this button and then

selects these names

and then press enter

okay and now we have a drop down list

so if i select john smith it

automatically updates

if i select lucy johnson as you can see

it updates or

david wilson

i can get his email phone

and revenue or finally ronald james

and so that's the 10th useful feature

in excel

and so that's it for this video

hopefully you found it to be helpful

and if you want to find

more detailed videos that i have on

vlookup drop down lists

if functions and other stuff like that

check out the description section of

this video

and

you can find my excel video tutorial

playlist

you can also check out my channel

if you want to

find help in other topics let's say if

you're going back to school and you want

to learn algebra geometry trig precal

calculus chemistry physics i do have

playlists on those topics as well so

thanks again for watching

you