Raj Kumar

The fill handle copies the same values, formulas, or fills a series of dates, texts, numbers, and other data to a desired number of cells.

One of the most common error warnings users encounter in Excel is the ‘Circular Reference’. Thousands of users have the…

Simple ways you can use to delete empty rows in Excel spreadsheets in one go

This guide will show you how to alphabetize in Excel using the Sort and Filter feature, and formulas to arrange and format the data in order.

Password protection in Microsoft Excel is often used in workplaces to protect important data. Microsoft Excel allows users to protect…

In Excel, it is very easy to split first, middle, and last names that appear in the same column into separate columns by using different ways.

Goal Seek is one of Excel’s What-if Analysis tools that helps you to find the correct input value of a…

If you have data stored in a JSON file that you would like to convert into an Excel file, you can import it into Excel using Power Query.

A bar graph (also known as a bar chart) is a graphical representation of data as horizontal bars along two…

You can easily group worksheets in Excel, so you do not have to waste your time and work on them individually.

This article explains how to make and format a line graph in Excel to show trends or track data across multiple time periods.

Strikethrough (a.k.a strikeout) is a horizontal line drawn through the center of the text, often used to indicate a revision…

When you are working with large quantities of data, it’s easy to lose track of data and see them appear…

Learn how to copy formula to multiple cells, down a column, to non-adjacent cells, copy formulas with absolute or mixed cell references, etc.

Convert time to decimal in Excel – by using arithmetic calculations or CONVERT function or Excel Time functions (HOUR, MINUTE, and SECOND).

There are many ways to convert dates formatted as text into actual dates in Excel and this tutorial aims to explore them all.

There are five different ways you can convert numbers that are formatted as text into actual numbers in Excel.

Since Excel doesn’t offer built-in support for Gauge Chart/Speedometer, you need to create one by combining a doughnut chart and a pie chart.

Excel COUNTIF function allows you to count the number of cells that meet specific criteria or conditions in the given range.

Use TODAY and NOW function to get dynamic current date and time, and use keyboard shortcuts to get static date and time.