Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how. Over the last few months, I’ve written about several of Excel’s new dynamic ...

Random number generation is an essential feature in Excel, allowing users to perform tasks such as simulations, creating test datasets, or experimenting with spreadsheet models. Excel provides three ...

In this lesson, I will teach you how and when to use the following Microsoft Excel functions: =RAND =RANDBETWEEN =RANDARRAY ...

In addition to the new SORT function, you may also find the new FILTER and UNIQUE array functions useful. For example, the worksheet on the next page contains a detailed listing of invoices in columns ...

If you are looking to improve your Microsoft Excel spreadsheet and data analysis skills you may be interested in this Advanced Excel Tips & Tricks tutorial from the team over at SSIT. Mastering ...