Business Analysis Skills

In case you are sick of manually creating spreadsheets every time, you should learn how to create a template in excel. Excel templates can save you a lot of time because they have pre-designed worksheets. So you can easily modify … Read more

Are you tired of performing repetitive tasks in Excel in case you work on files every day? And if you need some automation on your excel tasks, then creating a button macro in Excel is the solution. In this article, … Read more

Covariance vs Correlation is two of the most common statistical concepts. However, many people use these terms interchangeably. And this is leading to confusion. In this article, we will explain the differences between covariance and correlation first. And we will … Read more

Covariance Matrix in Excel is a statistical measurement. And it indicates the degree of relationship between two random variables. In data analysis, it can measure the degree to which two variables change together. A covariance matrix actually contains the covariances … Read more

If you are working on data as a finance guy or as a admin in office, you should heard Countifs function probably. Because one of the essential functions is COUNTIFS Function in Excel. Because rather than simply counting what you … Read more

When you use Excel for data analysis jobs, COUNTIF with Multiple Criteria can be your daily buddy to help you. Because this complex yet flexible formula counts the number of cells when you impose rules and conditions. In many cases, … Read more

When it comes to working with Excel, one of the most common tasks is counting cells. You can use Countif function for cells that are not empty or blank. Excel default function COUNTIF can do this for you. So, how … Read more

Excel is an extremely good for organizing data in many conditions you want. One of the most popular function to apply conditions and criteria is the COUNTIF function. Now we will look at COUNTIF function and provide useful examples to … Read more