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…
Extracting and splitting text is about to get a lot easier. Whilst Excel has functions like LEFT, MID, RIGHT, LEN, and SEARCH, unless you have a simple scenario, you’ll probably have to construct an unwieldy formula. Alternatively, you might use…
The easiest way to find the difference between two dates is to subtract the older date from the newer one. That will return the number of days; however, you may want it in weeks, months or years. DATEDIF is a…
End of content
End of content
