Excel Pro Tips
Conditional Formatting Based on Another Cell with Multiple Values
Learn how to apply conditional formatting based on anothr cell with multiple values using OR, COUNTIF, partial matches, and named range
Read article
Blog
1285 articles
Trending
Excel Pro Tips
How to Sort by Column in Excel But Keep Rows Together
Learn how to sort data by column in Excel while keeping rows intact using table format, SORT function, custom lists, and helper columns.
Read article
Excel for Statistics
How to Perform Bilinear Interpolation in Excel (Step by Step Guide)
This article explores what bilinear interpolation is and the bilinear interpolation Excel formula and application with detailed steps.
Read article
Excel Pro Tips
How to Return a Value If a Cell Is Blank in Excel (6 Cases)
Learn how to return a custom value if a cell is blank in Excel using IF, ISBLANK, LEN, COUNTBLANK, and other logical functions.
Read article
Excel Pro Tips
How to Change Compatibility Mode in Excel (3 Simple Ways)
Learn what Compatibility Mode is in Excel and how to convert files to modern formats to remove compatibility prompts and improve performance.
Read article
Excel Pro Tips
How to Find Last Occurrence of a Value in a Column in Excel
Discover how to find the last occurrence of a value in an Excel column using LOOKUP, INDEX-MAX, XLOOKUP, or VBA methods easily.
Read article
Advanced Excel
How to Convert Address to Lat Long in Excel (2 Quick Ways)
Learn how to convert addresses to latitude and longitude in Excel using the Geography data type and VBA code for precise results.
Read article
Advanced Excel
How to Convert Lat Long to UTM in Excel (2 Suitable Ways)
Learn how to convert latitude and longitude to UTM coordinates in Excel using VBA code, including Easting and Northing values accurately.
Read article
Advanced Excel
How to Calculate Weighted Moving Average in Excel
Learn how to calculate weighted moving average in Excel using SUMPRODUCT, helper columns, and the Data Analysis Toolpak for simple averages.
Read article
Excel Pro Tips
How to Unprotect Excel Workbook Without Password
Learn how to unprotect an Excel workbook without a password using VBA, editing XML files, copying data, or saving as an older XLS format.
Read article
Excel Pro Tips
How to Alternate Row Colors in Excel Without Table
Learn how to alternate row colors in Excel without using a table by applying conditional formatting or custom Nth-row formulas.
Read article
Excel Pro Tips
Highlight a Cell in Excel if Value Is Greater Than Another Cell
Learn how to highlight a cell in Excel if its value is greater than another cell using conditional formatting, formulas, and built-in rules.
Read article