Want to digitise that document, receipt, or book page? Data from Picture is an Excel feature that allows you to extract the text from an image and insert it into a worksheet. This can be a real timesaver and prevents…
A table is defined as “a set of facts or figures systematically displayed, especially in columns.” They structure data in a way that ensures fast and efficient readability. In Excel, they have official status. A table is an object with…
The VLOOKUP function enables you to search for a value in one column and return another from the same row in a different column. As it works from top to bottom, the ‘V’ stands for vertical. Arguably, it’s the most…
What do lottery balls, dice, and a roulette wheel have in common? They are based on randomness, which cuts across numerous fields and exists in different forms. You might want to generate random numbers to test a financial model, create…
Ever watched a cup draw on television? I’m sure you have. Arguably, the most famous one is football’s FA Cup. I’ve built the virtual equivalent in Excel. Of course, it cannot replicate the experience of picking balls out of a…
Star rating systems are commonly used to rank things like films, TV shows, hotels, and shopping products. Typically, they are done on a scale of 1–5 (or 0–5), although you may have seen the odd six-star hotel or 10-star energy-rated…
End of content
End of content
