Select Page

## How to transpose the rows and columns of a data table

Ever spent time to transpose rows and columns in a data set? It can be a very tedious job to switch rows to columns or columns to rows. It gets even harder if your data is updated frequently. Not anymore, for you can transpose rows and columns in a table using a...

## How to create a random secure password in Excel

Managing and coming up with strong passwords can be challenging. Let us show you how you can create your own custom password generator in Excel. You can download our sample workbook below. Download Workbook Syntax Random Character Generation =RANDBETWEEN(0,9)...

## How to shuffle a list of items in a random order

Do you have a list of items or names that you want to sort randomly? Using the RANDBETWEEN, RANK, and INDEX functions in conjunction, you can easily shuffle an item group for a random draw. Syntax =RANDBETWEEN( 1, number of list items ) + ROW() / very large number...

## How to use ROMAN numbers

Excel has a function for converting regular (Arabic) numbers to Roman numbers. Syntax =ROMAN(number, type of conversion) Steps Type =ROMAN( Select or type the cell reference that includes number in Arabic form B3, Type the conversion type, or omit C3 Type ) and press...

In complex models, it is important to write comments explaining how the formulas work. But the limitation of Excel’s Insert Comment feature is that you must type the entire comment in a textbox. There is an alternative. You can use N() formula to insert your...

## How to create a calendar that only contain workdays

Be it for creating a time card or planning, creating a flexible calendar where you can omit holidays will come in very handy. Using the WORKDAY function you can easily create such a table and incorporate it in your data models. Syntax =WORKDAY(previous date, 1) Steps...

## How to find the root of a number

Algebraically, the nth root of a number can be calculated by using 1/n for its power. You can always use caret symbol (^) to find a certain power of a number, but doing this with a formula can be easier to read and identify in nested formula sets. Syntax =POWER(base...

## How to find the power of a number

You can always use caret symbol (^) to find a certain power of a number. However, doing this with a formula can be easier to read and identify in nested formula sets. Syntax =POWER(base number, how many times that base number will be multiplied by itself) Steps Begin...

## How to find the unique items in a list

Dissecting and organizing data doesn’t have to be challenging. You can quickly filter your data items with this method using a combination of formulas to determine which are unique items. Syntax =LOOKUP(2, 1/(COUNTIF(expanding unique list, original list)=0),...