How to Find Differences Between Two Excel Sheets
Learn practical ways to compare two Excel sheets, identify changed or missing values, check rows with formulas and create a reviewable difference list.
Read guideGuide Category
Excel Guides
Excel formulas, tutorials and practical spreadsheet guides.
How to Compare Two Columns in Excel: Find Matches and Differences
Learn practical ways to compare two Excel columns, find matches and missing values, flag differences, and handle extra spaces or inconsistent data.
Read guideHow to Use SORT in Excel: Sort Data with a Formula
Learn how to use SORT in Excel to return ordered data with a formula, change ascending or descending order, and combine SORT with FILTER and UNIQUE.
Read guideHow to Use UNIQUE in Excel: Get a List of Unique Values
Learn how to use UNIQUE in Excel to create distinct lists, identify values that occur only once, and combine UNIQUE with SORT and other functions.
Read guideHow to Use FILTER in Excel: Practical Examples
Learn how to use FILTER in Excel to return matching rows, combine multiple conditions, handle empty results and build practical dynamic lists.
Read guideHow to Sort and Filter Data in Excel: Practical Guide
Learn how to sort and filter Excel data safely by names, dates, numbers and multiple criteria without losing the structure of your dataset.
Read guideHow to Use Conditional Formatting in Excel: Practical Rules
Learn how to use Excel conditional formatting to highlight duplicates, overdue dates, thresholds, top values and custom conditions without changing the underlying data.
Read guideHow to Clean Data in Excel: A Practical Cleanup Workflow
Learn a practical Excel data-cleaning workflow for extra spaces, hidden characters, inconsistent values, numbers stored as text and duplicate or incomplete records.
Read guideHow to Combine Cells in Excel: CONCAT, TEXTJOIN and &
Learn how to combine names, addresses, IDs and other values in Excel using &, CONCAT and TEXTJOIN, with practical examples and common mistakes.
Read guideHow to Split Text into Columns in Excel: 3 Practical Methods
Learn how to split names, IDs, addresses and imported text into separate Excel columns using Text to Columns and modern text functions.
Read guideHow to Create a PivotTable in Excel: Step-by-Step With a Real Example
Learn how to create a PivotTable in Excel, prepare source data, place fields, summarize values and avoid common reporting mistakes.
Read guideHow to Use INDEX and MATCH in Excel: Lookup Formula & Examples
Learn how INDEX and MATCH work together for flexible Excel lookups, including exact matches, left-side lookups, errors and when XLOOKUP may be simpler.
Read guideHow to Use COUNTIF and COUNTIFS in Excel: Examples & Tips
Learn how to count matching cells and rows in Excel using COUNTIF and COUNTIFS, including status, text, number, date and multi-condition examples.
Read guideHow to Use SUMIF and SUMIFS in Excel: Practical Formulas & Examples
Learn how to total Excel values that meet one or more conditions, including sales by person, region or date range, with SUMIF and SUMIFS examples.
Read guideHow to Use IF in Excel: Formulas, Examples & Common Mistakes
Learn how to use IF in Excel for yes/no decisions, pass/fail checks, labels, conditional calculations and multiple conditions, with practical formulas you can adapt to real spreadsheets.
Read guideHow to Use VLOOKUP in Excel: Complete Guide With Examples
Learn VLOOKUP syntax, exact and approximate matches, column indexing, error handling, common mistakes and when to use XLOOKUP instead.
Read guideHow to Use XLOOKUP in Excel: Complete Guide With Examples
Learn how XLOOKUP works, its syntax, exact and approximate matches, error handling, two-way lookups and common mistakes.
Read guideHow to Calculate Percentage in Excel: Complete Guide With Formulas and Examples
Learn the most useful Excel percentage formulas, including percentage of a number, percentage of a total, increase, decrease, change and percentage points.
Read guideContinue exploring