ADDRESS Function:Creates a valid cell reference as per the supplied row and column.
AREAS Function:Counts the number of ranges in the supplied reference.
CHOOSE Function:Returns a value from a list of values using the index number.
COLUMN Function:Returns the column number of the referred cell.
COLUMNS Function:Count columns referred to in the supplied range.
FORMULATEXT Function: Returns the formulas from the cell referred to.
HLOOKUP Function: Lookups for a value in the top row of a table and returns the value from the same column using an index number.
HYPERLINK Function:Create a text with the hyperlink using the link specified.
INDEX Function:Returns a value from a list using the index number of that value in the list.
INDIRECT Function:Create a valid cell reference from the text supplied.
LOOKUP Function:Lookup for a valuer from a row, column, or array.
MATCH Function:Returns the index number of the value from the list of values.
OFFSET Function:Returns a reference to a range which is a specific number of rows and columns away from a cell or range of cells.
ROW Function:Returns the row number of the referred cell.
ROWS Function:Count rows referred to in the supplied range.
TRANSPOSE Function:Changes the orientation of a range.
VLOOKUP Function:Lookups for a value in the first column of a table and returns the value from the same row of the matched value using the index number.
108 thoughts on “Excel Functions List (Top 100) Examples + Sample Files”
I fancy EXCEL & where ever possible I try to programe it. PLEASE help me with all the functions & their examples. Have done it for Numerology, Family genealogy, now Family trust fund am stuck with the “AND” function of using it. Please help me.83 years age. NO Website, wish I can develop one.
This is very useful, but I often don’t have access to the internet when I am working in Excel. Could you make this information in a PDF file, so that it would be accessible offline?
This is very useful, but I often don’t have access to the internet when I am working in Excel. Could you make this information in a PDF file, so that it would be accessible offline?
Hi, I find your Excel tips very useful. It helps me a lot. Tips likes this give me a lesser time to search for the uses and functions of each formulas. Thanks a lot.
Thank you very much Mr. Punit Sir. I am computer faculty and recently I have asked to teach Excel functions and I find the complete list here. Could you possibly provide us the PDF format of all the functions with examples to use. Thank you.
Thanks a lot for sharing your knowledge with us with clear explanation. Your blog is my guru. All your excel tips are being very useful for my work. Thanks again.
I am very thankful to you as you have start this learning portal for all. And thanks for giving ur stuff from this web portal i will be able to use excel smartly and efficiently. I learn so far with this really Excellent work ur doing Thanks a lot again.
Thank you so much Puneet Gogia and nice to see the whole functions list in online,it is helpful to me.I’m really appreciate to you… i want to learn VBA pls need you guideline (confusion in coding)
I am very thankful to you as you have start this learning portal for all. In my office people are jealous they don’t give me chance to learn excel and no one guide me how to use excel smartly even though many of them are working smartly in excel. But from your this web portal i will be able to use excel smartly and efficiently. Thanks a lot again.
It will be better if you put more information about Excel macros. Thank you for your contributions in order to make people’s working lives easier. Keep up the good work.
Are these available in a PDF or Word File? This is a good reference, but it’s hard to remember to come back here for the information. Having them as something you can download would be really helpful.
Thank you for the valuable information…I would like to know one specific thing. Once we use the transpose, only values are copied. If i want to retain the values with formula in transpose function, is it possible. This is very important to keep scientific way to prove that the transpose operation done is correct. In data analytics big excel sheets are handled and a small mistake can lead to big problems .. Please advise me ..
Punnet thanks, May I suggest this, an average subscriber fairly uses excel and functions but in isolation. Every one knows match, offset etc what most need is the combination of these functions to generate more potent practical problem solving forces is the next step I will like you to do after these functions in isolation.
I would love others to learn these functions “Indirect, Offset, Match, Index, Vlookup, Mid, Find, Replace, Substitute, Sumif, Sumifs, SumProduct mainly and of course array functions as well.
Hi Puneet, I saw someone at work using both the INDEX and MATCH functions. I see that someone has already requested MATCH so if possible, I would like to see INDEX added to the list. Thank you!
Hello again, Puneet (and congratulations on your 1st 1,000 subscribers)! I would like to see the IFERROR function covered. I am just learning about it, so all lessons are greatly appreciated. Thank you for asking!
I fancy EXCEL & where ever possible I try to programe it. PLEASE help me with all the functions & their examples. Have done it for Numerology, Family genealogy, now Family trust fund am stuck with the “AND” function of using it. Please help me.83 years age. NO Website, wish I can develop one.
Where do you get stuck?
Where do you get stuck?
This is very useful, but I often don’t have access to the internet when I am working in Excel. Could you make this information in a PDF file, so that it would be accessible offline?
Please help. I have a column with a title.
If it has been checked how to I copy the title to another cell?
Thank you very much
Thank you sir I must so help ful.
=search(“9″,”99 9000”) = result is 1
How about another “9” position? What is formula?
Sir, 2nd Sept.2019.
Really you have shown very clearly and deeply all points.
I must thank you.
Hoping to receive more articles in future too.
Kanhaiyalal Newaskar.
Thank you for your generosity.
NICE, REALLY HELPFUL
Thank u
Thank you for working hard to help others. Your generous effort will be put into good use.
Thank you for your hard work for helping out us…
Use RANK function
This is amazing and very generous of you…many thanks…
You’re Welcome 🙂
This is very useful, but I often don’t have access to the internet when I am working in Excel. Could you make this information in a PDF file, so that it would be accessible offline?
Lavoro ottimo e ++ utile. Grazie e complimenti
nice information
we are here because you and your work is awesome. 😉
Keep on sharing. This help us a lot. Its a time save for us and no need to search each functions from net cause its already here.
Hi, I find your Excel tips very useful. It helps me a lot. Tips likes this give me a lesser time to search for the uses and functions of each formulas. Thanks a lot.
Very useful information..thank you sir
Sir, very useful information,notes and formula you have given.User like me would appreciate the work.
Once again thanks.
Thank you very much Mr. Punit Sir. I am computer faculty and recently I have asked to teach Excel functions and I find the complete list here. Could you possibly provide us the PDF format of all the functions with examples to use. Thank you.
Thanks a lot for sharing your knowledge with us with clear explanation. Your blog is my guru. All your excel tips are being very useful for my work. Thanks again.
GDay Punit
Needed a refresher, thanks for the info.
First of All.. Thank you for sharing the above info.. I fully appreciate this gesture..
A honest effort with intention of educating…. Really Super …………..
Hello Punit,
I am very thankful to you as you have start this learning portal for all. And thanks for giving ur stuff from this web portal i will be able to use excel smartly and efficiently. I learn so far with this really Excellent work ur doing
Thanks a lot again.
Thank you 🙂
Dear Puneet thanks, i want learn Macro in detail, can you help me
Thanks
Nitin
Please check each category. some files are not there or linked wrong
Dear Puneet,
Excellent work. Many files are not working or the link is wrong.
Thanks Rashid
Dear Puneet,
Excellent work. Many files are working or the link is wrong.
Thanks Rashid
Hi Puneet,
I want to learn macro VBA step by step please help me.. you are doing really great job
Thanks a lot.
Thank you so much puneet. It is very nice tutoral.
Its vry usefull. Nice info.
Its vry usefull
Thank you so much Puneet Gogia and nice to see the whole functions list in online,it is helpful to me.I’m really appreciate to you… i want to learn VBA pls need you guideline (confusion in coding)
Hi, Dear Punit,
I am very thankful to you as you have start this learning portal for all. In my office people are jealous they don’t give me chance to learn excel and no one guide me how to use excel smartly even though many of them are working smartly in excel. But from your this web portal i will be able to use excel smartly and efficiently. Thanks a lot again.
(Maraming salamat po sayo Puneet..) Thank you so much Puneet. It’s a great help for me to learn more from you
You’re Welcome.
Thank you so much
It will be better if you put more information about Excel macros. Thank you for your contributions in order to make people’s working lives easier. Keep up the good work.
my self deepak,
thanks for this, good job
kindly provide advance vba/excle programes
Great Puneet.. You made wonderful work to make everyone expert in Excel.
I want to have an example as well after explaining
after long time i find such amazing summary about excel function …thanxs alot sir
Gogia sir, plz suggest solution, if any
Sir it was done manually just to let you explain my actual need, please suggest function, if you can help in this regard.
https://uploads.disquscdn.com/images/0702942c4aa7355dffa9637ed2508ef37a5666306d6e3db4491e61dd4f600f9d.jpg there are 25 row in a column in which numbers are stored in-sequential like 0, 32,1,5,15,20,101,0,15,0,2,3,0………….. one figure in every one row, I need to allocate one serial number for all the duplicates that too in ascending order of the stored in-sequential figure, I want to apply sorting smaller to larger
You have already sorted in above snapshot?
please give formulas and function in the pdf formet
Thanks Puneet for your support
Very useful tips like camera option, Picture graph thanks a lot
Thanks a lot for providing a helpful resources. You did a excellent job. Thanks again…
Are these available in a PDF or Word File? This is a good reference, but it’s hard to remember to come back here for the information. Having them as something you can download would be really helpful.
How to get data of various sheets on Summarry sheet of the inventory register.
Thank you for the valuable information…I would like to know one specific thing.
Once we use the transpose, only values are copied. If i want to retain the values with formula in transpose function, is it possible. This is very important to keep scientific way to prove that the transpose operation done is correct. In data analytics big excel sheets are handled and a small mistake can lead to big problems .. Please advise me ..
How Can I creat a daly sale report in excel
please help me
Puneet, you are simply amazing.
Thanks It is very useful to know which formula where to use. Thanks Puneet Bro
Hi,
Please provide the link for Inv. Management System
very nice useful puneet how i download this excel function book
How can I create a timezone convertor??
Thanks punnet for providing such a good platform to learn excel
MS has already created a summary lists of all functions with links to brief descriptions.
functions (alphabetical) 2016-2007
https://support.office.com/en-us/article/Excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188
Functions (by category) – 2016 – 2007
https://support.office.com/en-us/article/Excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb
with transpose function can we reverse the data set; like AAA, BBB, CCC transpose to CCC,BBB,AAA. Thanks
Hi Puneet I think it is great if you combine these formulas in one store in PDF it is really awesome
I’d love it.but it will be nice if you combine it in a one PDF file 🙂
HI, is there any way to work out how long there is between 2 times? ie. 09:42 and 10:01 (that is, I want it to show 19 minutes)
Try,
=TEXT(10:01-09:42,”HH:MM:SS”)
SUBTOTAL – which I find is a powerful function, but often overlooked – particularly with the different function numbers that formula uses.
Thanks Dan.
GETPIVOTDATA, I haven’t nailed that one yet…dan.kordelski@gmaildotcom
OFFSET and exact use of Array with detailed example.
Thanks Mohammed Mubin Sayyed
Punnet thanks, May I suggest this, an average subscriber fairly uses excel and functions but in isolation. Every one knows match, offset etc what most need is the combination of these functions to generate more potent practical problem solving forces is the next step I will like you to do after these functions in isolation.
Yeah Iyek. I am trying to give two different examples. one is solo & other is combined with some other function.
Great! Puneet. I am looking forward to this.
OFFSET/MATCH AND ROW/COLUMN
Thanks Iyke.
Index or match
Thanks Angel
I would love others to learn these functions “Indirect, Offset, Match, Index, Vlookup, Mid, Find, Replace, Substitute, Sumif, Sumifs, SumProduct mainly and of course array functions as well.
I would really like to have a better understanding of the Indirect with Row and/or Columns function. Could we include these please.
Thanks Srinivasan
Offset plays a vital role
Hi Puneet, I saw someone at work using both the INDEX and MATCH functions. I see that someone has already requested MATCH so if possible, I would like to see INDEX added to the list. Thank you!
Alright Diana. Thanks for your reply.
Hello again, Puneet (and congratulations on your 1st 1,000 subscribers)! I would like to see the IFERROR function covered. I am just learning about it, so all lessons are greatly appreciated. Thank you for asking!
Thanks Brenda. I will for sure.
You’ll get your E-book on 30 Apr
i would like to Get a good description of the match function and/or the choose function. Thanks Torstein (sejohnse@yahoo.no)
Hey Torstein,
You will get the both.
Thanks for words.
You’ll get your E-book on 30 Apr
Hi, Can you add the sumproduct function. I want to know how you use it to bring back sums based on 3 or conditions. Thanks eannablack@gmail.com
Hello Eanna,
Already Added.
Thanks for your comment. You’ll get your E-book on 30 Apr
very helpful, i really appreciate. keep it up Bro
Nice to see the whole functions list..would appreciate if you let us know the complete descriptions of all functions.
Great to have such a summary available
Thanks Inet