Excel Functions & Formulas
SUMIF with Multiple Criteria for Different Columns in Excel
Learn how to use SUMIF with multiple criteria for different columns in Excel using SUMIFS, combined conditions, matrix layout & SUMPRODUCT.
Read article
Blog
1285 articles
Google Sheets Functions
How to Return a Value If Cell Color Is Red in Google Sheets
Learn how to return a value if a cell color is red in Google Sheets using Apps Script, conditional formatting with helper columns, or add-on.
Read article
Google Sheets Intermediate Tutorials
How to Create Multiple Dependent Drop Down List in Google Sheets
Learn how to create multiple dependent drop-down lists in Google Sheets using named ranges, backend sheets, and data validation steps.
Read article
Excel Functions & Formulas
How to Use SUMIF Across Multiple Sheets in Excel (2 Examples)
Learn how to use SUMIF across multiple sheets in Excel by combining SUM, SUMPRODUCT, and INDIRECT functions to sum data efficiently.
Read article
Excel Functions & Formulas
How to Sum in Excel If Cell Contains Text in Another Cell
Learn how to sum in Excel if a cell contains text from another cell using SUMIF, SUMIFS with wildcards, and the SUMPRODUCT function.
Read article
Excel Pro Tips
How to Remove Everything after a Character in Excel (4 Methods)
Learn how to remove everything after a character in Excel using Find & Replace, LEFT, FIND, SUBSTITUTE for Nth occurrence, and Flash Fill.
Read article
Excel Pro Tips
How to Remove Unwanted Characters in Excel (6 Suitable Ways)
Learn how to remove unwanted characters in Excel using Find & Replace, SUBSTITUTE, TRIM, Flash Fill, and LEFT/RIGHT with LEN functions.
Read article
Excel Pro Tips
How to Remove Last 3 Characters in Excel (4 Easy Methods)
Learn how to remove the last 3 characters in Excel using LEFT & LEN, REPLACE, Flash Fill, or a custom VBA function for clean text format.
Read article
Excel Pro Tips
How to Remove Line Breaks in Excel (4 Simple Ways)
Learn how to remove line breaks in Excel using Find and Replace, SUBSTITUTE, TRIM with CLEAN functions, or a VBA macro for quick cleanup.
Read article
Google Sheets Intermediate Tutorials
How to Use Custom Data Validation Formula in Google Sheets
Learn how to use custom data validation formulas in Google Sheets to enforce number ranges, prevent duplicates, and apply regex-based rules.
Read article
Google Sheets Formulas
How to Split a Cell Horizontally In Google Sheets (5 Useful Methods)
Learn how to split a cell horizontally in Google Sheets using “Split Text to Columns,” SPLIT, REGEXEXTRACT, line breaks, and ARRAYFORMULA.
Read article
Excel Pro Tips
How to Capitalize First Letter of Each Word in Excel
Learn how to capitalize the first letter of each word in Excel using the PROPER function, Flash Fill, or a custom VBA macro.
Read article