Blog
How to Use Regular Expressions in Excel for Parsing Substrings with VBA
Learn how to use VBA and regular expressions in Excel to easily parse substrings from cell values without complex formulas.
Excel: Create Cascading Drop-Down Lists for Better Data Validation and Quality Control
How to create cascading drop-down lists in Excel using data validation and named ranges to improve data accuracy and quality in collaborative workbooks.
Power BI Slicer for Multi-Value Columns: Splitting Delimited Data for Better Filtering
Learn how to create a Power BI slicer that splits delimited data, allowing easy filtering of multi-value columns without selecting grouped entries manually.
Why I Continue Blogging
Reflecting on blogging for knowledge sharing and personal growth despite AI challenges and low traffic.
How to Manage Digital Photo Clutter: A Guide to Photo Deduplication
Learn how photo deduplication can help you manage digital clutter, save storage space, and organize your photo library with easy, effective methods.
Astro: Manage Draft and Published Post Statuses by Adding a Content Collection Schema Property
Learn to manage draft posts in Astro by adding a property to your schema, filtering drafts in production, and keeping them visible in development.
Astro: Add Related Posts to Blog Entries
Learn how to add a related posts property to your Astro content collection schema and display related posts links on your blog using custom components.
Create and Use Custom Date Tables in Power BI for Date Hierarchies
Create custom date tables in Power BI using Power Query for precise control over date hierarchies, calculations, and formatting in reports.
PowerShell and Batch Scripts to List Files in Folder and Subfolders, Handle Long Paths and Complex Filenames in Windows
Generate a file list from a folder and subfolders using batch and PowerShell scripts. Handle long paths, filenames, and Unicode support.
Power BI: Create a Filled Donut Chart with DAX and Card Visualizations
Create a filled Donut chart in Power BI using DAX measures and Card visuals to display key metrics in the center.