How to count cells that are the same in Excel

Repetition or duplication of data can be common when dealing with excel sheets. Although repeating is not an offence because you may collect the same amount of data from the…

Comments Off on How to count cells that are the same in Excel

How to count cells that are highlighted in Excel

When we need to make changes, adjust, delete, update, and even erase a particular cell in excel sheets, we do what we refer to as highlight. A highlighted cell will…

Comments Off on How to count cells that are highlighted in Excel

How to keep title at top of page in Excel

Your title row is an important row on excel, as it carries vital information such as the name of the columns and rows you are working on.      …

Comments Off on How to keep title at top of page in Excel

How to insert checkbox in Excel

The checkbox is a common soft tool that is usually found on the web pages and forms. On excel and in other web forms, the checkbox is very efficient for…

Comments Off on How to insert checkbox in Excel

How to rotate charts in Excel

When analyzing your Excel data, you might notice that some charts will have a better appearance if you rotate them. Rotating a chart is not very easy. But as we…

Comments Off on How to rotate charts in Excel

How to count without duplicates in Excel

Data analysis usually involves large data sets, and at some point, one may need to find out the number of values that appear only once in the dataset. In this…

Comments Off on How to count without duplicates in Excel

How to remove the first 6 characters in Excel

Editing of data is one of the regular actions we take when working on Excel. We always have the need to remove specific data from a dataset. Removing data is…

Comments Off on How to remove the first 6 characters in Excel

How to remove the last four digits in Excel

┬áIf you deal with massive data on Excel, then there is a chance that you will want to remove some last characters from a dataset. It is a straightforward task…

Comments Off on How to remove the last four digits in Excel

How to query a table in Excel

In this tutorial, we will take an in-depth look at some formulas you can use to query a table. Tables are great in supporting structured referencing; hence, we can use…

Comments Off on How to query a table in Excel

Excel how to get unique values from a column

There are a plethora of tutorials on how to identify and count unique values on the Excel work file. If you have read any of them, then you should know…

Comments Off on Excel how to get unique values from a column