Google Sheets Formulas
How to Remove the First Character in Google Sheets (4 Formulas)
Learn how to remove the first character in Google Sheets using REPLACE, RIGHT+LEN, REGEXREPLACE, or the MID function effectively.
Read article
Author & Spreadsheet Consultant
Upama Chowdhury
42 Articles PublishedPublishing since
Upama Chowdhury holds a BSc in Statistics from Shahjalal University of Science & Technology, giving her a strong foundation in data analysis and spreadsheet logic. With eight years of experience, she works with advanced formulas, PivotTables, Power Query, dashboards, and automation using VBA and Google Apps Script. She has built interactive dashboards, automated workflows, and organized complex datasets into analysis-ready formats. She enjoys creating efficient, formula-driven solutions and practical spreadsheet tools.
Editorial Review
Articles Published by Upama Chowdhury
Articles by Upama Chowdhury 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 Formulas
How to Calculate Average in Google Sheets Ignoring 0 (Zero)
Learn how to calculate average in Google Sheets while ignoring 0 values using AVERAGEIF, FILTER, ARRAYFORMULA, and QUERY functions.
Read article
Google Sheets Formulas
How to Split Text to Rows in Google Sheets (2 Useful Formulas)
Learn how to split text to rows in Google Sheets using TRANSPOSE, SPLIT, and ARRAYFORMULA functions for efficient data transformation.
Read article
Google Sheets Basics
How to Format Phone Numbers in Google Sheets (2 Easy Ways)
Learn how to format phone numbers in Google Sheets using apostrophes, Find and Replace, or Custom Number Format for a clean, uniform look.
Read article
Google Sheets Basics
How to Hide Columns in Google Sheets from Certain Users
Learn how to hide columns in Google Sheets from certain users using QUERY, IMPORTRANGE, Filter functions & more!
Read article
Google Sheets Formulas
How to Calculate Age from Date Of Birth in Google Sheets
Learn how to calculate age from date of birth in Google Sheets using DATEDIF, YEARFRAC, and methods for years, months, and days.
Read article