MORROW · KNOWLEDGE & NOTES
Learn. Understand. Keep a note.
From materials engineering to digital tools. A quiet space for making sense of things.
All topicsAI development tools37Astronomy and space4Books and reading4Design and visualisation4Devices and connections5Digital knowledge34Digital safety and organization10Documents and work tools5Engineering physics4Geography and maps4Images and files5Learning and memory2Life and learning4Materials engineering20Mechanics3Mechanics of materials16Photography and composition4Python3Reading data3Sound and music4Thermodynamics4Windows guides54
SUMIFS by month and category: a date-range formula that includes the last day
To total only the Books entries in October, test both the category and the date range.
↗
XLOOKUP in practice: find an item by code and handle missing matches
Build a small worksheet that retrieves an item name when you enter its code.
↗
Keep leading zeros and 16-digit IDs in Excel: store identifiers as text
If product code 00123 becomes 123, or the last digits of a long identifier become zeros, widening the column may not fix the problem.
↗
Fix garbled CSV text in Excel: encoding and column types are separate
If double-clicking a CSV turns Korean, Japanese, or Chinese names into strange characters, do not overwrite the original.
↗
PDF search does not work? Five checks that matter after OCR
A PDF can display perfectly legible words and still return no search results.
↗