Google Sheets Intermediate Tutorials
How to Create Multiple Dependent Drop Down List in Google Sheets
Learn how to create multiple dependent drop-down lists in Google Sheets using named ranges, backend sheets, and data validation steps.
Read article
Author & Spreadsheet Consultant
Ashfqur Rumon
5 Articles PublishedPublishing since
Ashfaqur Rumon is an SEO expert and digital marketing strategist with over 5 years of experience in content planning, social media, and online campaigns. As Head of Digital Marketing at WebTech, he drives growth through data-driven SEO and content strategies. A graduate of BUET in Civil Engineering, Rumon blends technical expertise with creative problem-solving to deliver impactful digital solutions.
Editorial Review
Articles Published by Ashfqur Rumon
Articles by Ashfqur Rumon 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 Intermediate Tutorials
How to Use Custom Data Validation Formula in Google Sheets
Learn how to use custom data validation formulas in Google Sheets to enforce number ranges, prevent duplicates, and apply regex-based rules.
Read article
Google Sheets Formulas
How to Split a Cell Horizontally In Google Sheets (5 Useful Methods)
Learn how to split a cell horizontally in Google Sheets using “Split Text to Columns,” SPLIT, REGEXEXTRACT, line breaks, and ARRAYFORMULA.
Read article
Google Sheets Basics
How to Change the Number Format in Google Sheets
Learn how to change number formats in Google Sheets, including text conversion, time, duration, decimals, and custom formatting examples.
Read article
Google Sheets Formulas
How to Merge Cells in Google Sheets Without Losing Data
Learn how to merge cells in Google Sheets without losing data using CONCATENATE, JOIN, TEXTJOIN, ampersand (&), CHAR(10), and Apps Script.
Read article