How to handle REST API queries in Power Query and Power BI where both Basic Authentication and API Tokens are required.
Simple SQL statements to clean unnecessary overhead, bloat, and orphaned data from WordPress databases without using a plugin.
How to install and use self-signed S/MIME digital certificates in Thunderbird for e-mail digital signatures and encryption.
How to install and use self-signed S/MIME digital certificates in Microsoft Outlook for e-mail digital signatures and encryption.
Excel calculation speed can be improved by reducing the size of an evaluated range. This custom VBA function removes empty boundary cells from a range.
How to count all Excel cells in a range based on background color using a custom user-defined function in VBA.