Randomly generated data

What is the most common problem for programmers and report makers? Certainly, it is a lack of adequate information they need to launch the report and see if it works. Data can be entered manually. But hey: imagine yourself to manually enter 100,000 records!?! This article demonstrates simple techniques to create tables with data to test the most demanding reports.

Searching through data ranges

In practice, it often happens that we have tables that are in a mutual relationship. Similar to the database, the value of a table column column may be a key by which we can access the columns of another table. In this text, we will discuss the functions used to search through data ranges. If you master them, it’s quite certain that this will quickly become one of your favorite Excel tools.