Google Sheets Intermediate Tutorials
How to Protect Columns in Google Sheets (3 Simple Tricks)
Learn how to protect columns in Google Sheets using the main menu, context menu, or by setting warning messages to prevent unwanted edits.
Read article
Blog
1285 articles
Google Sheets Basics
How to Save Google Sheets to Desktop (3 Quick Ways)
Learn how to save Google Sheets to your desktop by creating shortcuts, downloading files locally, or managing them via Google Drive.
Read article
Excel for Statistics
How to Extrapolate a Graph in Excel (Linear & Non-Linear)
This article explores how to extrapolate a graph in Excel using Trendline and forecast features for linear and nonlinear data.
Read article
Excel Pro Tips
How to Automatically Send Email Based on Date from Excel
Learn how to automatically send emails from Excel based on specific dates using VBA and the Workbook Open event to trigger the process.
Read article
Excel Pro Tips
How to Create Mailing Labels in Excel (3 Suitable Ways)
Learn how to create mailing labels in Excel using Word Mail Merge, VBA automation, or cell formatting for customized label designs.
Read article
Excel Pro Tips
How to Create a Mailing List in Excel (with Easy Steps)
Learn how to create a mailing list in Excel by setting up structure, entering valid contact data, organizing, sorting and exporting the list.
Read article
Excel Pro Tips
How to Mail Merge Without Microsoft Word in Excel
Learn how to perform mail merge without Word using Excel formulas, VBA macros, CSV exports, and tools like the Mailmeteor add-in.
Read article
Excel Pro Tips
How to Pull Data from Another Sheet Based on Criteria in Excel
Discover how to pull data from another sheet in Excel using VLOOKUP, INDEX & MATCH, FILTER, XLOOKUP, and Power Query based on criteria.
Read article
Excel Pro Tips
How to Extract Month and Day from Date in Excel (5 Easy Ways)
Learn how to extract month and day from a date in Excel using functions like MONTH, DAY, TEXT, CHOOSE, SWITCH, and Power Query.
Read article
Excel Pro Tips
Extract Data from a Table Based on Multiple Criteria in Excel
Learn multiple ways to extract data from a table in Excel using FILTER, SUMIFS, XLOOKUP, Power Query, and advanced formulas.
Read article
Google Sheets Formulas
How to Calculate Duration Between Two Times in Google Sheets
Learn how to calculate duration between two times in Google Sheets using subtraction, TEXT function, and methods to separate hours & minutes.
Read article
Google Sheets Formulas
How to Randomize a List in Google Sheets (4 Quick Tricks)
Learn how to randomize a list in Google Sheets using the Randomize Range tool, context menu, RAND, and RANDBETWEEN functions.
Read article