Raj Kumar

Learn how to make a scatter chart in Excel to find the correlation between two variables, i.e. how one variable is affected by the other.

By default, Excel disables all macros to protect you from malicious viruses. But you can enable macros to automate repetitive tasks in Excel.

VLOOKUP function in Excel looks for a value in a range of cells, then it returns a value that’s in the same row as the value you’re looking for.

Learn how to transpose data in Excel and quickly shift the orientation of your columns and rows on a worksheet.

With VAR.S and VAR.P functions you can calculate sample variance and population variance from given data in Excel 2010 and later versions.

Learn how to use Excel’s AutoFit feature to automatically adjusts the column width or row height in a worksheet.

Learn everything about creating and formatting a Pie chart in Excel.

Learn how to split cells in Excel into multiple columns using Text to Columns feature, Flash Fill, or Excel formulas.

You can easily create a histogram using the Data Analysis ToolPak or the built-in histogram chart in Excel.

Learn how to unhide specific rows, all rows, specific columns, and all columns in Excel to reveal all the hidden data.

Sorting Data helps in organizing or arranging the data in a specified order to find values quickly. You can sort…

In Excel, you can divide within a cell, cell by cell, columns of cells, range of cells by a constant…

Microsoft Excel’s Wrap Text feature can wrap text so it appears on multiple lines in a cell, even if it overflows the cell boundary.

Create a drop-down list of items in Excel to make data entry easier, faster and error free. With Excel’s Data Validation feature, you can easily create drop down lists to enter data on a worksheet or workbook.

Assuming you have a large amount of data in excel. When scrolling down or scrolling horizontally, you don’t want to…

In Microsoft Office Excel, one main issue many users encounter is getting duplicate values and rows. Finding and removing duplicates…

Suppose you’ve worked on very important financial records on a worksheet, and you’ve shared that sheet with your fellow employees…

Multiplying values is one of the basic arithmetic operations that is frequently performed in Excel. There are several ways you…

There are various arithmetic functions that you can execute in Excel, including addition, subtraction, division, and multiplication. And subtraction is…

Graphs and Charts make it easy to visualize data in a clear, easily digestible, and appealing manner. Why go through…