Watch the video above...
#SubtotalFormula #AggregateFormula #ExcelFormula
There are many excel formula are used in data analysis, subtotal and aggregate function are special of its own due to its ability to perform multiple #mathematical operations.
In this video we have explained about below four formula,
1. #SubtotalFunction
2. #AggregateFunction
3. #LargeFormula
4. #SmallFormula
All four formula are very useful in #dataanalysis using Excel and plays a vital role in dynamic #ExcelDashboard so it is very important to know these formula
00:00 Intro
00:31 Subtotal function
01:53 Aggregate function
04:19 Large Formula
05:01 Small Formula
05:41 Large / Small calculation with Aggregate Formula
06:54 Conclusion
If you have any queries or comments you can post it comment section...
No comments:
Post a Comment