As a business analyst, you must know the Excel functions and formula thoroughly. After working on something for hours, if you choose an incorrect formula, data analysis fails. It might seem easier to do a manual calculation than falling into the trap again.
Excel has over hundreds of formulas and functions. It is overwhelming to find the right match for correct analysis. However, if you get the basics right, it shouldn’t be a problem.
#1: SUMIF
In an Excel sheet, you can add cells easily. However, if you want additional cells only under certain conditions, SUMIF function can help.
It …




