Google Sheets Intermediate Tutorials
How To Edit a Drop-Down List In Google Sheets
Learn how to edit a drop-down list in Google Sheets—add or remove items, change styles, show help text, and allow multiple selections easily.
Read article
Blog
1285 articles
Excel Pro Tips
How to Extract Text Before Character in Excel (6 Easy Ways)
Learn how to extract text before a character in Excel using TEXTBEFORE, LEFT & FIND, Flash Fill, Text to Columns, and VBA.
Read article
Excel Pro Tips
How to Lookup Partial Text Match in Excel (3 Suitable Examples)
Learn how to look up partial text matches in Excel using VLOOKUP with wildcards, INDEX & MATCH combo, and IF for conditional results.
Read article
Excel Pro Tips
How to Use Percentage Formula in Excel for Marksheet
Learn how to use percentage formulas in Excel for marksheets by calculating percentages, applying percent style, and finding obtained marks.
Read article
Excel Pro Tips
How to Paste Range Names in Excel (3 Simple Tricks)
Learn how to paste range names in Excel using the Formulas tab, keyboard shortcuts, and how to insert range names into formulas efficiently.
Read article
Excel Pro Tips
How to Return Only Value of Cell (Not Formula) in Excel
Learn how to return the value of a cell instead of the formula in Excel using Paste Special, F9 shortcut, Replace tool and others.
Read article
Excel Pro Tips
How to Enable Iterative Calculation in Excel (for All Versions)
Learn how to enable iterative calculation in Excel across all versions and use it for datasets, loan estimates, and solving equations.
Read article
Excel for Statistics
How to Perform Linear Extrapolation in Excel (5 Easy Ways)
This article explores how to perform linear extrapolation in Excel using arithmetic formula, LINEST, TREND, FORECAST.LINEAR, and Trendline.
Read article
Google Sheets Intermediate Tutorials
Conditional Formatting with Multiple Conditions in Google Sheets
Learn how to apply conditional formatting with multiple conditions in Google Sheets using AND, OR, exact match, ranges, and text-based rules.
Read article
Google Sheets Formulas
How to Extract Text Between Two Characters in Google Sheets
Learn how to extract text between two characters in Google Sheets using formulas to pull text from parentheses, brackets, hyphens, or braces.
Read article
Google Sheets Functions
How to Use IF Formula in Google Sheets with Multiple Conditions
Learn how to use the IF formula in Google Sheets with multiple conditions by combining IF with AND, OR, and using the IFS function.
Read article
Excel for Finance
How to Forecast in Excel Based on Historical Data (4 Methods)
Learn how to forecast data in Excel using linear trends, exponential smoothing, moving averages, and dedicated forecast sheets easily.
Read article