Advanced Excel
How to Use INDEX-MATCH Formula with Three Criteria in Excel
Learn how to use the INDEX-MATCH formula with three criteria in Excel, including array and non-array methods, error handling, and TEXTJOIN.
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.
Excel Pro Tips
How to Create a Data Dictionary in Excel (with Detailed Steps)
Learn how to create a data dictionary in Excel with this step-by-step guide to organize, document, and manage your dataset efficiently.
Read article
Excel Pro Tips
How to Fix Spell Check Not Working Issues in Excel
Learn how to fix spell check not working in Excel with easy steps, from unprotecting sheets to customizing the dictionary.
Read article
Excel Pro Tips
How to Create a Search Box in Excel (4 Different Criteria)
Learn how to create a search box in Excel using FILTER, ISNUMBER, INDEX, MATCH, and Conditional Formatting for dynamic results.
Read article
Excel Pro Tips
How to Fix Break Links Not Working Problem in Excel
Learn how to fix broken links not working in Excel with simple methods like Paste Special, Name Manager, and Conditional Formatting.
Read article
Excel Pro Tips
How to Find Broken Links in Excel (4 Suitable Ways)
Learn how to find and fix broken links in Excel using Workbook Links, Find & Replace, VBA, and the Document Inspector tools.
Read article
Excel Pro Tips
How to Create a Hierarchy in Excel (2 Suitable Ways)
Learn how to create a hierarchy in Excel using SmartArt for automation or manually with shapes and arrows for full customization.
Read article
Excel Pro Tips
How to Create a Workflow Chart in Excel (with Simple Steps)
Learn how to create a workflow chart in Excel step-by-step using shapes, connectors, and formatting for a clear visual process flow.
Read article
Excel Pro Tips
How to Translate Portuguese to English in Excel (4 Easy Ways)
Learn how to translate Portuguese to English in Excel using functions, VBA, the Review tab, or the right-click context menu.
Read article
Excel Pro Tips
How to Merge 3 Columns in Excel (6 Simple Methods)
Learn how to merge 3 columns in Excel using TEXTJOIN, CONCAT, Power Query, LET, and other efficient formulas and functions.
Read article
Excel Pro Tips
How to Combine Rows with Same ID in Excel (3 Suitable Ways)
Learn how to combine rows with the same ID in Excel using TEXTJOIN, Power Query, or Pivot Tables to summarize and organize your data.
Read article
Excel Functions & Formulas
Excel VLOOKUP to Find a Value That Falls Between a Range
Learn how to use VLOOKUP and alternative Excel functions to find values that fall between a range for accurate data analysis.
Read article