Blog

How to create cascading drop-down lists in Excel using data validation and named ranges to improve data accuracy and quality in collaborative workbooks.

Learn how to create a Power BI slicer that splits delimited data, allowing easy filtering of multi-value columns without selecting grouped entries manually.

Reflecting on blogging for knowledge sharing and personal growth despite AI challenges and low traffic.

Learn how photo deduplication can help you manage digital clutter, save storage space, and organize your photo library with easy, effective methods.

Learn to manage draft posts in Astro by adding a property to your schema, filtering drafts in production, and keeping them visible in development.

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 custom date tables in Power BI using Power Query for precise control over date hierarchies, calculations, and formatting in reports.

Generate a file list from a folder and subfolders using batch and PowerShell scripts. Handle long paths, filenames, and Unicode support.

Create a filled Donut chart in Power BI using DAX measures and Card visuals to display key metrics in the center.

Convert text values into colorful icons in Power BI using DAX measures and Unicode characters for Table and Card visualizations.

Create filterable card visualizations in Power BI using bookmarks and transparent shapes to enhance interactivity and user experience.

Combine clustered and stacked columns in one Excel chart without changing the source data structure.

Astro component adding relative navigation links to the previous and next blog post entries in a collection.

Custom VBA automation to extract information from structured e-mails in Outlook into an Excel worksheet using both text-based and HTML table-based methods.

Custom Excel VBA function to retrieve field values from an Outlook address book entry. Searches both local contacts and Exchange address books.

Astro pagination capability using collections and dynamic routes with a rest parameter. Resolves type issues and generates post listings with page navigation.

Learn how to query a secure REST API with Power Query using API keys and authorization headers for proper authentication.

Multiple solutions for querying paginated REST APIs with known or unknown page counts or entry counts, using Power Query.

Display continents and countries using Power BI map visualizations. Country-level mapping is challenging due to geopolitical issues and inconsistent naming.

Accurately map common, non-unique city names using Power BI map visualizations by setting the correct data category and including country and coordinate data.