Excel Semi Pro Articles
A browsable archive of Excel tutorials and guides written by Excel Semi Pro.
9 articles
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