Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

102 Microsoft Excel Formulas & Functions Cheat Sheet [Free Download]

Do you use Excel Formulas daily at your job? Download my Excel workbook where I have listed 100+ common Microsoft Excel Formulas and Functions Cheat Sheet for your daily use.

Without Formulas, Microsoft Excel is just like a word processor. These are Excel formulas and functions that give life to the world’s most popular spreadsheet program.

People say if you learn 20-25 formulas, you can master Microsoft Excel. It is true in some sense. But I say at least learn these 102 Excel formulas; you will be a superuser of Excel.

Excel Formulas and Functions Cheat Sheet free download

Free download the Cheat Sheet

To make you able to use the workbook in your daily Excel, I have made the functions browse-able from one worksheet.

Download Cheat Sheet

Function Categories in the Cheat Sheet (Worksheet)

I have categorized the Excel functions into 10 broad categories:

IS FUNCTIONS

Under IS FUNCTIONS, you will find the cheat sheet of the following functions:

  • ISBLANK
  • ISERR
  • ISERROR
  • ISEVEN
  • ISODD
  • ISFORMULA
  • ISLOGICAL
  • ISNA
  • ISNUMBER
  • ISREF
  • ISTEXT
  • ISNONTEXT

CONDITIONAL FUNCTIONS

Under CONDITIONAL, you will find a cheat sheet of the following functions:

  • AVERAGEIF
  • SUMIF
  • COUNTIF
  • AVERAGEIFS
  • SUMIFS
  • COUNTIFS
  • IF
  • IFERROR
  • IFNA

MATHEMATICAL FUNCTIONS

Under MATHEMATICAL, you will find the cheat sheet of the following functions:

  • SUM
  • AVERAGE
  • AVERAGEA
  • COUNT
  • COUNTA
  • MEDIAN
  • SUMPRODUCT
  • SUMSQ
  • COUNTBLANK
  • EVEN
  • ODD
  • INT
  • LARGE
  • SMALL
  • MAX
  • MAXA
  • MIN
  • MINA
  • MOD
  • RAND
  • RANDBETWEEN
  • SQRT
  • SUBTOTAL

FIND & SEARCH FUNCTIONS

Under FIND & SEARCH, you will find the cheat sheet of the following functions:

  • FIND
  • SEARCH
  • SUBSTITUTE
  • REPLACE

LOOKUP FUNCTIONS

Under LOOKUP, you will find the cheat sheet of the following functions:

  • MATCH
  • LOOKUP
  • HLOOKUP
  • VLOOKUP

REFERENCE FUNCTIONS

Under REFERENCE, you will find the cheat sheet of the following functions:

  • ADDRESS
  • CHOOSE
  • INDEX
  • INDIRECT
  • OFFSET

DATE & TIME FUNCTIONS

Under DATE & TIME, you will find the cheat sheet of the following functions:

  • DATE
  • DATEVALUE
  • TIME
  • TIMEVALUE
  • NOW
  • TODAY
  • YEAR
  • MONTH
  • DAY
  • HOUR
  • MINUTE
  • SECOND
  • WEEKDAY
  • DAYS
  • NETWORKDAYS
  • WORKDAY

MISC. FUNCTIONS

Under MISC., you will find the cheat sheet of the following functions:

  • AREAS
  • CHAR
  • CODE
  • CLEAN
  • TRIM
  • LEN
  • COLUMN
  • ROW
  • EXACT
  • FORMULATEXT
  • LEFT
  • RIGHT
  • MID
  • LOWER
  • PROPER
  • UPPER
  • REPT
  • SHEET
  • SHEETS
  • TRANSPOSE
  • TYPE
  • VALUE

RANK FUNCTIONS

Under RANK, you will get the cheat sheet of the following functions:

  • RANK
  • RANK.AVG
  • RANK.EQ

LOGICAL FUNCTIONS

Under LOGICAL, you will get the cheat sheet of the following functions:

  • AND
  • OR
  • NOT
  • And XOR

If you find anything in my Excel Formulas Cheat Sheet workbook that has to be updated or edited, please let me know in the comments section. Hope it will help you to master Excel Formulas in an easy way!

Master Excel Formulas & Functions in Just 3.5 Hours!

with my FREE COURSE at Udemy.

Excel Formulas and Functions with Excel Formulas Cheat Sheet!

Read More: 

Kawser
Hello!
Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

54 Comments
  1. Reply Avatar
    Roger Kennedy Feb 15, 2016 at 8:31 AM

    Dear Kawser
    If is wonderful to have you share your love for Excel.
    When I tried to download your file it only brings me to your mailing list signup page which I’ve already filled out. Could you please send me either the file or a link.

    Thanks.

    • Reply Avatar
      Otto Korekt May 11, 2016 at 12:37 AM

      same!

      • Reply Avatar
        Kawser Jun 11, 2016 at 12:26 PM

        Please check the mailbox. I have sent you an email with the direct download link of the resources.

    • Reply Avatar
      Kawser Feb 15, 2016 at 12:07 PM

      Hi Roger,
      Please check your inbox. Sorry for the inconvenience you are facing.
      Thanks and regards.

      • Reply Avatar
        Gina Mar 4, 2016 at 5:40 AM

        I am having the same problem. I’ve checked my email and confirmed my sign-up but cannot find the download?

        • Avatar
          Kawser Mar 4, 2016 at 10:36 AM

          Hi Gina,
          Thanks for notifying me. I manually checked the whole process and found some problems. It is fixed now. Please check your inbox. I have sent you the link of the resource page.
          Best regards
          Kawser

        • Avatar
          Amar Dec 11, 2016 at 2:03 AM

          same issue here. plz send to my inbox. Thanks

  2. Reply Avatar
    moon Ahmmed Apr 4, 2016 at 4:51 PM

    Dear Kawser Bhai,

    When I tried to download your file it only brings me to your mailing list signup page which I’ve already filled out. Could you please send me either the file or a link?

    • Reply Avatar
      Kawser Apr 5, 2016 at 5:15 PM

      Please check your mail.
      Thanks and regards

  3. Reply Avatar
    Emmanuel Jun 10, 2016 at 4:26 PM

    Although I have been already subscribed, I cannot download the Macro ebook and the Functions. It always be required an email adress. If I insert it, I get an error that I’m already subscribed.
    Thanks

    • Reply Avatar
      Kawser Jun 11, 2016 at 12:23 PM

      Please check the mailbox. I have sent you an email with the direct download link of the resources.

  4. Reply Avatar
    Lilly Jun 29, 2016 at 11:45 PM

    Wonderful resource, unfortunately experiencing the exact same problem as the users above.
    Can you please send me a direct download link. Thank you.

    • Reply Avatar
      Kawser Jul 5, 2016 at 11:04 AM

      Please check your mail, Lilly.

  5. Reply Avatar
    Borb Jul 20, 2016 at 3:46 PM

    Yep subscribed but no email link!

    • Reply Avatar
      Kawser Aug 1, 2016 at 10:50 AM

      Borb,
      I tried to reach you to your email address but it is showing the mail cannot be reached.
      How can I help you?
      Regards
      Kawser

  6. Reply Avatar
    Cindy Veltkamp Aug 15, 2016 at 8:52 PM

    Already subscribed; would like the Formula Cheat Sheet. Please send link, thanks!!

    • Reply Avatar
      Kawser Aug 16, 2016 at 3:10 AM

      Please check your email.

  7. Reply Avatar
    Ang Mui Shiang Oct 13, 2016 at 10:10 AM

    Hi Kawser,

    Already subscribed, can you share the Formula Cheat Sheet. Thanks

    • Reply Avatar
      Kawser Oct 13, 2016 at 12:56 PM

      It’s sent, check your email.

  8. Reply Avatar
    A.Perez Oct 23, 2016 at 9:28 AM

    I clicked on the link, but nothing downloaded. Is there another option?

  9. Reply Avatar
    Tricia Oct 28, 2016 at 9:09 PM

    I had the same problem as everyone else. Embarrassing since I shared the link on LinkedIn. :O\

    • Reply Avatar
      Kawser Oct 28, 2016 at 9:30 PM

      Hey Tricia,
      I checked several times the link. There is no problem with the link 🙂 This is not a direct download link. You have to subscribe to get the cheat sheet. I hope you should not be embarrassed with the shared link.
      Best regards
      Kawser

  10. Reply Avatar
    Stef@n Oct 28, 2016 at 9:38 PM

    i’m always subcribed, but there is no email with a download-link :/

    • Reply Avatar
      Kawser Oct 28, 2016 at 9:39 PM

      Please check the email 🙂

  11. Reply Avatar
    Muhammad Sohail Ashraf Oct 29, 2016 at 1:16 AM

    subscribed but did not find any downlaod link?

    • Reply Avatar
      Kawser Oct 29, 2016 at 10:45 AM

      Please check your email, Sohail!

  12. Reply Avatar
    AKSHAY KALLUR Nov 4, 2016 at 10:10 PM

    I have subscribed and waiting for my download link. Kindly send the link to my email. I have an interview later in the day. Thank you, Kawser.

  13. Reply Avatar
    Kaz Kalita Nov 12, 2016 at 1:20 AM

    Hello,

    I just subscribed and would like the download link as well.

    Thanks,
    Kaz

    • Reply Avatar
      Kawser Nov 12, 2016 at 3:26 PM

      Please check your email, Kaz!
      Thanks.

  14. Reply Avatar
    Naren Feb 23, 2017 at 11:02 PM

    Hello Kawser

    I am facing issue on page script error. Please send me 100+Excel Formulas Cheat Sheet on my email id.

    Thanks

  15. Reply Avatar
    RAOBMSP Mar 3, 2017 at 11:34 AM

    Excellent support from this site.

    • Reply Avatar
      Kawser Mar 3, 2017 at 6:55 PM

      Thanks for your feedback 🙂

  16. Reply Avatar
    tejas Mar 16, 2017 at 1:26 AM

    Please send me the excel!

  17. Reply Avatar
    Kathy Mar 17, 2017 at 3:57 AM

    I subscribed! Please send me 100+Excel Formulas Cheat Sheet to my email

  18. Reply Avatar
    AD Mar 22, 2017 at 7:31 PM

    Nice

  19. Reply Avatar
    Liz Mar 25, 2017 at 3:01 AM

    Hello! I have subscribed to your newsletter, but am not able to find the link for the Excel Formulas Cheat Sheet. Please can you send? THANK YOU!

  20. Reply Avatar
    John Jones Jul 3, 2017 at 9:09 AM

    July 2017 and I’m having the same issue, no link to download the cheat sheet in my email

  21. Reply Avatar
    Sue Aug 10, 2017 at 8:34 PM

    I did not receive the download. 🙁

  22. Reply Avatar
    nick Aug 21, 2017 at 7:20 AM

    cannot find correct download link.

  23. Reply Avatar
    M.Rameez Nov 14, 2017 at 6:20 PM

    Hi Kawser
    I’m having the same issue, send cheat sheet on my Email address

  24. Reply Avatar
    juan rodriguez Apr 15, 2018 at 9:56 PM

    Having same issues as everyone else, could you please send me the download link\

    Thanks.

  25. Reply Avatar
    Ajeet Apr 26, 2018 at 1:34 PM

    Cannot download example file. It keeps directing me to mailchimp and then I’m seeing error because I’m already subscribed.

    • Reply Avatar
      Kawser Apr 26, 2018 at 8:28 PM

      Hi Ajeet,
      Then you can download it from the Excel Resources Page that you get in every email I send.
      Thanks.

  26. Reply Avatar
    Yohan Phillips May 30, 2018 at 3:31 PM

    No link please email I already subscribed. also like to say thank you very much for this in advace

  27. Reply Avatar
    Gidey Jun 12, 2018 at 9:23 PM

    Hello! thank you for your hard work … I have the same problem … I did register but wouldn’t allow me to download … could you please send me the link? My email is : gidey@clarkcountynv.gov

    • Reply Avatar
      Kawser Jun 13, 2018 at 12:36 PM

      Please check your email. I have sent the file. Thanks and sorry for the inconvenience.

  28. Reply Avatar
    Silk Jul 18, 2018 at 6:51 PM

    Can u send me link please

    • Reply Avatar
      Kawser Jul 18, 2018 at 8:17 PM

      It is sent. Check out your email.

      • Reply Avatar
        Irene St. A. Dec 8, 2019 at 7:51 AM

        Hello, I am struggling as well. can I have it too via email, please?

        • Avatar
          Kawser Dec 9, 2019 at 1:56 PM

          Please checkout your email. Thanks.

  29. Reply Avatar
    Bhagyesh Mehta Sep 29, 2018 at 10:18 PM

    can you please share the direct link..?

  30. Reply Avatar
    manu Oct 2, 2018 at 8:33 PM

    hlo sir can you please share me advance excel formulas list.

  31. Reply Avatar
    ahmer Sep 19, 2019 at 2:06 PM

    i dont download your cheat sheet why i m subscribe already

    Leave a reply