Blog

22 Pins

DataWitzz

Excel Course

Free Excel Tutorial Online - Free Excel Course with Free Certificate

Microsoft

Range

How to modify Pivot Table data in Excel | Edit Pivot Table | How to change range of pivot table

How to modify a Pivot Tables in Excel | Edit Pivot Tables | Advance Pivot Table Techniques

the words match are written in black and white

How to use MATCH function in Excel

How 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. This function is very helpful when it works with other functions like OFFSET/INDEX. Let us understand the anatomy of excel MATCH function. #howtofindposition #index #matchinexcel #offset

an image of the microsoft excel file with different font and numbers on it, as well as

COUNT function in excel | COUNTIF Function Excel | COUNTIF Function Excel | COUNTIF FORMULA IN EXCEL

the words look like they are in different languages

Microsoft Excel

Looking Up

How to use HLOOKUP in Excel

How 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 requires 4 inputs as mentioned below: We will take an example to understand this in a better way. #findingvalue #hlookup #horizontallookup #howtogetvalue #lookup #vlookup

an image of a computer screen with numbers and symbols in the bottom left hand corner

What is a scatter plot: How to read it and method to create it in excel

What 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 how much one variable is affected by another. In the scatter plot, all data points are represented by dots in the plot. #excel2007 #excel2013 #excel2016 #howtocreatescatterplotinexcel #scatterchart

a graph is shown in the middle of an excel spreadsheet with blue dots

Bubbles

Germany

Bubble Chart: How to create it in excel

Bubble 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 at least three or more sets of data to represent in the chart. Out of these three dataset, two will be representing as X and Y axis #bubblechart #Bubblechartinexcel #chartandvisualisation #Chartsinexcel

an excel spreadsheet with multiple columns and numbers in the bottom left hand corner

Excel Pivot Table: How to use it and its basic understanding

Excel 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. In this article, we will be discussing the basics of Excel Pivot Table and step by step method to create Excel Pivot Table. What is an Excel Pivot Table We can think about Pivot Table as a report but it differs from the traditional

the left column is highlighted in the text box

5 must-know text functions you should know in excel

5 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. In this article, let's learn 5 must-know text functions to elevate our proficiency in excel. The formula that we will be learning is LEFT , RIGHT , MID , LEN and FIND. #find #left #mid #right #textfunctions #textfunctionsinexcel