EXCEL Practical Guides
Use focused guides when you know the job you need to do and want a verified pattern, a realistic example and the next tool or practice step.
XLOOKUP with Multiple Criteria
Return a value using two or more matching conditions.
Open →EXCELXLOOKUP If Not Found
Return a clear message instead of #N/A when no match exists.
Open →EXCELCompare Two Excel Columns
Find matches and differences between two lists.
Open →EXCELFind Missing Values in Excel
Mark items present in one list but absent from another.
Open →EXCELHighlight Duplicates in Excel
Use conditional formatting to make repeated keys visible.
Open →EXCELCount Duplicate Values in Excel
Count how often each key appears.
Open →EXCELSUMIFS with Multiple Criteria
Sum values only when several business conditions are true.
Open →EXCELCOUNTIFS with Multiple Criteria
Count records matching several conditions.
Open →EXCELINDEX MATCH Lookup
Build flexible lookups when you want independent match and return ranges.
Open →EXCELIFERROR for Cleaner Outputs
Replace expected formula errors with a controlled result.
Open →EXCELTRIM and CLEAN Data
Remove extra spaces and non-printing characters from imported text.
Open →EXCELExcel Numbers Stored as Text
Convert imported numeric text into real numbers.
Open →EXCELSplit Text in Excel
Separate structured IDs or delimited text into columns.
Open →EXCELCombine Cells with TEXTJOIN
Create readable keys or labels from multiple columns.
Open →EXCELWorking Days Between Dates
Measure elapsed business days rather than calendar days.
Open →EXCELConditional Formatting with Formulas
Highlight rows using business rules instead of manual colors.
Open →EXCELExcel Data Validation Lists
Control allowed input and reduce manual entry errors.
Open →EXCELExcel Pivot Table Basics
Turn row-level data into grouped summaries quickly.
Open →EXCELPower Query Merge
Join two tables by one or more keys with repeatable refresh steps.
Open →EXCELPower Query Append
Stack files or tables with the same logical columns.
Open →EXCELExcel FILTER Function
Return only rows that meet one or more conditions.
Open →EXCELExcel UNIQUE Function
Return a de-duplicated dynamic list.
Open →EXCELExcel Formulas Not Calculating
Diagnose formulas that show old values, text, or unexpected results.
Open →EXCELExcel Lookup Last Match
Return the most recent or last matching record.
Open →EXCELExcel End of Month
Calculate month-end dates reliably.
Open →EXCELExcel Rounding Rules
Control decimal precision intentionally for prices, quantities and KPIs.
Open →EXCELAbsolute vs Relative Excel References
Copy formulas safely by understanding what moves.
Open →EXCELPercentage Change in Excel
Measure relative increase or decrease between old and new values.
Open →EXCELWeighted Average in Excel
Calculate an average where each row contributes a different weight.
Open →EXCELExcel vs Google Sheets Formula Compatibility
Know which formulas transfer cleanly between Excel and Sheets.
Open →EXCELWorking with Large Excel Files
Keep large workbooks responsive and predictable.
Open →EXCELCompare Two Excel Workbooks
Choose a reliable method based on what “different” means.
Open →EXCELImport CSV into Excel Cleanly
Prevent IDs, dates and decimals from being silently converted.
Open →