Changelog

• Power Query for Beginners: Clean Excel Data - Beginner workflow for importing, cleaning, and refreshing CSV or Excel data with repeatable Power Query steps

• Clean Imported CSV Data in Excel - Practical steps for fixing shifted columns, dates and numbers, hidden spaces, duplicate rows, encoding issues, and blank values after CSV imports

• Remove Leading and Trailing Spaces in Excel - Data-cleaning guide for removing leading spaces, trailing spaces, double spaces, non-breaking spaces, line breaks, and hidden lookup-key characters with TRIM, CLEAN, SUBSTITUTE, and safe paste-values steps

Several existing guides were expanded with new sections and fixes:

• How to Remove Duplicates in Excel - added the UNIQUE method and a comparison of the three ways to de-duplicate
• Excel #SPILL Error - added a table of Excel's warnings and how to find the blocking cell
• Excel Dynamic Array Formulas - added VSTACK, HSTACK, and TOCOL examples
• Excel FILTER Function - added filtering by a list, by partial text, and by a whole column
• LAMBDA in Excel - added MAP, BYROW, BYCOL, REDUCE, and optional parameters
• TRIMRANGE and Trim References - added a TRIMRANGE vs TRIM comparison
• VLOOKUP Not Working - added fixes for values that look identical but do not match
• How to Fix VLOOKUP #N/A - added fixes for keys with leading zeros
• How to Use VLOOKUP Across Sheets - added a cross-sheet troubleshooting table
• XLOOKUP in Excel - added fixes for #SPILL! and for results that do not match your filter
• How to Find Duplicates in Excel - added why duplicate checks miss matches
• Excel Numbers Stored as Text - added bulk-fix options and verification formulas
• Remove Leading and Trailing Spaces in Excel - added how to identify the invisible character involved
• Clean Imported CSV Data in Excel - added an import verification checklist
• Excel Data Sorting - added the SORT function and a section on sorting mistakes
• Excel Data Cleaning - added cleaning mistakes that create new problems
• Fixed the sort shortcuts listed in the Excel sorting guide, which were not Excel's

• Excel Formula Not Calculating - 10 Fixes - Practical checklist for fixing formulas that do not update, display as text, keep old results, use text numbers, contain circular references, or break after copying
• Excel #SPILL Error - Causes and Fixes - Troubleshooting guide for blocked spill ranges, merged cells, Excel Table limitations, oversized dynamic arrays, and XLOOKUP or FILTER formulas that need room to expand
• Excel Numbers Stored as Text - Data-cleaning guide for converting text numbers with Convert to Number, Text to Columns, Paste Special, VALUE, NUMBERVALUE, and lookup-safe type checks
• XLOOKUP Not Working in Excel - Troubleshooting guide for #N/A, #VALUE!, #SPILL!, wrong results, copied formulas, data type mismatches, and blocked dynamic-array results

• Excel FILTER vs VLOOKUP - Decision guide for choosing between one-value lookups and dynamic matching-row reports, including multiple matches, multiple criteria, compatibility, and common formula mistakes
• IF with AND OR in Excel - Multi-condition IF guide for AND logic, OR logic, combined AND/OR rules, row labels, numeric thresholds, and common formula mistakes
• SUMIF vs SUMIFS in Excel - Decision guide for choosing between single-condition and multi-condition totals, including criteria order, date ranges, repeated records, list matching, and common formula mistakes
• COUNTIF vs COUNTIFS in Excel - Decision guide for choosing between single-condition and multi-condition counts, including criteria pairs, date ranges, duplicate checks, list comparisons, and common formula mistakes
• How to Find Duplicates in Excel - Review-first guide for highlighting duplicate values, flagging repeated rows with COUNTIF and COUNTIFS, checking multi-column duplicates, and deciding when to remove duplicates safely
• How to Compare Two Columns in Excel - Practical comparison guide for finding matches, missing values, row-by-row differences, duplicate checks, and related data with COUNTIF, XLOOKUP, FILTER, and Conditional Formatting
• VLOOKUP with Multiple Criteria in Excel - Helper-column and formula-based lookup guide for combining two or more criteria, avoiding duplicate lookup keys, using CHOOSE, and choosing XLOOKUP or INDEX MATCH alternatives
• How to Use VLOOKUP Across Sheets in Excel - Practical guide to writing VLOOKUP formulas between worksheets, including quoted sheet names, locked lookup ranges, Excel Tables, #N/A fixes, and when XLOOKUP is cleaner
• How to Fix VLOOKUP #N/A in Excel - Focused troubleshooting guide for exact match failures, hidden spaces, numbers stored as text, lookup range mistakes, and IFNA fallback messages
• Excel Pivot Tables for Beginners — Step-by-step PivotTable guide for preparing source data, creating summaries, using rows, columns, values, and filters, grouping dates, refreshing reports, and avoiding common mistakes
• Excel FILTER Function Tutorial — Dynamic array guide covering single and multiple criteria, empty results, selected columns, sorted outputs, unique lists, and common FILTER errors
• Excel SUMIF and SUMIFS Tutorial — Practical guide to conditional totals with one or multiple criteria, including text, numbers, dates, blanks, and common troubleshooting patterns
• Excel Dynamic Array Formulas — Complete guide to spilled ranges, version compatibility, FILTER, SORT, UNIQUE, SEQUENCE, TEXTSPLIT, and common dynamic array errors
• Excel XLOOKUP Tutorial — Step-by-step guide to exact matches, left lookups, multiple returned columns, missing-value handling, and common XLOOKUP fixes
• VLOOKUP vs XLOOKUP vs INDEX MATCH — Decision guide comparing lookup formulas by compatibility, flexibility, syntax, and maintainability

• Added working category filters for the posts index, including Excel Basics, Formulas & Functions, Data Cleaning, Data Analysis, and PivotTables
• Updated homepage, header, and footer guide links to point to real content categories

• Normalized existing article categories so formula, data cleaning, data analysis, and PivotTable guides group consistently
• Improved related-article matching to use article frontmatter categories

• Excel Data Validation — Complete guide covering drop-down lists, dependent cascading lists, custom formula validation, and error alerts

• Fixed an issue where some formula code blocks displayed incorrectly on the page

• Excel Data Validation — Learn how to create dropdown lists, restrict input ranges, and set up custom validation rules
• Excel Find and Replace — Advanced techniques for searching and replacing data across worksheets
• Excel Text Functions — Master text manipulation functions including LEFT, RIGHT, MID, CONCATENATE, and more

• Updated Excel Text Function tutorial with detailed examples and step-by-step images
• Enhanced Excel SUM Function guide with new image references and clearer explanations
• Added monthly view trends chart to track popular content and site statistics

• Excel COUNT Function — Complete guide to COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS
• Excel IF Function — Step-by-step tutorial on conditional logic with nested IF examples

• Added table of contents navigation for easier article browsing
• Added related articles section to help discover relevant guides

• Updated Excel tutorial posts with English translations and animated GIFs
• Improved markdown rendering with DaisyUI styled horizontal rules

• Excel PivotTable Error Display — Analysis of how PivotTables handle and display error values

• Added tags support to article metadata for better content organization
• Implemented cookie consent banner with Google Analytics integration
• Added page titles to all routes for better SEO

• Updated privacy policy and cookie policy documentation
• Refined about page content

• Added cover images to all posts for a more visual browsing experience
• Improved table styling in markdown content
• Updated feedback section text for better clarity

• Excel Conditional Formatting — Complete guide to highlighting cells, data bars, color scales, and icon sets
• Excel Data Cleaning — Techniques for cleaning and transforming messy spreadsheet data
• Excel Formula Errors — Comprehensive guide to understanding and fixing common formula errors

• Added post sorting functionality (newest, oldest, alphabetical, popular)
• Implemented monthly popular posts tracking and display
• Added dynamic recent articles section on homepage
• Added global SEO meta descriptions and keywords for better search visibility
• Implemented post view tracking and statistics

• Added inline code block styling in markdown content
• Optimized article utilities and markdown processing modules

• SheetHelper officially launched with initial Excel and Google Sheets tutorials
• Core features: article system, responsive design, dark mode support
• Initial tutorials covering VLOOKUP, cell references, sorting, autofill, and more