Fundamentals

If you want to master something, you have to understand its fundamentals deeply. They are the building blocks you stand on to reach the more complex ideas. Knowledge is like a house: you lay strong foundations first, then build upward. It sounds like a cliche, but it holds true, and solid fundamentals are what make good professionals. Under this tag I work on bringing you the fundamentals of each technology, from the small details that quietly make all the difference to the bigger concepts. My focus is mostly the Power Platform, but I will happily write about other things I find interesting along the way. Expect a mix drawn from technology and productivity. What matters most to me is that you walk away having learned something new you can build on.

Power Automate: Join Action

Power Automate: Join Action

Joins an array into a single string with the delimiter you choose. An empty array returns an empty string.

Excel: Mid Function

Excel: Mid Function

Extracts characters from the middle of a text string, starting at a position you choose. Always returns text.

Excel: Sumif Function

Excel: Sumif Function

Sums the values that meet one condition. A mismatched sum range is silently reshaped, not flagged.

Excel: Countif Function

Excel: Countif Function

Counts the cells in a range that meet one condition. Text matching ignores case.