Become an Excel Semi-Pro
Expert tips, advanced formulas, and AI-powered workflows to help you work smarter, not harder.
Latest Insights
Fresh guides to help you optimize your Excel workflow.
Strikethrough in Excel: Shortcuts, Checklists, and Removing the Line
Apply or remove strikethrough in Excel with a keyboard shortcut or Format Cells. Learn to cross out part of a cell and spot stale formula values....
Spell Check in Excel: Check a Sheet and Fix F7 Problems
Use F7 to check spelling in Excel. Learn how selected cells change the scope and why Excel skips spelling checks in formula cells....
Excel Formula Errors: Find the Cause Before Hiding It
Diagnose six common Excel formula errors, check inputs and references, and fix the cause before using IFERROR to show a fallback....
Waterfall Chart in Excel: Set Totals Correctly
Create a waterfall chart in Excel with signed changes, subtotals, and a closing balance. Use Set as Total to fix floating totals and check the result....
Refresh a Pivot Table in Excel When New Rows Are Missing
Refresh a PivotTable in Excel and fix missing rows. Check its source range, switch to an Excel Table, and choose when to use Refresh All or refresh on open....
Checkboxes in Excel: Build a Working Checklist
Add in-cell checkboxes in Excel, show task status, and count completed work with IF and COUNTIF. See version limits and the separate Form Controls method....
INDEX MATCH MATCH in Excel: Two-Way Lookup
Find a value by row and column with INDEX MATCH MATCH in Excel. Follow a product-by-month example and fix mismatched ranges and missing keys....
Standard Deviation in Excel: STDEV.S vs STDEV.P
Calculate standard deviation in Excel with STDEV.S or STDEV.P and choose the right formula for your data....
CAGR Formula in Excel: Count Periods Correctly
Calculate CAGR in Excel with RRI or a simple exponent formula. Count five intervals across six annual values and check the result in an example workbook....
How to Lock Cells in Excel and Keep Input Cells Editable
Unlock the input cells, leave formulas locked, then protect your Excel worksheet. Follow an order-form example with Windows, Mac, and web instructions....
How to Split First and Last Names in Excel
Split names into columns with TEXTSPLIT, TEXTBEFORE, TEXTAFTER, or Text to Columns. Handle extra spaces, single names, and middle names....
How to Remove Table Formatting in Excel (Without Losing Your Data)
Remove an Excel table's style, convert it to a range, or clear cell formats. Choose the right method to keep your data and formulas....
Explore by Topic
Find exactly what you're looking for by browsing our most popular tags.