As the name suggests, Root Cause Analysis deals with identifying the origin of a problem and finding a solution for…
FINDING AND REMOVING DUPLICATES IN EXCEL Have you ever encountered a situation where you see a lot of duplicated data…
STATISTICAL FUNCTIONS IN EXCEL People usually have love-hate relationship with statistics. When you get your formulas right you are in…
While using excel, there may be times when you want to keep the values same while copying formulas. This can…
What is Derivatives? Derivatives are defined as the type of security in which the price of the security depends/is derived…
What is an Annual Report: The single source of getting information about any company whether it is the past or…
" In my previous blog “ How to deal with Multicollinearity ”, I theoretically discussed about definition of multicollinearity and…
Are you a data analyst or looking for a career as a data analyst??? Well then, today's article is dedicated…
Duckworth-Lewis method(D/L method) is a mathematical function defined to set and calculate the target score for the team batting second…
Hashtags look cool when seen on Twitter or Facebook but as soon as they start appearing in Excel sheet, you…