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
- In a very simple manner
- Plus given you some must know rules (wherever applicable) that you should keep in mind when you use these formulas
- 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
- IF Function
- Learn how the NESTEDIF Function works also read a related article on IF, AND & Boolean Logic
- AND Function in Excel (Also combined with IF)
- OR Function
- NOT Function
- IFERROR Function
LOOKUP FUNCTIONS
- VLOOKUP Function (The Basics and getting started)
- 5 VLOOKUP Formula Tricks
- 3 Common Mistakes in VLOOKUP – VLOOKUPHOBIA
- Lookup for Similar but not Exactly Matching Records
- How to Make your VLOOKUP Robust – A must watch!
- MATCH Function
- INDEX Function
- HLOOKUP Function
- OFFSET Function also read a detailed post on applications of OFFSET Function
- CHOOSE Function
- HYPERLINK Function
- TRANSPOSE Function
- ROW Function also read an application of Row Function
- ROWS Function
- COLUMN Function
- COLUMNS Function
- ADDRESS Function
- AREAS Function
MATH FUNCTIONS
- SUMIF Function
- CEILING Function
- FLOOR Function
- EVEN Function
- ODD Function
- INT & MOD Function
- QUOTIENT Function
- RAND & RANDBETWEEN Function
STATISTICAL FUNCTIONS
TEXT FUNCTIONS
DATE AND TIME FUNCTIONS
- DATE Function
- DATEDIF Function – Blog Post
- DAY, MONTH & YEAR Function
- EDATE & EOMONTH Function
- NETWORKDAYS.INTL Function
- WORKDAY.INTL Function
FINANCIAL FUNCTIONS
- IRR Function – Blog Post
- XIRR Function – Blog Post
- MIRR Function – Blog Post
If you have any questions, please put them down in comments and your suggestions are more than welcomed! Cheers
