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



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI