Resources

How to generate unique random numbers in Excel

How to generate unique random numbers in Excel

Although Excel doesn't lack functions to generate random numbers, there is no built-in option to generate unique numbers. On the other hand, we can assume that it would be very uncommon to get same number from Excel's random number functions. Anyways, we can eliminate...

How to hide formula errors in Excel

How to hide formula errors in Excel

Errors may be inevitable in worksheets containing complex formulas. Thankfully, you do not need to investigate and correct each of them. It is OK to hide errors you expect and not to correct them to improve the look and feel of your worksheet. In this guide, we’re...

How to split worksheet in Excel

How to split worksheet in Excel

As data grows in a worksheet, it gets harder to manage it. Even a large monitor doesn't help while dealing with thousand rows and hundreds of columns. Fortunately, Excel allows you to split the window up to 4 panes which you can focus on different parts of the...