Top 100 Excel Functions with Examples + Sample Files

Top 100 Excel Functions with Examples + Sample Files2018-12-08T09:27:00+00:00

For this, I have this comprehensive list for you.

In this list, you can find Top 100 Excel Function with Examples.

Every single function in this list is explained in a way that you can learn it in no time.

Here’s how this function guide can help you to master some of the most useful functions.

  • First of all, you will learn what's the purpose of a function and it's syntax.
  • Next thing is some important information about it.
  • And in the end, its usage through a simple example so that you can use it in real life.

...without any further ado here's the list of most useful functions you need to learn.

Text

Date

Time

Logical

Maths

Statistics

Lookup

Financial

Information

Content Protection by DMCA.com

72 Comments

  1. Devendra Chavan 29 Nov, 18 at 10:02 am - Reply

    Hi Puneet,

    I want to learn macro VBA step by step please help me.. you are doing really great job

  2. KS Narayanan 29 Nov, 18 at 9:21 am - Reply

    Thanks a lot.

  3. sujata 26 Nov, 18 at 10:19 am - Reply

    Thank you so much puneet. It is very nice tutoral.

  4. suvarna 15 Nov, 18 at 4:53 am - Reply

    Its vry usefull. Nice info.

  5. suvarna 15 Nov, 18 at 4:52 am - Reply

    Its vry usefull

  6. Chethan Kumar 14 Nov, 18 at 6:52 pm - Reply

    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)

  7. Sanjay Bhatt 13 Nov, 18 at 6:12 am - Reply

    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.

  8. elrey 10 Nov, 18 at 1:35 pm - Reply

    (Maraming salamat po sayo Puneet..) Thank you so much Puneet. It’s a great help for me to learn more from you

    • Puneet Gogia 13 Nov, 18 at 5:25 am - Reply

      You’re Welcome.

  9. Augusta 10 Oct, 18 at 10:42 am - Reply

    Thank you so much

  10. Khurshid 9 Oct, 18 at 9:45 am - Reply

    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.

  11. deepak 9 Oct, 18 at 7:25 am - Reply

    my self deepak,
    thanks for this, good job
    kindly provide advance vba/excle programes

  12. Santhu ycs 9 Feb, 18 at 3:35 pm - Reply

    Great Puneet.. You made wonderful work to make everyone expert in Excel.

  13. Karan Jauhar 24 Jan, 18 at 11:48 am - Reply

    I want to have an example as well after explaining

  14. ahmed reza 21 Jan, 18 at 10:35 am - Reply

    after long time i find such amazing summary about excel function …thanxs alot sir

  15. Gopal Prasad 19 Jan, 18 at 8:59 am - Reply

    Gogia sir, plz suggest solution, if any

  16. Gopal Prasad 19 Jan, 18 at 8:57 am - Reply

    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

    • Puneet Gogia 19 Jan, 18 at 7:56 pm - Reply

      You have already sorted in above snapshot?

      • Gopal Prasad 20 Jan, 18 at 5:07 am - Reply

        Sir it was done manually just to let you explain my actual need, please suggest function, if you can help in this regard.

  17. Naveen Kumar 22 Dec, 17 at 6:05 am - Reply

    please give formulas and function in the pdf formet

  18. Naran 5 Dec, 17 at 5:13 am - Reply

    Thanks Puneet for your support

  19. Umesh Misra 24 Nov, 17 at 7:10 am - Reply

    Very useful tips like camera option, Picture graph thanks a lot

  20. NIKHIL PARMAR 23 Nov, 17 at 6:15 pm - Reply

    Thanks a lot for providing a helpful resources. You did a excellent job. Thanks again…

  21. WaywardSailor 22 Nov, 17 at 7:39 pm - Reply

    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.

  22. G G AMBWANI 22 Nov, 17 at 9:02 am - Reply

    How to get data of various sheets on Summarry sheet of the inventory register.

  23. Satheesh Kumar.Ps 22 Nov, 17 at 8:48 am - Reply

    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 ..

  24. sunil mishra 31 Oct, 17 at 6:12 am - Reply

    How Can I creat a daly sale report in excel
    please help me

  25. Emmanuel Martins Udu 25 Oct, 17 at 8:19 pm - Reply

    Puneet, you are simply amazing.

  26. Ryan 24 Sep, 17 at 7:09 am - Reply

    Thanks It is very useful to know which formula where to use. Thanks Puneet Bro

  27. Om 21 Sep, 17 at 6:32 am - Reply

    Hi,
    Please provide the link for Inv. Management System

  28. Sathishkumar Manasa 11 Sep, 17 at 10:26 am - Reply

    very nice useful puneet how i download this excel function book

  29. Sudhir Kumar 8 Sep, 17 at 7:28 pm - Reply

    How can I create a timezone convertor??

  30. Abhishekkumar Jasoriya 4 Sep, 17 at 1:45 pm - Reply

    Thanks punnet for providing such a good platform to learn excel

  31. Ron007 22 Jul, 17 at 12:07 pm - Reply

    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

  32. Binaya Karmacharya 6 Jan, 17 at 5:04 pm - Reply

    with transpose function can we reverse the data set; like AAA, BBB, CCC transpose to CCC,BBB,AAA. Thanks

  33. ratanak 12 Nov, 16 at 2:52 pm - Reply

    Hi Puneet I think it is great if you combine these formulas in one store in PDF it is really awesome

  34. rathanak 17 Aug, 16 at 10:38 pm - Reply

    I’d love it.but it will be nice if you combine it in a one PDF file 🙂

  35. Bj Sutton 4 Aug, 16 at 4:16 am - Reply

    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)

    • Puneet Gogia 4 Aug, 16 at 4:21 am - Reply

      Try,
      =TEXT(10:01-09:42,”HH:MM:SS”)

  36. Heather 11 Apr, 16 at 1:17 pm - Reply

    SUBTOTAL – which I find is a powerful function, but often overlooked – particularly with the different function numbers that formula uses.

    • Puneet Gogia 11 Apr, 16 at 1:55 pm - Reply

      Fully Agree With You. Thanks

  37. Dan Kordelski 11 Apr, 16 at 1:08 pm - Reply

    GETPIVOTDATA, I haven’t nailed that one yet…dan.kordelski@gmaildotcom

    • Puneet Gogia 11 Apr, 16 at 1:55 pm - Reply

      Thanks Dan.

  38. Mohammed Mubin Sayyed 11 Apr, 16 at 5:46 am - Reply

    OFFSET and exact use of Array with detailed example.

    • Puneet Gogia 11 Apr, 16 at 1:55 pm - Reply

      Thanks Mohammed Mubin Sayyed

  39. iyke 10 Apr, 16 at 3:20 pm - Reply

    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.

    • Puneet Gogia 10 Apr, 16 at 5:15 pm - Reply

      Yeah Iyek. I am trying to give two different examples. one is solo & other is combined with some other function.

      • iyke 10 Apr, 16 at 5:41 pm - Reply

        Great! Puneet. I am looking forward to this.

  40. iyke 10 Apr, 16 at 12:44 pm - Reply

    OFFSET/MATCH AND ROW/COLUMN

    • Puneet Gogia 10 Apr, 16 at 1:32 pm - Reply

      Thanks Iyke.

  41. Peter Wilson 10 Apr, 16 at 6:41 am - Reply

    Index or match

    • Puneet Gogia 10 Apr, 16 at 7:21 am - Reply

      Thanks Peter

  42. Asif Hafeez 10 Apr, 16 at 5:29 am - Reply

    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.

    • Puneet Gogia 10 Apr, 16 at 7:22 am - Reply

      Thanks Asif.

  43. Angel Gonzalez 10 Apr, 16 at 4:02 am - Reply

    I would really like to have a better understanding of the Indirect with Row and/or Columns function. Could we include these please.

    • Puneet Gogia 10 Apr, 16 at 7:22 am - Reply

      Thanks Angel

  44. Srinivasan Venkatraman 10 Apr, 16 at 3:07 am - Reply

    Offset plays a vital role

    • Puneet Gogia 10 Apr, 16 at 7:22 am - Reply

      Thanks Srinivasan

  45. Diana 10 Apr, 16 at 2:51 am - Reply

    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!

    • Puneet Gogia 10 Apr, 16 at 7:23 am - Reply

      Alright Diana. Thanks for your reply.

  46. Brenda G 9 Apr, 16 at 8:02 pm - 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!

    • Puneet Gogia 9 Apr, 16 at 10:27 pm - Reply

      Thanks Brenda. I will for sure.

      You’ll get your E-book on 30 Apr

  47. Torstein S Johnsen 9 Apr, 16 at 7:15 pm - Reply

    i would like to Get a good description of the match function and/or the choose function. Thanks Torstein (sejohnse@yahoo.no)

    • Puneet Gogia 9 Apr, 16 at 7:29 pm - Reply

      Hey Torstein,

      You will get the both.

      Thanks for words.

      You’ll get your E-book on 30 Apr

  48. Eanna 9 Apr, 16 at 4:03 pm - Reply

    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

    • Puneet Gogia 9 Apr, 16 at 4:16 pm - Reply

      Hello Eanna,

      Already Added.

      Thanks for your comment. You’ll get your E-book on 30 Apr

  49. Gautam Bhardwaj 10 Mar, 16 at 9:42 pm - Reply

    very helpful, i really appreciate. keep it up Bro

    • Puneet Gogia 11 Mar, 16 at 10:44 am - Reply

      Thanks Gautam

  50. Rohit Sharma 8 Mar, 16 at 7:57 am - Reply

    Nice to see the whole functions list..would appreciate if you let us know the complete descriptions of all functions.

    • Puneet Gogia 8 Mar, 16 at 11:48 am - Reply

      Hello Rohit,

      List will be updated before next week. Please Subscribe to our newsletter to get the alert for that. You can also download 100 Keyboard Shortcuts, 40 Useful Excel Tips & 40 ready to use macros.

      http://www.excelchamps.com/newsletter.html

  51. Inet Kemp 21 Feb, 16 at 6:39 pm - Reply

    Great to have such a summary available

    • Puneet Gogia 11 Mar, 16 at 10:44 am - Reply

      Thanks Inet

Leave A Comment