Executive Training Solutions

There are hundreds of functions available in Microsoft Excel. One of those functions is the PERMUT function. PERMUT is short for permutations, which is how many ways a set of numbers can be rearranged.  For example, 123 could be 321, 132, 231 and so on.

This function helps you find out how many different ways a set of numbers can be re-arranged.  When people talk about how many different variations it would take to try and guess a password, the PERMUT function could be used to find out.

The function is:  =PERMUT(number, number_chosen). The first argument is how many numbers are available in the set, while the second argument is how many numbers you’ll pull out of the set.  For example, if you wanted to create a password from the 26 letters in the alphabet, and the password was going to be 6 characters long, then the function =PERMUT(26,6) would return 165,765,600 which means there are that many different ways to put together the 26 letters in the alphabet in 6 character combinations.

If you want to learn more about functions in Microsoft Excel, I’d recommend joining us for an Excel class.  We offer many different levels, and are confident you will learn something new!

Do you have Excel workbooks with 5 or more worksheets?  Most of us do! I know it can be frustrating to scroll through all the worksheets with the tiny arrows, but did you know there’s an easier way?

Right click on those navigational arrows, and a pop up box will appear with the names of all  your worksheets. Select the one you want, and you’ll be there. It’s much faster and easier than moving through all the sheets with the arrows.

These are the kinds of great tips you’ll gain from attending one of our classes.  We hope to see you soon!