When you want to find and copy files of specific types using Google Apps Script from a folder to another folder on Google Drive, this code for sure will come handy. As you know Google Apps Script has a functionality of running it automatically on a particular time (time driven trigger) or even driven trigger(like […]
Performing Pareto Analysis using Tableau and Microsoft Excel
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 […]