Power Query: Check If Text Value is Alphabetic Only
Two simple ways to check if text contains only alphabetic characters in Power Query using a custom function or Text.Select with if-then-else.
Blog
Concatenate Excel Ranges Without TEXTJOIN Using VBA Code
No TEXTJOIN? No problem. Use a simple VBA function to concatenate Excel ranges and arrays with control over delimiters and empty cells.
How to Count Cells by Background Color in Excel with VBA
Learn how to count Excel cells based on background color using simple VBA functions. Includes step-by-step instructions, code, and practical examples.
Excel VBA: Improve Excel Range Evaluation by Trimming Unused Cells
Improve Excel range evaluation using a custom VBA function to trim unused cells and optimize performance with whole-column references.
Contact Form for Static Sites Using Cloudflare Workers and Airtable
Create a free, spam-protected contact form for your static website (dedicated server is not required) using Cloudflare Pages, Workers, and Airtable.
Converting Month Names to Numbers in Power Query
Learn three ways to convert month names to numbers in Power Query using if-then-else, Date.FromText, or a custom mapping function.
Power Query: Conditionally Aggregate Data from Multiple Tables
Learn two methods for aggregating data from multiple tables based on selection criteria in Power Query, using Table.SelectRows and Table.NestedJoin.
Power Query: Retrieve Lookup Value by Date Within a Date Range
Learn how to use Power Query to retrieve corresponding values based on date ranges, ideal for various time-based data transformations in Excel.
Power BI: Convert UTC to Eastern Time Adjusted for Daylight Saving
Learn how to convert UTC to Eastern Time in Power BI with a custom Power Query function that accounts for daylight saving time.
Rounding Decimals in Java: Avoiding Round-Off Errors with BigDecimal
Handling decimal rounding in Java with BigDecimal to avoid round-off errors and ensure precise calculations for critical applications.
Show File Last Updated Date in Power BI with Excel VBA or Power Query
Learn how to display the last updated date for an Excel file in Power BI using Excel VBA or Power Query, with step-by-step instructions for both methods.
Power Query: How to Retrieve Excel Defined Name Values
Learn how to define named values in Excel and create a reusable Power Query function to easily retrieve those named values in your queries.
Add JSON-LD Structured Data in Astro for Rich Search Results
Learn how to add JSON-LD structured data to your Astro website to enhance search engine understanding, improve visibility, and enable rich search results.
Power BI: Create and Display a Dynamic Last Refreshed Timestamp
Step-by-step guide to create a dynamic timestamp displaying the latest semantic model refresh date in Power BI.
Install Self-Signed S/MIME Certificates on iOS for Encrypted E-mail
Learn how to install self-signed S/MIME certificates on iOS, enable encrypted email in the Mail app, and secure your digital communications.
Power BI: What-If Analysis Using Interactive Modeling Parameters
Learn how to use Power BI what-if analysis and modeling parameters to create interactive reports and gain insight into how decisions affect outcomes.
Dealing with a Complete Storage Failure
The steps attempted to recover data from a failed microSD Card, what worked, what did not, and the important lessons learned.
Security through Obsolescence: Are Old Floppy Disks Secure?
Explore whether old floppy disks, like 3.5-inch and 8-inch, are truly secure for data storage. Learn about data recovery, obsolescence, and access challenges.
Switch from Gutenberg to Markdown for a Better Writing Experience
Discover how switching to Markdown simplified content creation, improved focus on writing, and enhanced portability over WordPress and Gutenberg.
Use Regular Expressions in Excel VBA to Parse Substrings
Learn how to use VBA and regular expressions in Excel to easily parse substrings from cell values without complex formulas.