Data Analysis

Analysis ToolPak is a very powerful Microsoft Excel add-in which has a pack of tools you can use to do data analysis tasks such as ANOVA test, descriptive statistics, generating histograms and regression analysis. Total of nineteen analysis tool are there in this add-in that comes with the latest Microsoft Excel version which Excel 2019.

In this tutorial, we discuss how to do a regression analysis in Microsoft Excel.If you do not know where is the regression in excel, what are functions and methods we can use to do regression analysis and how to interpret the regression analysis results, this is the best tutorial for you.

This tutorial created using Microsoft Excel 2016. Other compatible versions are Excel for Office 365 Excel for Office 365 for Mac; Excel 2016; Excel 2019 for Mac; Excel 2013; Excel 2010; Excel 2007; Excel 2016 for Mac; Excel for Mac 2011. If you find any issues using Data Tables in those versions, please leave a

This tutorial created using Microsoft Excel 2016. Other compatible versions are Excel for Office 365 Excel for Office 365 for Mac; Excel 2016; Excel 2019 for Mac; Excel 2013; Excel 2010; Excel 2007; Excel 2016 for Mac; Excel for Mac 2011. If you find any issues doing regression analysis in those versions, please leave a

Microsoft excel Pivot table is a very powerful feature, if not the most powerful feature available for data analyzing and summarizing. But it is also a least understood feature by the most. I ask you to closely follow this tutorial series. Then, you will learn how easy to use the Pivot Table feature. May be

In the previous tutorial we learnt what is the pivot table feature in Excel. In this tutorial you will be able to learn how to create a Pivot Table. Let’s move straight into a simple example. This guide will be very easy and useful for you to understand the essential steps of how to create