A quirky personal blog of practical fixes for Excel, PowerQuery and VBA problems, plus tips for converting Blu-ray and DVD audio to FLAC with ffmpeg. Each issue gives short, copy-paste-ready code alongside jokey asides about the author's tech frustrations.
Website: https://unknown-artist.name/
The Workbook is a weekly newsletter teaching practical Excel formulas and workplace productivity tips, such as SEQUENCE, DATEDIF and SUMPRODUCT, with short step-by-step instructions. It also includes AI tips for using Copilot and updates from author Alice Lemee about her upcoming book.
Trump Excel publishes practical Excel tutorials explaining functions, features and when to use each. Issues compare similar tools such as SUMIF vs SUMIFS and Tables vs ranges, with simple examples.
Explainly is a small newsletter from an author who explains finance and data tools such as present value, perpetuities, Power BI measure testing, and consolidating Excel tables with Power Query. Each issue pairs a short written walkthrough with a linked video or downloadable file.
Short product announcements from the creator of xlwings covering new features in xlwings Lite and the release of his book Python for Excel, 2nd Edition. Readers get a quick update on what changed and where to try it.
One short email a week with hand-picked newsletters from the index. Free, no spam, unsubscribe anytime.
