Excel Pro Tips
How to Create a Lookup Table in Excel (5 Different Examples)
Learn how to create a lookup table in Excel using XLOOKUP, VLOOKUP, INDEX-MATCH, LOOKUP, and drop-down lists for fast data use.
Read article
Author & Spreadsheet Consultant
Fariha Tasnim
13 Articles PublishedPublishing since
Editorial Review
Articles Published by Fariha Tasnim
Articles by Fariha Tasnim 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 Flip Data Horizontally in Excel (4 Suitable Methods)
Learn how to flip data horizontally in Excel using Sort with a helper row, formulas, VBA macros, and handy Excel add-ins.
Read article
Excel Pro Tips
How to Find Blank Cells in Excel (6 Easy Ways)
Learn how to find blank cells in Excel using Go To Special, formulas, filters, conditional formatting, and VBA macros.
Read article
Excel Pro Tips
How to Show Column Numbers Instead of Letters in Excel
Learn how to show Excel column numbers instead of letters using R1C1 reference style, helper rows, and practical formula examples.
Read article
Excel Pro Tips
Delete Rows in Excel if a Cell Contains Specific Content
Learn how to delete rows in Excel if a cell contains specific content using filters, helper columns, Find tool, or VBA automation.
Read article
Google Sheets Basics
How to Swap Rows in Google Sheets (4 Quick Tricks)
Learn how to swap rows in Google Sheets using drag-and-drop, copy-paste, keyboard shortcuts, or a custom Apps Script method.
Read article
Google Sheets Basics
How to Change Row Height in Google Sheets (5 Simple Ways)
Learn how to change row height in Google Sheets by dragging, using the menu, scripts, or auto-fit for better spreadsheet control.
Read article
Google Sheets Basics
How to Fix Green Border Issues in Google Sheets
Learn how to fix green border issues in Google Sheets, from search highlights to filters, protected ranges, and shared file access.
Read article
Google Sheets Basics
How to Rotate Texts in Google Sheets (6 Suitable Examples)
Learn 6 easy ways to rotate text in Google Sheets, including toolbar, custom angle, merged cells, scripts, formulas, and drawing tool.
Read article
Google Sheets Basics
How to Use Google Sheets Offline (3 Different Tricks)
Learn how to use Google Sheets offline by enabling access, selecting specific files, and installing the required Chrome extension.
Read article
Google Sheets Basics
How to Custom Sort in Google Sheets (5 Different Ways)
Learn how to custom sort in Google Sheets using Sort Range, SORT, ARRAYFORMULA, and dropdown filters for tailored data views.
Read article
Google Sheets Formulas
How to Round Up to 2 Decimal Places in Google Sheets
Learn how to round up to 2 decimal places in Google Sheets using ROUND, ROUNDUP, ROUNDDOWN, number formatting, and toolbar options.
Read article