Blog
Debug: Found 18 posts
Excel and Google Sheets tips, formula guides, and how-to articles.
Excel Formula to Get First Word from Cell (3 Easy Ways)
Learn how to extract the first word from a cell in Excel using LEFT, FIND, IFERROR, and the new TEXTBEFORE function in Excel 365. Step-by-step guide with examples.
Calculate Percentage Increase in Excel: Formula + Examples
Learn the Excel formula to calculate percentage increase between two numbers. Step-by-step guide with real examples for sales, revenue, and growth tracking.
Excel Formula to Find Duplicates in Two Columns (Step-by-Step)
Find duplicate values across two columns in Excel using COUNTIF, VLOOKUP, and conditional formatting. Includes formulas to highlight and extract duplicates.
Calculate Business Days Between Two Dates in Excel (NETWORKDAYS)
Use the NETWORKDAYS and NETWORKDAYS.INTL functions to calculate the number of business days between two dates in Excel. Includes examples and holiday handling.
Convert Minutes to Hours and Minutes in Excel (3 Easy Methods)
Learn how to convert minutes to hours and minutes in Excel using division, TEXT function, and time formatting. Works with both small and large minute values.
Excel Formula to Capitalize First Letter Only (3 Methods)
Use PROPER, or a custom formula combining UPPER, LEFT, LOWER, and MID to capitalize only the first letter of a word or sentence in Excel.
How to Highlight an Entire Row if a Cell Contains Text in Excel
Use Conditional Formatting with SEARCH or ISNUMBER+SEARCH to highlight entire rows when a cell contains specific text in Excel. Step-by-step tutorial.
Excel Weighted Grade Formula: Calculate Weighted Average Easily
Learn how to calculate weighted grades in Excel using SUMPRODUCT. Includes examples for courses with different credit hours or assignment weights.
Excel Formula for Pass or Fail Based on Percentage (IF Function)
Use the IF function in Excel to automatically show Pass or Fail based on a percentage score. Includes examples with custom thresholds and letter grades.
Excel Formula to Extract Last Name from Full Name
Use Excel text formulas (RIGHT, LEN, FIND, SUBSTITUTE) to extract the last name from a full name. Works with "First Last" and "Last, First" formats.
Excel Extract Text Between Two Characters (MID + FIND Formula)
Use Excel formulas with MID, FIND, and SEARCH to extract text between two characters like brackets, parentheses, or custom delimiters.
Excel Formula to Extract Domain from Email Address
Use Excel text formulas (RIGHT, LEN, FIND) or TEXTAFTER to extract the domain name from an email address. Includes examples and error handling.
Excel Countdown Timer Formula: Days, Hours, and Minutes Until a Date
Build an Excel countdown timer using TODAY(), NOW(), and text formulas. Count days, hours, and minutes remaining until a deadline or event.
VLOOKUP vs XLOOKUP: Which Should You Use in 2026?
Compare VLOOKUP and XLOOKUP: syntax, use cases, and when to use each in Excel and Google Sheets.
5 Excel Formulas That Clean Messy Data 10x Faster
Use TRIM, PROPER, SUBSTITUTE, and more to clean text and data in Excel and Google Sheets.
INDEX MATCH Complete Guide: Why It's More Powerful Than VLOOKUP
Learn INDEX MATCH for Excel and Google Sheets: look left, avoid column index errors, and build flexible lookups.
Excel Formulas for E-commerce Inventory Management
SKU lookup, reorder alerts, and inventory formulas for Excel and Google Sheets.
SUMIF vs SUMIFS: When to Use Each (+Examples)
SUMIF has one condition; SUMIFS has multiple. Learn when to use each with examples.