Pareto Analysis also called as 80/20 rule, is a decision-making technique which states that 80 % effects of things happen in the system, arises from 20 % causes. Consider below two examples to understand better: 80 % of your profit came from 20 per cent of Products you sold 80% of issues in your website/business […]
Top 20 Advanced Excel formulas for Data Analysis
Recently released Microsoft Excel 2016 version has 484 functions, out of these, 360 existed prior to Excel 2010. Here in this post, i have gathered most used advanced Excel formulas for Data Analysis in industry. Microsoft Excel since after released in 1987 and after version 5 which was released in 1993, became the widely applied spreadsheet […]