Many a times as data analyst, we are doing scenario planning or simulation. Let’s say (simple example) we have a target of revenue of 200, fixed unit price of 5 and need to tell how many units need to be sold to achieve the targeted revenue. You must be thinking that it can be achieved … Read more
Combine multiple excel files into one excel file may be a challenge for many excel users. Most of the times it is being done manually by using copy paste method, one after another. The challenge in the copy paste method is time. It is consuming too much time as one by one workbooks needs to … Read more
Dashboard creation is a demanding skill in the edge of data science. Interactive Dashboards are required to present a data set in the form of summary or report to users. We are encircled by various dashboards in our daily life or at workplaces. Dashboards are integrated part of smart phones, laptops, and smart watches. Moreover, … Read more
Statistical functions are must for data analyst when using excel as tool and using statistical methods. There are 110 statistical functions in Microsoft Excel. Out of those, there are 25 statistical functions which are useful and must learn for data analyst. In this article, 25 statistical functions of excel will be on descriptive analytics, predictive … Read more
ANOVA is one of the frequently used inferential statistical method to check the effect of an experiment or test. Like other statistical tools, excel also have the capability to perform ANOVA test. In this article, we’ll discuss that how to use ANOVA with excel. Moreover, 4 steps for one way and two way ANOVA with … Read more