How to Create Interactive Dashboard in Excel | 5 Steps to Create Interactive Dashboard in Excel

Interactive dashboard in excel

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

25 Helpful Statistical Functions of Excel | Statistical Functions with Example

Statistical Functions of Excel

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

How to use ANOVA with Excel | 4 Easy steps for One Way & Two Way ANOVA in Excel

How to Use ANOVA with Excel

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

What is ANNOVA | Analysis of Variance | One Way ANNOVA Test | 7 Steps for ANNOVA

What is ANNOVA

ANNOVA is an inferential statistical method to find out the difference between two data sets. It is a most useful test methodology among researchers and data analyst. ANNOVA is used for the fields of research and study like economics, statistics, biology, psychology and marketing study and many more. It can be performed by manual calculation … Read more

16 Effective Tips for PowerPoint Presentations | How to make good PowerPoint Slides

Tips for PowerPoint Presentation

Presentation is the end objective or finishing point for a data analyst. As a data analyst, you need to communicate your finding and insights to the stakeholders. So, it is one of the important skill for data analyst. You may present it in the form of text, table, chart, graphs, videos etc. Now, Microsoft PowerPoint … Read more