Author & Spreadsheet Consultant

Mohammed Shafin Arshad

111 Articles PublishedPublishing since Sep 26, 2026

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.

Google Sheets Functions

How to Use Google Sheets QUERY to Order by Multiple Columns

Learn how to use Google Sheets QUERY function to sort data by multiple columns like join date and salary for better organization & analysis.

Jul 24, 2025

Read article

Google Sheets Basics

How to Join Two Google Sheets Based on a Column

Learn how to join two Google Sheets based on a column using VLOOKUP, IMPORTRANGE, QUERY, INDEX-MATCH, add-ons, and Google Apps Script.

Jul 24, 2025

Read article

Google Sheets Basics

How to Find All Cells with a Specific Value in Google Sheets

Learn how to find all cells with a specific value in Google Sheets using ARRAYFORMULA, VLOOKUP, INDEX-MATCH, FILTER & conditional formatting.

Jul 23, 2025

Read article

Google Sheets Functions

How to Use VLOOKUP with a Drop-Down List in Google Sheets

Learn how to use VLOOKUP with a drop-down list in Google Sheets to fetch data dynamically, including setting up dependent drop-downs.

Jun 28, 2025

Read article

Google Sheets Functions

How to Use SUMIF with Multiple Criteria in Google Sheets

Learn how to use SUMIF with multiple criteria in Google Sheets using SUMIFS, wildcards, cell references, or SUMPRODUCT for OR conditions.

Jun 28, 2025

Read article

Google Sheets Advanced Tutorials

How to Create & Customize a Pivot Table in Google Sheets

Learn how to create a Pivot Table in Google Sheets, combine data from multiple sheets, refresh sources, add filters or slicers for analysis.

Jun 28, 2025

Read article

Google Sheets Advanced Tutorials

How to Do Sensitivity Analysis in Google Sheets

Learn how to do sensitivity analysis in Google Sheets using tables, IF statements, dynamic charts, and data validation.

Jun 28, 2025

Read article

Google Sheets Advanced Tutorials

How to Model Scenarios with What-If Analysis in Google Sheets

Learn how to model scenarios with What-If Analysis in Google Sheets, using functions like IF, Goal Seek, and Scenario Manager.

Jun 28, 2025

Read article

Google Sheets Formulas

[Fixed] Google Sheets Formula Not Working: 9 Cases & Solutions

Learn how to fix issue with Google Sheets formulas by checking syntax, data types, hidden characters, and common formula errors.

Jun 28, 2025

Read article

Google Sheets Intermediate Tutorials

[Fixed] Show Edit History in Google Sheets Not Showing

Learn how to fix “Show Edit History” not showing in Google Sheets by verifying access, using version history, and resolving browser issues.

Jun 28, 2025

Read article

Google Sheets Intermediate Tutorials

[Fixed] Protect Range Not Showing in Google Sheets

Learn how to fix “Protect Range” option not showing in Google Sheets by enabling it, checking permissions, or clearing your browser cache.

Jun 28, 2025

Read article

Google Sheets Functions

How to Fix IMPORTRANGE Internal Error in Google Sheets

Fix IMPORTRANGE internal errors in Google Sheets by granting access, checking sheet names, using correct URLs, and testing before nesting.

Jun 28, 2025

Read article