top 5 advanced function in excel which is very useful formulas

Top 5 Advanced Functions in Excel- Useful Formulae

VLOOKUP | IF | AND & OR | IFERROR | CONCATENATE – Top 5 advanced functions in Excel These functions are the top 5 advanced functions in excel. These are very helpful or useful to solve real-world problems. These are very complex formulae to learn. we will try to explain with examples. 1-VLOOKUP (Vertical Lookup) […]

cell reference in excel

What is a cell reference? and how do we use in excel?

To learn reference in excel is very important. Sometime Interviewer asks some questions like what is cell reference and how to use it and he can also ask you that what is the difference between relative or absolute cell reference? There are four types of references relative reference, absolute reference or fixed reference, mixed reference […]