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 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

Excel how to number cells vertically

Microsoft Excel is made up of several tables, which in turn constitutes rows and columns. The columns are arranged vertically while the rows are horizontally arranged. The rows are designated…

Comments Off on Excel how to number cells vertically

Excel: How to compare four column

On excel, comparing values within the same column is simple, but this is not the case when comparing multiple columns. Multiple columns can be compared on excel via sorting, conditional…

Comments Off on Excel: How to compare four column

Excel: How to put 0 in front of numbers

Two options are always available for you whenever you want to format text on excel. You can either do it via Excel format cells option or by using the excel…

Comments Off on Excel: How to put 0 in front of numbers

How to vlookup multiple values in Excel

Vlookup is a regular excel operation for identifying single values that correspond to lay down criteria. This does not imply that it is impossible to look up for multiple values.…

Comments Off on How to vlookup multiple values in Excel