It’s well-known that the Excel, Word and PowerPoint ribbons vary because each program has a different use case. In Excel for desktop, however, one glaring omission is a Strikethrough button in the Home tab. Interestingly, Excel for the web does…
Running counts are useful for keeping track of how many times a value has occurred up to a certain point. There are multiple ways of doing this, so let’s look at some traditional and modern methods. Example On page 1,…
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,…
Important values strewn across a workbook are difficult to track. Whilst opening additional windows or splitting your view into panes are two ways of combatting the endless scrolling and tab switching — they’re not perfect. An alternative is the Watch…
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. It’s already possible to do this in Excel…
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…
End of content
End of content
