Excel Pro Tips
How to Display Text from Another Cell in Excel (8 Examples)
Display text from another cell in Excel using direct references, TEXT formatting, lookup formulas, named ranges, or conditional logic.
Read article
Author & Spreadsheet Consultant
Abdul Kader
15 Articles PublishedPublishing since
Md. Abdul Kader holds a Bachelor in Urban and Regional Planning from Chittagong University of Engineering & Technology and has 2.5 years of Excel and Google Sheets experience. He specializes in data analysis, PivotTables, Power Query, charts, advanced formulas, statistics, and VBA automation. Promoted to Team Lead as an Excel & VBA content developer, he is passionate about dashboards, Power BI, and using Power Query to simplify data workflows.
Editorial Review
Articles Published by Abdul Kader
Articles by Abdul Kader 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 Trace Errors in Excel (2 Easy Methods)
Trace errors in Excel using the Trace Error feature from the context menu or Formulas tab to quickly identify and fix formula issues.
Read article
Excel Pro Tips
How to Make Excel Look Like a Page (with Simple Steps)
Make Excel look like a page using Page Setup, fit data to one page, adjust margins, add headers and footers, and preview print.
Read article
Excel Pro Tips
How to Recover Excel File After Crash (6 Possible Solutions)
Recover Excel files after a crash using Document Recovery, AutoRecover files, OneDrive restore, temp files, or unsaved workbooks.
Read article
Excel Pro Tips
How to Check Edit History in Excel Online (2 Quick Ways)
Learn how to check edit history in Excel Online using Show Changes to view edits or Version History to track full file changes.
Read article
Excel Functions & Formulas
How to Perform Case-Sensitive Vlookup in Excel (4 Examples)
Learn 4 effective ways to perform case-sensitive VLOOKUP in Excel using CHOOSE, EXACT, XLOOKUP, SUMPRODUCT, and INDEX-MATCH functions.
Read article
Excel Pro Tips
Millimeter (mm) to Square Meter (sq. m) Formula in Excel
Learn how to convert mm to square meters in Excel with formulas and examples for both square and rectangular shapes.
Read article
Excel Charts
How to Color Scatter Plot by Group in Excel (2 Useful Ways)
Learn how to color a scatter plot by group in Excel using helper columns or VBA code for clearer and more insightful data visualization.
Read article
Excel Charts
How to Create a Scatter Plot in Excel with 2 Variables (2 Scenarios)
Learn how to create a scatter plot in Excel with two variables—adjacent or non-adjacent—using simple steps and customization tips.
Read article
Excel Charts
How to Make Scatter Plot in Excel with Two Sets of Data
Learn how to create a scatter plot in Excel with two sets of data using easy steps for clear and effective data visualization.
Read article
Excel Pro Tips
How to Combine Two Formulas in Excel (5 Effective Ways)
Learn 5 easy ways to combine formulas in Excel, from using & and CONCAT to advanced techniques like INDEX-MATCH and nested IF statements.
Read article
Excel Pro Tips
Difference Between Absolute & Relative Cell References in Excel
Learn the key differences between absolute and relative references in Excel and how they affect copying or moving formulas in your sheets.
Read article