Excel Formulas & Google Sheets Tips Blog
Excel and Google Sheets tips, formula guides, and how-to articles.
Excel Get First Word from Cell — 3 Simple Formulas That Work Instantly | SheetMaster
Extract the first word from any cell in seconds — LEFT+FIND for all versions, TEXTBEFORE for Excel 365. No manual splitting. Works on names, addresses, product codes.
How to Calculate Percentage Increase in Excel — Formula & Examples | SheetMaster
Master the Excel percentage increase formula in under 2 minutes. Step-by-step with real examples for sales growth, revenue tracking & YoY comparisons. Copy the formula, done.
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.
Pass Fail Percentage Formula in Excel — Set It Up in 30 Seconds | SheetMaster
Stop manually checking scores. One IF formula auto-labels Pass/Fail for your entire class. Includes custom thresholds, letter grades (A-F), and conditional formatting. Copy & paste ready.
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.
Extract Text Between Characters in Excel — Brackets, Quotes & More | SheetMaster
Need text between parentheses, brackets, or quotes? MID+FIND formula handles it in one cell. Works with any delimiters. Includes Excel 365 TEXTBEFORE/TEXTAFTER shortcut.
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 — Days, Hours & Minutes Until Any Date | SheetMaster
Create a live countdown in Excel with TODAY() and NOW(). Shows days/hours/minutes remaining, auto-colors overdue items red. Perfect for project deadlines & event tracking.
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 vs SUMIFS explained: comparison table, syntax, and examples. When one condition is enough vs when you need SUMIFS—plus our SUMIFS formula generator.
Excel Grade Calculator: Weighted & Letter Grade Formulas (+Free Tool)
Calculate weighted grades, letter grades, and pass/fail status in Excel. Includes AVERAGE, SUMPRODUCT, IF, and VLOOKUP formulas with a free grade calculator tool.
How to Remove Characters in Excel: 5 Methods (From Left, Right, Specific)
Remove first N characters, last N characters, or specific characters in Excel and Google Sheets. RIGHT+LEN, LEFT+LEN, SUBSTITUTE, TRIM, and REGEXREPLACE methods explained with examples.
Excel SUMIFS with Multiple Criteria: Complete Guide (Includes Real-World Examples)
Master SUMIFS in Excel and Google Sheets with multiple criteria. Real-world examples for sales, HR, finance, and inventory reports. SUMIF vs SUMIFS comparison included.