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…
Calibri has been the default Office font for 15 years, but that is about to change. Microsoft announced over a year ago it was time for a successor. They commissioned five new fonts: These are already available to use if…
A sparkline is a tiny in-cell chart that provides a visual representation of data. They are useful for casually glancing over data to spot trends and variation. Moreover, they conserve space, negating the need to have an overload of full-scale…
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…
End of content
End of content
