Extract Data From a Picture
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…
Find the middle day of the year
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…
Grouping Rows in Excel
Table data is prone to being disorganised and clogging up worksheet space. Fortunately, you can create a multi-level hierarchy that breaks it down into groups so each is summarised separately. In Excel, these are called outlines, and the feature set…
Fast Data Load
Fast Data Load is a Power Query feature that makes loading queries faster by utilising additional CPU power and RAM. However, the drawback is Excel will become unresponsive for this duration, so it’s not recommended if you want to work…
Custom Data Types in Excel
Yesterday, I demonstrated how to use Excel data types to give cell content richer meaning. Issues like erroneous and missing data damage their credibility though, and it’s probably a big reason why Microsoft won’t be renewing their Wolfram license, which…
Workbook Collaboration Using Sheet View
Collaborating in an Excel workbook can be a disruptive experience. You’re working in the same worksheet as a colleague — they filter a table and suddenly it shrinks — interrupting the state you had it in and derailing your progress….
End of content
End of content