Raj Kumar

Author
27Articles
Scatter Chart

How to Make a Scatter Plot in Excel

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.

Automate macros

How to Enable Macros in Excel

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

Excel

How to Use VLOOKUP 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.

Transpose

How to Transpose in Excel

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

Variance

How to Calculate Variance in Excel

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

Resize

How to Autofit in Excel

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

Pie Chart

How to Make a Pie Chart in Excel

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

Split Cells

How to Split Cells in Excel

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

Histogram

How to Make a Histogram in Excel

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

Excel sheet

How to Unhide Rows and Columns in Excel

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

Sort

How to Sort in Excel

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

Divide

How to Divide in Excel

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

Excel sheet

How to Wrap Text in Excel

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.

Table list

How to Create a Drop Down List in Excel

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.

Freeze spreadsheet row column

How to Freeze Panes in Excel

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

Duplicate files

How to Remove Duplicates in Excel

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

Terminal

How to Change Default Starting Directory in Windows Terminal

Released in 2019, Windows Terminal is a new, fast, and powerful multi-tabbed command-line application developed specifically for Windows 10 users….

Spreadsheet

How to Lock Cells in Excel

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

Multiply

How to Multiply in Excel

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

Excel sheet

How to Subtract in Excel

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

Spreadsheet Graph

How to Make a Graph in Excel

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