Excel Semi Pro Articles
A browsable archive of Excel tutorials and guides written by Excel Semi Pro.
12 articles
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....
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....
How to Delete Blank Rows in Excel Safely
Delete completely blank rows in Excel with a helper column and filter. Keep partial records, formulas returning empty text, and cells containing spaces....
Excel IF Cell Contains Text: Formulas and Examples
Use IF with SEARCH, FIND, or COUNTIF to test whether an Excel cell contains text, with case-sensitive, multi-word, and blank-input examples....
Weighted Average in Excel: Formula and Examples
Calculate a weighted average in Excel with SUMPRODUCT and SUM. Follow price, score, and percentage examples, and handle zero weights and missing values....
How to Count Unique Values in Excel
Count unique values in Excel, ignore blanks, count values that appear once, and add criteria. Includes modern formulas and an older Excel alternative....
How to Make a Gantt Chart in Excel
Make a Gantt chart in Excel with start dates and durations. Follow a five-task example, fix date-axis settings, and download the sample workbook....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us