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
8. TRANSPOSE Function
9. ROW Function also read an application of Row Function
10. ROWS Function
11. COLUMN Function
12. COLUMNS Function
14. AREAS 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