Overview

Some topics are too broad and complex to cover in a single article. That does not mean I want to skip them, so here I share high-level thoughts about a specific subject. They might spark several follow-up articles or stand alone, but the point is to convey the main idea or concept clearly. I call these overviews because that is exactly what they are. A few sit slightly off brand for this blog, and when they do I still work to make them relatable and engaging while keeping that broad, big-picture mindset so things never get too dense. There is no schedule for these posts. I write them whenever I stumble onto a topic that interests me, so expect them to appear sparingly among the more focused work here.

SharePoint: YEAR function

SharePoint: YEAR function

Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.

Excel: Sumifs Function

Excel: Sumifs Function

Sums the values that meet several conditions at once. All conditions combine with AND, not OR.

N8N: On a Webhook Call Trigger

N8N: On a Webhook Call Trigger

Starts a workflow instantly when an HTTP request hits its URL. Test and production URLs behave differently.