Word cloud and sentiment analysis
Ever wanted to know which words pop up a lot in your LinkedIn posts? Or, what tone you write in? MonkeyLearn provides two free tools for this: a word cloud generator and a sentiment analyser. A word cloud is a…
Will Office Scripts Replace VBA?
VBA will soon have a challenger — it’s called Office Scripts. Microsoft first announced Office Scripts back in 2019. Since then, it’s been available in Excel for the web to those with a commercial or educational license. However, it’s set…
How to retrieve the date/time of LinkedIn posts
Relative timestamps are commonplace across social media feeds. They are reader-friendly and instantly interpretable, making it easy to know when posts were published. On the other hand, absolute timestamps are not. They require extra mental work, are unnecessarily clunky, and…
Leading Zeroes
Ever typed a phone number, identification number, or ZIP code, only to find Excel annoyingly strips away the leading zero and converts it into a numeric value? We might know that numbers have a use beyond mathematical operation, but Excel doesn’t. Thankfully,…
Show Changes Comes to Desktop
Last year, Microsoft introduced a collaboration feature in Excel for the web called Show Changes. It allows users to track modifications to cells across a workbook. Guess what? It’s now come to the desktop version of Excel for Microsoft 365….
Introducing the IMAGE function
Remember when we had to use hacky methods to insert pictures into cells? No longer. A new function is born — it’s called IMAGE. That’s right, Excel has taken another leaf out of Sheets’ book with a long overdue but…
