Excel Pro Tips
How to Calculate Win-Loss Percentage in Excel (5 Easy Ways)
Learn how to calculate win-loss percentages in Excel using formulas, text-based data, sales stats, and even automate it with a VBA macro.
Read article
Author & Spreadsheet Consultant
Sohana Chowdhury
64 Articles PublishedPublishing since
With 3 years of experience in Excel and Google Sheets, Sohana Chowdhury specializes in turning messy data into organized insights through VBA, Power Query, and advanced formulas. She also brings a strong editorial background as a profound writer at Livingston Research, where her work is grounded in sharp research and analytical rigor. Whether she is designing a dynamic dashboard or delivering high-level content, Sohana ensures precision, efficiency, and expert analysis in every project.
Editorial Review
Articles Published by Sohana Chowdhury
Articles by Sohana Chowdhury 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 Undo Changes in Excel after Save and Close
Learn how to undo changes in Excel after saving and closing using AutoSave, backups, file history, and recovering unsaved versions.
Read article
Excel Pro Tips
How to Add a Comma Between Names in Excel (8 Different Ways)
Learn how to add a comma between names in Excel using Flash Fill, SUBSTITUTE, TEXTJOIN, CONCATENATE, Power Query, and VBA.
Read article
Excel Pro Tips
How to Randomize a List of Names in Excel (6 Quick Methods)
Learn how to randomize a list of names in Excel using RAND, RANDBETWEEN, INDEX, SORTBY, CHOOSE, Power Query, and custom VBA for shuffling.
Read article
Excel Pro Tips
How to Randomly Select from a List in Excel (5 Useful Ways)
Learn how to randomly select from a list in Excel using Data Analysis, INDEX with RANDBETWEEN, RANDARRAY, RAND, and custom VBA macros.
Read article
Excel Pro Tips
How to Return Multiple Values Based on Single Criteria in Excel
Learn how to return multiple values based on single criteria in Excel using FILTER, INDEX, TEXTJOIN, Power Query, and custom VBA macros.
Read article
Excel Pro Tips
How to Return Row Number of Match in Excel (8 Suitable Ways)
Learn how to return the row number of a match in Excel using ROW, MATCH, INDEX, IF, TEXTJOIN, and VBA for single or multiple matches.
Read article
Excel Pro Tips
Excel Conditional Formatting Based on Another Cell Range
Learn how to apply Excel conditional formatting based on another cell range using operators, text rules, AND/OR logic, and VBA.
Read article
Excel Pro Tips
How to Flip a Table in Excel (8 Suitable Ways)
Learn how to flip a table in Excel vertically or horizontally using SORTBY, INDEX, TRANSPOSE, Power Query, or VBA for table inversion.
Read article
Excel Pro Tips
How to Sort a Drop Down in Excel (5 Useful Techniques)
Learn how to sort a drop-down list in Excel using SORT, COUNTA with OFFSET, Power Query, or VBA for dynamic and alphabetically ordered lists.
Read article
Excel Pro Tips
How to Delete Blank Cells in Excel and Shift Data Up
Learn how to delete blank cells in Excel and shift data up using Go To Special, FILTER, Sort, Power Query, and VBA for organized sheets.
Read article
Excel Pro Tips
How to Extract Text Before Character in Excel (6 Easy Ways)
Learn how to extract text before a character in Excel using TEXTBEFORE, LEFT & FIND, Flash Fill, Text to Columns, and VBA.
Read article