Excel Pro Tips
Extract Data from Another Sheet Based on a Cell Value in Excel
Learn how to get data from another sheet in Excel using INDEX/MATCH, VLOOKUP, INDIRECT, HLOOKUP, and Advanced Filter methods.
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 Pro Tips
How to Create a Flowchart in Excel (with 4 Easy Steps)
Learn how to create a flowchart in Excel by inserting shapes, adding connectors, aligning steps & customizing formatting for clear visuals.
Read article
Excel Pro Tips
How to Insert Excel Chart into PowerPoint (2 Suitable Ways)
Learn how to insert Excel chart into PowerPoint as a static image or with a live link to keep your presentations dynamic and up to date.
Read article
Excel Pro Tips
How to Create a Fillable PDF from Excel (2 Useful Methods)
Learn how to create a fillable PDF from Excel by using prebuilt templates or designing custom forms with interactive, fillable fields.
Read article
Excel Pro Tips
How to Save Excel as PDF Without Cutting Off (4 Simple Ways)
Learn how to save Excel as PDF without cutting off data by adjusting paper size, orientation, scaling options, and page setup settings.
Read article
Excel Pro Tips
How to Count Duplicate Values Only Once in Excel (6 Methods)
Learn how to count duplicate values only once in Excel using functions like EXACT, MATCH, SUMPRODUCT, UNIQUE, Advanced Filter, and more.
Read article
Excel Pro Tips
How to Merge Duplicate Rows in Excel (5 Effective Ways)
Learn how to merge duplicate rows in Excel using Consolidate, UNIQUE, PivotTables, Power Query, or VBA to clean and organize data.
Read article
Excel Pro Tips
How to Remove Dashes from SSN in Excel (5 Useful Techniques)
Learn how to remove dashes from SSNs in Excel using Find & Replace, SUBSTITUTE, Flash Fill, Power Query, or VBA for quick cleanup.
Read article
Excel Pro Tips
How to Remove First 3 Characters in Excel (6 Suitable Ways)
Learn how to remove first 3 characters in Excel using RIGHT, MID, REPLACE, Flash Fill, Text to Columns, or VBA for quick data editing.
Read article
Excel Pro Tips
How to Remove Space After Text in Excel (6 Effective Ways)
Learn how to remove space after text in Excel using Find & Replace, TRIM, LEFT, SUBSTITUTE, Power Query, or VBA for clean and accurate data.
Read article
Excel Pro Tips
How to Remove Space Before Numbers in Excel (5 Suitable Ways)
Learn how to remove space before numbers in Excel using Find & Replace, TRIM, MID & FIND, Data Validation, or VBA for clean data.
Read article
Excel Pro Tips
How to Remove Compatibility Mode in Excel (2 Simple Ways)
Learn how to remove Compatibility Mode in Excel using the “Save As” feature or the “Convert” option for seamless editing in modern formats.
Read article