Excel Pro Tips
How to Apply Conditional Formatting to Blank Cells in Excel
Learn how to apply conditional formatting to blank cells in Excel using the built-in “Blanks” option, ISBLANK, OR, LEN functions & formulas.
Read article
Blog
1285 articles
Google Sheets Formulas
Compare Two Columns & Find Missing Values in Google Sheets
Learn how to compare two columns in Google Sheets and find missing data using MATCH, ISNA, FILTER, VLOOKUP & conditional formatting methods.
Read article
Excel Functions & Formulas
How to Sum If Greater Than and Less Than a Cell Value in Excel
Learn how to use SUMIF and SUMIFS in Excel to sum values greater than, less than, or between cell values using dynamic ranges & references.
Read article
Excel Functions & Formulas
How to Do Ranking in Excel Based on Multiple Criteria
Learn how to do ranking in Excel based on multiple criteria using RANK, COUNTIFS, SUMPRODUCT, and techniques for unique and grouped rankings.
Read article
Excel Functions & Formulas
How to Use MIN and MAX Functions in the Same Formula in Excel
Learn how to use MIN and MAX together in Excel to limit values, apply dynamic lookups, and control SUM outputs within defined ranges.
Read article
Google Sheets Intermediate Tutorials
Conditional Formatting for Dates within 7 Days in Google Sheets
Learn how to use conditional formatting in Google Sheets to highlight dates within the past or next 7 days using TODAY, AND & helper columns.
Read article
Excel Functions & Formulas
How to Find the Maximum Value in Excel with Condition
Learn how to find the maximum value in Excel with conditions using MAX, MAXIFS, SUMPRODUCT, AGGREGATE, and INDEX-MATCH for advanced filtering.
Read article
Excel Functions & Formulas
How to Find the Max Value and Corresponding Cell in Excel
Learn how to find the max value and its cell address in Excel using functions like INDEX, MATCH, XLOOKUP, CELL, LET, and even VBA macros.
Read article
Excel Functions & Formulas
How to Find the Lowest Value with Criteria in Excel (5 Methods)
Learn how to find the lowest value in Excel with criteria using MIN, MINIFS, IF, SMALL, and FILTER functions, AND/OR condition filtering.
Read article
Google Sheets Functions
How to Fix Google Sheets IMPORTRANGE Not Updating Issues
Learn how to fix Google Sheets IMPORTRANGE not updating issues by reauthorizing permissions, adjusting the formula, and limiting the range.
Read article
Excel Functions & Formulas
How to Use COUNTIFS with Date Range and Text in Excel
Learn how to use COUNTIFS in Excel to filter by date range and text, match partial text, count specific months, & apply dynamic date filters.
Read article
Excel Functions & Formulas
Excel COUNTIF with Multiple Criteria Across Different Columns
Learn how to use COUNTIF and COUNTIFS in Excel to apply multiple criteria across columns, handle OR logic, and count keyword occurrences.
Read article