Excel Pro Tips
How to Sort IP Address in Excel (2 Effective Ways)
Learn how to sort IP addresses in Excel using custom formulas or VBA macros to organize data accurately and avoid sorting errors.
Read article
Author & Spreadsheet Consultant
Zahin Tasnim
22 Articles PublishedPublishing since
Zahin Tasnim Ridita holds a B.Sc. in Mechanical and Production Engineering from Islamic University of Technology. With 3 years of experience in Excel and Google Sheets, she specializes in data management, formulas, automation, charts, pivot tables, Power Tools, conditional formatting, and VLOOKUP. Zahin has a keen interest in all areas of spreadsheet expertise, focusing on optimizing workflows and improving data analysis through advanced spreadsheet functions.
Editorial Review
Articles Published by Zahin Tasnim
Articles by Zahin 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 Remove Line Breaks in Excel (4 Simple Ways)
Learn how to remove line breaks in Excel using Find and Replace, SUBSTITUTE, TRIM with CLEAN functions, or a VBA macro for quick cleanup.
Read article
Excel Pro Tips
How to Capitalize First Letter of Each Word in Excel
Learn how to capitalize the first letter of each word in Excel using the PROPER function, Flash Fill, or a custom VBA macro.
Read article
Excel Pro Tips
How to Calculate Total Hours in Excel (3 Suitable Ways)
Learn how to calculate total hours in Excel using correct time formats, MOD, TEXT, and conditional formulas for regular and overnight shifts.
Read article
Excel Pro Tips
How to Calculate 90 Days From Date in Excel (4 Easy Ways)
Learn how to calculate 90 days from a date in Excel using simple addition, DATE, EDATE for months, and WORKDAY to exclude weekends.
Read article
Excel Pro Tips
How to Create an Organizational Chart in Excel from a List
Learn how to create an organizational chart in Excel from a list using SmartArt, TAB for hierarchy, and the Visio Data Visualizer Add-in.
Read article
Excel Pro Tips
How to Display Day of Week from Date in Excel (4 Easy Ways)
Display the day of the week from a date in Excel using TEXT, WEEKDAY, CHOOSE functions, or by applying a custom date format easily.
Read article
Excel Pro Tips
How to Pull Data From Multiple Worksheets in Excel (3 Methods)
Learn how to pull data from multiple Excel worksheets into one using Power Query, VBA code, or the built-in Consolidate feature.
Read article
Google Sheets Intermediate Tutorials
How to Delete Version History in Google Sheets (2 Easy Ways)
Learn how to delete version history in Google Sheets by viewing, copying, and removing version data to keep your files clean and organized.
Read article
Excel Pro Tips
How to Sort by Last Name in Excel (4 Quick Approaches)
Learn how to sort data by last name in Excel using Find and Replace, Text to Columns, formulas, and Flash Fill for various name types.
Read article