Google Sheets Intermediate Tutorials
How to Export Google Calendar to Google Sheets
Learn how to export Google Calendar events to Google Sheets using Apps Script or manually with Google Takeout in easy steps.
Read article
Author & Spreadsheet Consultant
Mohammed Shafin Arshad
111 Articles PublishedPublishing since
Mohammed Shafin Arshad is a Computer Science student and cybersecurity enthusiast in Malaysia with 6 years of Excel and Google Sheets experience. He specializes in VBA, macro automation, and SaaS-focused workflow guides. His background includes university data science projects, and he enjoys using macros to solve complex spreadsheet problems.
Editorial Review
Articles Published by Mohammed Shafin Arshad
Articles by Mohammed Shafin Arshad are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
![[Fixed] FILTER Function Not Working in Google Sheets](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-google-sheets-filter-not-working-a899aba5.webp)
Google Sheets Intermediate Tutorials
[Fixed] FILTER Function Not Working in Google Sheets
Learn how to fix the FILTER function not working in Google Sheets, including #N/A errors, wrong results, and range mismatch issues.
Read article
Google Sheets Functions
How to Fix 'Error Loading Data' in IMPORTRANGE in Google Sheets
Learn how to fix the “Error Loading Data” in IMPORTRANGE in Google Sheets by checking sheet names, ranges, access, and URL format.
Read article
Google Sheets Functions
How to Use ARRAYFORMULA with VLOOKUP in Google Sheets
Learn how to use ARRAYFORMULA with VLOOKUP in Google Sheets to apply lookups across rows, return unique results, and summarize form data.
Read article
![[Fixed] VLOOKUP Not Working in Google Sheets: 4 Cases](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-google-sheets-vlookup-not-working-c3d58a04.webp)
Google Sheets Functions
[Fixed] VLOOKUP Not Working in Google Sheets: 4 Cases
Discover how to fix VLOOKUP errors in Google Sheets, including #N/A issues, wrong values, formatting problems, and range errors.
Read article
Google Sheets Functions
SUMIF If Cells Are Not Blank Cells in Google Sheets (3 Examples)
Learn how to use SUMIF, FILTER, and SUMPRODUCT in Google Sheets to sum values only when cells are not blank for accurate results.
Read article
Google Sheets Functions
COUNTIF to Count Cells by Fill Color in Google Sheets (2 Ways)
Learn how to count cells by fill color in Google Sheets using Google Apps Script or a manual helper column for accurate tracking.
Read article
Google Sheets Functions
Return Value in Another Cell If Cell Contains Text in Google Sheets
Learn how to return a value in another cell if a cell contains text in Google Sheets using IF with SEARCH, EXACT, or REGEXMATCH functions.
Read article
Google Sheets Basics
How to Sort Rows by Column Value in Google Sheets (3 Ways)
Learn how to sort rows by column value in Google Sheets using the Data menu, SORT function, or QUERY function for dynamic sorting.
Read article
![[Fixed] Date Format Not Working in Google Sheets](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-google-sheets-date-format-not-working-fcc5ddbe.webp)
Google Sheets Basics
[Fixed] Date Format Not Working in Google Sheets
Fix date formatting issues in Google Sheets by confirming dates, correcting text issues, removing quotes, and using DATEVALUE and SUBSTITUTE.
Read article
![[Fixed] VLOOKUP Evaluates to an Out of Bounds Range](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-vlookup-evaluates-to-an-out-of-bounds-range-d391eb03.webp)
Google Sheets Functions
[Fixed] VLOOKUP Evaluates to an Out of Bounds Range
Fix the “VLOOKUP evaluates to an out of bounds range” error in Google Sheets by checking the column index and using the COLUMNS function.
Read article
![[Fixed] Cannot Find Range or Sheet for Imported Range](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-cannot-find-range-or-sheet-for-imported-range-5068d95e.webp)
Google Sheets Functions
[Fixed] Cannot Find Range or Sheet for Imported Range
Fix “Cannot Find Range or Sheet” error in Google Sheets by checking sheet names, ranges, access, URL format, and IMPORTRANGE syntax.
Read article