Excel Functions & Formulas
Excel INDIRECT Function to Reference Different Sheets
Learn how to use the INDIRECT function in Excel to reference cells, ranges, and sheets dynamically for advanced cross-sheet data handling.
Read article
Author & Spreadsheet Consultant
Tasmia Rahim
268 Articles PublishedPublishing since
Tasmia Rahim holds a B.Sc in Electrical Engineering with a focus on automation and embedded systems, supporting logic-driven spreadsheet workflows. With 2 years of Excel and Google Sheets experience, she works with conditional formatting and basic automation. She is interested in using macros and ActiveX controls to simplify Excel tasks and improve usability.
Editorial Review
Articles Published by Tasmia Rahim
Articles by Tasmia Rahim 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 Functions & Formulas
How to Return the Cell Address of a Match in Excel
Learn how to return the cell address of a match in Excel using ADDRESS, MATCH, INDEX, XLOOKUP, CELL functions, and named ranges.
Read article
Excel Functions & Formulas
How to Use VLOOKUP with Two Lookup Values in Excel
Master using VLOOKUP with two lookup values in Excel by applying helper columns, the CHOOSE function, or nested formulas for precise results.
Read article
Excel Pro Tips
How to Return All Rows That Match Criteria in Excel
Discover how to return all rows that match criteria in Excel using FILTER, INDEX, SORT, and AGGREGATE functions for dynamic results.
Read article
Excel Pro Tips
How to Use Advanced Filter with Multiple Criteria in Excel
Learn how to use Excel's Advanced Filter with multiple criteria using AND, OR, wildcards, custom formulas, and even VBA techniques.
Read article
Excel Pro Tips
How to Count Unique Values in Excel with Multiple Criteria
Learn 8 easy ways to count unique values in Excel with multiple criteria using formulas, PivotTables, filters, or VBA—works in all versions.
Read article
Excel Pro Tips
How to Merge Rows with the Same Value in Excel (6 Methods)
Learn how to merge rows with the same value in Excel using Merge & Center, TEXTJOIN, Power Query, Consolidate, Subtotal, and VBA macros.
Read article
Excel Pro Tips
How to Combine Data from Multiple Sheets in Excel (4 Easy Ways)
Learn how to combine data from multiple Excel sheets using VSTACK, FILTER, Consolidate feature, and Power Query for seamless data merging.
Read article
Excel Pro Tips
How to Use VLOOKUP to Merge Two Excel Sheets
Learn how to merge two Excel sheets using VLOOKUP with standard, dynamic, and conditional methods for efficient data integration.
Read article
Excel Pro Tips
How to Consolidate Data in Excel from Multiple Columns
Learn how to consolidate data in Excel from multiple columns using formulas, tools like Power Query, Flash Fill, and advanced VBA methods.
Read article
Excel Pro Tips
How to Compare and Merge Excel Workbooks (5 Useful Methods)
Learn how to compare and merge Excel workbooks using Spreadsheet Compare, Inquire Add-in, Power Query, VBA, and built-in merge features.
Read article
Excel Pro Tips
How to Merge Excel Files into One Using CMD (with Simple Steps)
Learn how to merge multiple Excel files into one using CMD by converting to CSV, combining files via Command Prompt, and converting to XLSX.
Read article