Jun 3How to use MATCH function in ExcelHow to use MATCH function in Excel In this blog, we will be discussing MATCH function in excel. MATCH function basically helps in finding the position of a value. It will not fetch any number but will provide only the position of the lookup value in excel. …Howtofindposition3 min read

Jun 2How to use HLOOKUP in ExcelHow to use HLOOKUP in Excel HLOOKUP is one of the functions provided by Microsoft Excel which helps us find a value for a particular reference value. Its functions are the same as VLOOKUP, just the difference exists in terms of fetching data horizontally instead of vertically. This formula also…Findingvalue2 min read

Jun 1What is a scatter plot: How to read it and method to create it in excelWhat is a scatter plot? Scatter plots also known as scatter charts and scatter diagrams used to show relationships between two variables and the relationship between two variables is called their correlation. It’s a 2-D plot and it plots data points on a horizontal and a vertical axis to show…Excel 20072 min read

May 31Bubble Chart: How to create it in excelBubble Chart Bubble chart in excel is a variation of scatter plot. In scatter plot we use points for representation while in bubble chart data points represented by bubble. Like scatter plot, bubble plot is also not using category value as axis. We will use Bubble chart when we have…Bubblechart3 min read

May 30Excel Pivot Table: How to use it and its basic understandingExcel Pivot Table Pivot table is the most powerful tool of excel by which we can create a report or summarize our data in a very meaningful way. It is used usually with big datasets. …4 min read

May 295 must-know text functions you should know in excel5 must-know text functions Excel text functions are very useful in cleaning the data, extracting a part of data, joining the data, or searching the position of a word. Few are easy to use but some need the practice to use correctly. …Find5 min read

May 28Data Validation in Excel: How to use it,8 awesome uses of excel data validationData Validation in Excel Data validation in excel is a very useful tool. Its main functionality is to create constraints while data entry in excel. For example, we could put a constraint that no duplicate value should enter in a cell or column or the value entered in a cell…Datavalidation6 min read

May 28Data Validation in Excel: How to use it,8 awesome uses of excel data validationData Validation in Excel Data validation in excel is a very useful tool. Its main functionality is to create constraints while data entry in excel. For example, we could put a constraint that no duplicate value should enter in a cell or column or the value entered in a cell…Datavalidation6 min read

May 28Data Validation in Excel: How to use it,8 awesome uses of excel data validationData Validation in Excel Data validation in excel is a very useful tool. Its main functionality is to create constraints while data entry in excel. For example, we could put a constraint that no duplicate value should enter in a cell or column or the value entered in a cell…Datavalidation6 min read

May 27What is Sunburst and Treemaps charts: How to create these 2 in excelWhat is Sunburst and Treemaps charts Sunburst and Treemaps charts are hierarchical charts which is used to show multi level variable values. We will be using this chart type to compare parts to a whole, or when several columns of categories form a hierarchy. Let us take an example of…Excelcharts3 min read