How to create collapsible rows in Excel

You can watch a video tutorial here. When you have a large amount of data that runs into many rows and columns, you can group either the columns or rows […]

How to clear data validation in Excel

You can watch a video tutorial here.

How to delete extra pages in Excel

You can watch a video tutorial here.

How to split a row in Excel

You can watch a video tutorial here.

How to clear contents in Google Sheets

You can watch a video tutorial here. Google Sheets is a popular spreadsheet application that has many options for formatting cells. When working with Google Sheets, you may want to […]

How to alphabetize on Excel

How to Concatenate with space  in Microsoft Excel

In this tutorial we will learn how to concatenate the text in Microsoft Excel by using the concat function. =concatenate(text1, text2,….)  This function allows us to concatenate different text strings […]

How to alphabetize columns in Excel

Microsoft Excel is one of the world’s best software to store data in different types. As it is famous in numeric calculation it can also store alphabetic data. Microsoft Excel […]

How to use edit cells shortcut in Excel

Microsoft Excel allows users to format, organise and calculate data in a spreadsheet. By organising data using Excel, data analysts and other users can make information easier to view as […]

How to merge and center in Excel

Data calculation is one of the key features in Excel. Sometimes we need to calculate data from different columns and data is in bigger size than the default visibility of […]

How to use SUMIFS in multiple columns

In this tutorial, we will learn how to use SUMIFS in Excel. Excel provides a formula which is given below; =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) Sum_range : The range […]

How to create a random percentage generator in Excel

Microsoft Excel provides us with a lot of tools and functions for handling and performing various calculations on the data. It also provides various methods of generating numbers both in […]

How to use Sequence in Excel

In this tutorial, we’ll learn how to use this special feature of Excel effectively. Let’s understand the syntax of this function first. Syntax of the SEQUENCE function SEQUENCE is a dynamic […]

How to count cells with dates in Excel

Microsoft Excel is known for handling numeric and text data and performing all sorts of calculations on the data as well. It has many other functions related to date data […]

How to ignore all errors in Excel

You can watch a video tutorial here. Microsoft Excel does not only provide methods for handling, manipulating data and performing calculations on the data but it also helps us in figuring […]