In this blog, we have selected some of the important functions and charts with regards to excel. This blog specifically concentrate on select items.
To get the remainder value when we divide two numbers we use MOD function and this will be discussed here. As an alternative to the IF condition, we can use SWITCH function and you will learn everything about SWITH function here. Similarly, criteria based average calculation is also possible using AVERAGEIF function. For starters, they can learn simple formulas in excel.
On top of these functions, you will also learn about charts like BAR Chart and Scatter Chart creations as well.