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…
Yesterday (2nd July) was the exact middle point of 2022, so today (3rd July) is the first day of the year’s second half. 😯😬 It’s common knowledge that there are 365 days in a year (except leap years). As 365…
I’m pleased to say that searchable dropdown lists have finally made their way into my Excel! Now I can search for something and get a filtered list of suggestions. Previously, the only option was to rely on a stopgap solution…
CONCAT and CONCATENATE are two functions that combine text values. The former first appeared in Excel 2016, whereas the latter has been around considerably longer and is still accessible for backwards compatibility purposes. Syntaxes Their syntaxes look similar, but do…
Acuity Training recently published the results of their research into Excel usage in the workplace. They polled 1,000 office workers earlier this year across a range of industries to find out numerous things relating to competence and time spent in…
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…
End of content
End of content
