Blog

• Remove Lookup Column Links in SharePoint

  Remove clickable links from SharePoint lookup columns using JSON formatting to keep list views clean and prevent unwanted navigation away from the list.

• Automatically E-mail Power BI Dashboard Screenshots

  Schedule Power BI dashboard screenshots by e-mail using Power Automate and bookmarks, without any custom code or third-party tools.

• Power Query: Load Excel Data from Local, Web, or Current Workbook

  Load Excel data into Power Query from local files, SharePoint, or the current workbook, including tables, worksheets, and named ranges.

• Excel Multi-Criteria Lookup Guide

  Compare Excel multi-criteria lookup methods using SUMPRODUCT, INDEX with MATCH, and XLOOKUP with practical examples.

• How to Create a Multi-Resolution favicon.ico File

  Create a multi-resolution favicon.ico using Inkscape and ImageMagick for consistent display across browsers and search results.

• How to Add Math Equations to Astro with KaTeX

  Add math equations to Astro using KaTeX with Markdown examples, setup steps, and styling tips for clean static site rendering.

• Java Permutation Generator: Partial and Full Strings

  Generate partial and full string permutations in Java using an efficient, duplicate-safe iterative approach with examples.

• Combine Multiple Tables for Clustered Charts in Power BI

  Combine multiple tables for clustered column charts in Power BI using DAX or Power Query with a clear step-by-step comparison.

• Manual WordPress Database Cleanup Using SQL Without Plugins

  Clean and optimize a WordPress database using raw SQL to reduce bloat, improve performance, and avoid plugin overhead.

• Indexed by Microsoft Bing but Missing from Search Results

  Why a site indexed by Bing may not appear in search results, with an investigation into causes and steps taken.

• Why Excel Copilot Gets Math Wrong

  Why Excel Copilot appears to get math wrong, how it actually works, where errors arise, and why the criticism is misleading.

• How to Check If a File Exists Using Excel VBA

  Check if a file exists using a reusable Excel VBA function that supports local paths, network shares, and URLs.

• How to Check If an Excel File Is Open Using Excel VBA

  Detect if an Excel file is already open using VBA to prevent runtime errors, conflicts, and accidental overwrites.

• What AI Adoption Reminds Me of Past IT Transformations

  AI adoption mirrors past IT transformations with key patterns, risks, and practical lessons that still apply today.

• Rename SharePoint Files in Power Automate Using REST API

  Rename SharePoint files using Power Automate and REST API while preserving file IDs, version history, and integrations.

• Schedule Monthly Power BI Refreshes Using Power Automate

  Schedule monthly Power BI dataset refreshes using Power Automate with a fully automated cloud flow and no custom code.

• Comprehensive Regex for URL Detection and Spam Filtering

  Build a flexible PHP regex for URL detection and spam filtering covering domains, IP addresses, Unicode, and edge cases.

• Harden WordPress Security Using Custom .htaccess Files

  Improve WordPress security using custom .htaccess rules to block spam, add headers, and improve performance without plugins.

• Windows 10 End of Support: Forced Obsolescence

  Windows 10 end of support forces upgrade decisions, covering options, tradeoffs, and real-world hardware constraints.

• Create a Mobile Menu with the Popover API and No JavaScript

  Build an accessible mobile menu using the HTML Popover API with no JavaScript, no hacks, and minimal dependencies.