Share [Social9_Share]

Learn 100 Excel Formulas

 

EXCEL FUNCTIONS

Recently I conducted a survey, to find out what are your pain points while using Excel in everyday work. I found that a majority of us struggle with writing Excel Formulas. Hmm… So I spent a few days recording ex-plainer videos for about 100 most used functions in Excel.

I have explained each formula

  1. In a very simple manner
  2. Plus given you some must know rules (wherever applicable) that you should keep in mind when you use these formulas
  3. The Downloadable Excel file used as a case in the video

 

As of now I have completed about 40 of the 100 videos and will wrap the remaining in a few days. AND YOU MUST BOOKMARK THIS PAGE

 

LOGICAL FUNCTIONS

  1. IF Function
  2. Learn how the NESTEDIF Function works also read a related article on IF, AND & Boolean Logic
  3. AND Function in Excel (Also combined with IF)
  4. OR Function
  5. NOT Function
  6. IFERROR Function

 

LOOKUP FUNCTIONS

  1. VLOOKUP Function (The Basics and getting started)
  2. MATCH Function
  3. INDEX Function
  4. HLOOKUP Function
  5. OFFSET Function also read a detailed post on applications of OFFSET Function
  6. CHOOSE Function
  7. HYPERLINK Function
  8. TRANSPOSE Function
  9. ROW Function also read an application of Row Function
  10. ROWS Function
  11. COLUMN Function
  12. COLUMNS Function
  13. ADDRESS Function
  14. AREAS Function

 

MATH FUNCTIONS

  1. SUMIF Function
  2. CEILING Function
  3. FLOOR Function
  4. EVEN Function
  5. ODD Function
  6. INT & MOD Function
  7. QUOTIENT Function
  8. RAND & RANDBETWEEN Function

 

STATISTICAL FUNCTIONS

  1. AVERAGE Function
  2. AVERAGEIF/AVERAGEIFS Function
  3. COUNTIF/COUNTIFS Function
  4. MAX & MIN Function

 

TEXT FUNCTIONS

  1. CLEAN & TRIM Function
  2. CONCATENATE Function

 

DATE AND TIME FUNCTIONS

  1. DATE Function
  2. DATEDIF Function – Blog Post
  3. DAY, MONTH & YEAR Function
  4. EDATE & EOMONTH Function
  5. NETWORKDAYS.INTL Function
  6. WORKDAY.INTL Function

 

FINANCIAL FUNCTIONS

  1. IRR Function – Blog Post
  2. XIRR Function – Blog Post
  3. MIRR Function – Blog Post

 

If you have any questions, please put them down in comments and your suggestions are more than welcomed! Cheers

  • ATHUKURU MANIKANTHA

    Hi chandeep…very happy to see all the functions at one place..great work..i am just wondering how much time u might have spent making such an awesome work. Just loved it.

    • Thanks Man! Glad you liked it.. Don’t ask about the work that has gone to deliver these to you.. Just enjoy! Let me know if you need any help

  • Samah

    Great work, all functions are useful for me, thanks a lot

    • Thanks Man!! Glad you liked them. Let me know if you need help with anything

Chandeep Chhabra

Popular Posts

© Goodly