Excel Pro Tips
How to Automatically Send Email Based on Date from Excel
Learn how to automatically send emails from Excel based on specific dates using VBA and the Workbook Open event to trigger the process.
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 Mailing Labels in Excel (3 Suitable Ways)
Learn how to create mailing labels in Excel using Word Mail Merge, VBA automation, or cell formatting for customized label designs.
Read article
Excel Pro Tips
How to Create a Mailing List in Excel (with Easy Steps)
Learn how to create a mailing list in Excel by setting up structure, entering valid contact data, organizing, sorting and exporting the list.
Read article
Excel Pro Tips
How to Mail Merge Without Microsoft Word in Excel
Learn how to perform mail merge without Word using Excel formulas, VBA macros, CSV exports, and tools like the Mailmeteor add-in.
Read article
Excel Pro Tips
How to Pull Data from Another Sheet Based on Criteria in Excel
Discover how to pull data from another sheet in Excel using VLOOKUP, INDEX & MATCH, FILTER, XLOOKUP, and Power Query based on criteria.
Read article
Excel Pro Tips
How to Extract Month and Day from Date in Excel (5 Easy Ways)
Learn how to extract month and day from a date in Excel using functions like MONTH, DAY, TEXT, CHOOSE, SWITCH, and Power Query.
Read article
Excel Pro Tips
Extract Data from a Table Based on Multiple Criteria in Excel
Learn multiple ways to extract data from a table in Excel using FILTER, SUMIFS, XLOOKUP, Power Query, and advanced formulas.
Read article
Excel Pro Tips
How to Use Data Validation with Custom Multiple Criteria in Excel
Learn how to use data validation with custom multiple criteria in Excel using AND/OR logic, COUNTIF, date rules, named ranges and lists.
Read article
Excel Pro Tips
How to Apply Data Validation Based on Another Cell in Excel
Learn how to apply data validation in Excel based on another cell using dependent drop-downs, IF formulas, custom rules, and VBA automation.
Read article
Excel Pro Tips
How to Circle Invalid Data in Excel (5 Effective Ways)
Learn how to circle invalid data in Excel using Data Validation, input messages, error alerts, conditional formatting, and helper columns.
Read article
Excel Pro Tips
How to Add Item to Drop‑Down List in Excel (5 Simple Ways)
Learn how to add items to a drop-down list in Excel by editing sources, using tables, extending named ranges, OFFSET, and UNIQUE formulas.
Read article
Excel Pro Tips
How to Create a Dynamic Dependent Drop Down List in Excel
Learn how to create a dynamic dependent drop-down list in Excel using named ranges, INDIRECT, XLOOKUP, and auto-updating, sorted lists.
Read article