Google Sheets Intermediate Tutorials
How to Count Checkboxes in Google Sheets (5 Quick Tricks)
Learn how to count checked and unchecked checkboxes in Google Sheets using COUNTIF, COUNTIFS, ARRAYFORMULA, and Apps Script methods.
Read article
Blog
1285 articles
Excel Pro Tips
How to Convert Date to Text YYYYMMDD in Excel
Convert dates to YYYYMMDD format in Excel using TEXT, CONCATENATE, custom number formatting, or VBA for consistent text-based date values.
Read article
Excel Pro Tips
How to Create a Web Form to Populate an Excel Spreadsheet
Create a web form to populate an Excel spreadsheet. Learn how to build, share, and connect forms directly to Excel for easy data collection.
Read article
Excel Pro Tips
How To Find First Occurrence of a Value in a Column in Excel
Learn how to find the first occurrence of a value in an Excel column using MATCH, MIN-IF-ROW, COUNTIF, and Find & Replace tools.
Read article
Excel Pro Tips
How to Extract Text Between Two Characters in Excel
Learn how to extract text between two characters in Excel using TEXTBEFORE, MID, Flash Fill, and other powerful functions easily.
Read article
Excel Pro Tips
How to Count Specific Characters in a Column in Excel (2 Cases)
Learn how to count specific characters in an Excel column, including counting character sets and total occurrences easily and accurately.
Read article
Excel Pro Tips
Change Lowercase to Uppercase in Excel Without a Formula
Change lowercase to uppercase in Excel without formulas using Flash Fill, VBA code, or Microsoft Word for quick and easy text transformation.
Read article
Excel Pro Tips
How to Convert Seconds to hh mm ss Format in Excel
Convert seconds to hh mm ss format in Excel using the TEXT function or custom number formatting for clear and readable time values.
Read article
Excel Pro Tips
How to Calculate Hours Between Two Times after Midnight in Excel
Learn how to calculate hours between two times after midnight in Excel using formulas, helper columns, and proper time formatting.
Read article
Google Sheets Basics
How to Find Merged Cells in Google Sheets (3 Simple Tricks)
Learn how to find merged cells in Google Sheets using Apps Script, filters, and quick tips to identify and list merged cells easily.
Read article
Google Sheets Basics
How to Use Custom Number Formats in Google Sheets
Learn how to use custom number formats in Google Sheets to add leading zeros, currency, units, abbreviations, and highlight negative numbers.
Read article
Google Sheets Basics
How to Go to the Next Line in Google Sheets in the Same Cell
Learn how to go to the next line in the same Google Sheets cell using shortcuts, CHAR(10), Excel import, or Apps Script.
Read article