Excel Pro Tips
How to Create an Autofill Form in Excel (with Detailed Steps)
Learn how to create an autofill form in Excel with checkboxes, dropdowns, macros, and automation to collect and display data efficiently.
Read article
Author & Spreadsheet Consultant
Mashrur Ibne Shams
45 Articles PublishedPublishing since
Mashrur Ibne Shams holds a BSc in Industrial and Production Engineering and is a Certified Supply Chain Analyst (CSCA). With 3 years of Excel and Google Sheets experience, he specializes in data cleaning, text extraction, advanced formulas, dynamic arrays, VBA automation, and Power Query. He has created step-by-step tutorials and custom VBA scripts for real-world datasets. He enjoys simplifying complex tasks, automating processes, and organizing data efficiently.
Editorial Review
Articles Published by Mashrur Ibne Shams
Articles by Mashrur Ibne Shams 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 Basics
How to Add Serial Numbers in Google Sheets (5 Simple Ways)
Learn how to add serial numbers in Google Sheets using Fill Handle, ROW, SEQUENCE, incremental addition, and ARRAYFORMULA techniques.
Read article
Google Sheets Intermediate Tutorials
How to Hide Sheets from Certain Users in Google Sheets
Learn how to hide sheets from certain users in Google Sheets using view-only permissions, IMPORTRANGE, or separate spreadsheets.
Read article
Google Sheets Functions
How to Concatenate Multiple Cells in Google Sheets
Learn how to concatenate multiple cells in Google Sheets using CONCATENATE, TEXTJOIN, JOIN functions, or the ampersand (&) operator.
Read article
Google Sheets Functions
How to Use VLOOKUP from Another Sheet in Google Sheets
Learn how to use VLOOKUP from another sheet in Google Sheets within the same workbook or between workbooks using IMPORTRANGE.
Read article
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
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
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