Excel Help: Formulas, Shortcuts & Spreadsheet Tutorials
Practical Excel formulas, shortcuts, and spreadsheet guides with tested examples and links to relevant tools.
Excel guides
Microsoft Excel Shortcuts for Faster Spreadsheet WorkUse Excel keyboard shortcuts to navigate cells, select data, edit formulas, and format spreadsheets efficiently.
Excel Formulas for Beginners: A Practical Starting GuideLearn Excel formula syntax, cell references, basic operators, and common troubleshooting checks with examples.
How to Use the SUM Formula in ExcelAdd numbers and ranges with Excel SUM, including multiple ranges and common causes of incorrect totals.
Excel IF Formula Explained With ExamplesUse Excel IF to return one result when a condition is true and another when it is false.
How to Use VLOOKUP in ExcelFind a value in the first column of a table with VLOOKUP and avoid approximate-match surprises.
Excel XLOOKUP: Exact Matches and Useful OptionsUse XLOOKUP to search a range and return a matching value without VLOOKUP's left-to-right limitation.
How to Count Matching Cells With COUNTIFUse Excel COUNTIF to count cells that match a word, number, wildcard, or comparison condition.
How to Add Values by Condition With SUMIFSum only the Excel values that meet a condition with SUMIF, including text and numeric criteria.
How to Remove Duplicates in Excel Without Losing DataSafely identify and remove duplicate Excel rows while preserving the original data and choosing the right comparison columns.
How to Freeze Rows and Columns in ExcelKeep headings visible while scrolling by freezing the top row, first column, or selected panes in Excel.
Create Your First Excel PivotTableSummarize a clean Excel dataset with a PivotTable and group values by useful categories.
Excel SUMIFS Formula: Sum With Multiple ConditionsUse SUMIFS to total values that match several conditions, with a sales region and payment status example.
Excel COUNTIFS Formula: Count With Multiple ConditionsCount spreadsheet rows matching multiple criteria with COUNTIFS and check the result against sample data.
Excel IFERROR Formula: Handle Formula Errors CarefullyUse IFERROR to return a chosen fallback when a calculation errors, while checking that the fallback does not hide useful warnings.
Excel Percentage Change Formula: Increase or DecreaseCalculate the relative change between an original and new value in Excel, with examples for increases, decreases, and a zero baseline.
How to Build an Excel DashboardKPIs, formulas, charts and a free template.