Google Sheets Functions
How to Check If a Cell Contains Partial Text in Google Sheets
Learn how to check for partial text in Google Sheets using SEARCH, REGEXMATCH, VLOOKUP, and more to easily match and count text.
Read article
Blog
1285 articles
Google Sheets Functions
Google Sheets QUERY with GROUP BY to Summarize Data
Learn how to summarize data in Google Sheets using QUERY with GROUP BY to total, count, and average sales by region efficiently.
Read article
Google Sheets Functions
How to Use Google Sheets QUERY Across Multiple Sheets
Learn how to use Google Sheets QUERY across multiple sheets with IMPORTRANGE, array syntax, and INDIRECT for dynamic data filtering.
Read article
Google Sheets Functions
How to Count Cells That Contain Partial Text in Google Sheets
Learn how to count cells containing partial text in Google Sheets using COUNTIF for specific words or dynamic text from another cell.
Read article
Google Sheets Functions
VLOOKUP to Pull Data from Another Google Sheets Workbook
Learn how to use VLOOKUP to pull data from another Google Sheets workbook, combine with IMPORTRANGE, and fetch data across files.
Read article
Google Sheets Functions
IMPORTRANGE Function to Pull Data from Another Spreadsheet
Learn how to use IMPORTRANGE in Google Sheets to pull data from another spreadsheet, including named ranges and filtered imports.
Read article
Google Sheets Functions
How to Count Cells with Values in Google Sheets (4 Ways)
Learn how to count cells with values in Google Sheets using COUNTA, COUNTIF, COUNT, and COUNTBLANK functions for accurate data tracking.
Read article
Google Sheets Advanced Tutorials
How to Send Emails Based on Cell Values in Google Sheets
Learn how to send emails from Google Sheets based on cell values using Apps Script, triggers, add-ons, or macros.
Read article
Excel Pivot Table
How to Delete Calculated Field in Excel Pivot Table (2 Methods)
Learn how to delete a calculated field in Excel PivotTables manually or by using VBA for quick and efficient cleanup of your data.
Read article
Excel Pivot Table
How to Edit a Calculated Field in Excel Pivot Table
Learn how to edit calculated fields in Excel PivotTables by adding new fields and modifying existing formulas step by step.
Read article
Excel Pivot Table
How to Count Unique Values in Excel Pivot Table (2 Suitable Ways)
Learn how to count unique values in Excel PivotTables using the Data Model or by adding a helper column for accurate results.
Read article
Excel Pivot Table
How to Count the Number of Instances in Excel Pivot Table
Learn how to count the number of instances in an Excel PivotTable by creating the table, preparing it, and setting fields to count values.
Read article