Google Sheets Functions
How to Use SUMIF in Google Sheets If Another Cell Contains Text
Learn how to use SUMIF in Google Sheets when another cell contains text, with exact or partial matches, SUMIFS, FILTER, and ARRAYFORMULA.
Read article
Blog
1285 articles
Google Sheets Formulas
How to Split Data and Get First Item in Google Sheets
Learn how to split data and get the first item in Google Sheets using SPLIT, INDEX, LEFT, SEARCH, and ARRAYFORMULA for multiple cells.
Read article
Google Sheets Formulas
How to Add Minutes to Time in Google Sheets (4 Easy Ways)
Learn how to add minutes to time in Google Sheets using TIME function, arithmetic methods, arrayformula, and column-based values.
Read article
Excel Pro Tips
How to Add Sort Button in Excel (4 Quick Methods)
Learn how to add a sort button in Excel using filters, keyboard shortcuts, VBA macros, and the built-in Sort feature on the Data tab.
Read article
Excel Pro Tips
How to Extract Text After Character in Excel (4 Suitable Ways)
Learn how to extract text after a character in Excel using MID, FIND, LEN, RIGHT, SEARCH functions, or the Text to Columns feature.
Read article
Excel Pro Tips
How to Subtract Minutes from Time in Excel (3 Suitable Ways)
Learn how to subtract minutes from time in Excel using the TIME function, fraction of day method, and dynamic adjustments with IF and TIME.
Read article
Excel Pro Tips
Calculate the Number of Weeks Between Two Dates in Excel
Learn how to calculate the number of weeks between two dates in Excel using DAYS, INT, DATEDIF, simple division, and TODAY functions.
Read article
Excel Pro Tips
How To Convert Timestamp To Date In Excel (5 Suitable Ways)
Learn how to convert timestamps to dates in Excel using TEXT functions, formulas for Unix timestamps, base date adjustments, or VBA methods.
Read article
Excel Pro Tips
How to Fill Blank Cells with Value Above in Excel (4 Easy Tricks)
Learn how to fill blank cells with the value above in Excel using Go To Special, VBA, Power Query Fill Down, or a simple formula method.
Read article
Excel Pro Tips
How To Split Excel Sheet into Multiple Sheets Based on Rows
Learn how to split an Excel sheet into multiple sheets based on rows using VBA, manual copy-paste, or Pivot Table options.
Read article
Excel Pro Tips
How to Convert Number to Hours and Minutes in Excel
Learn how to convert numbers to hours and minutes in Excel using formulas, functions, and formatting tips for accurate time calculations.
Read article
Excel Pro Tips
How to Make First Row as Header in Excel (3 Easy Methods)
Learn how to make the first row a header in Excel using Freeze Panes, converting data to a table, or applying headers in Power Query Editor.
Read article