Excel Pro Tips
How to Rotate a Table in Excel (5 Different Examples)
Learn how to rotate an Excel table using Transpose, formatting tools, and formulas to flip data 90° or 180° for easier viewing and analysis.
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 Create a Table in Excel from Existing Data
Learn how to turn existing data into an Excel table using Insert, shortcuts, Power Query, Text to Columns & VBA for structured formatting.
Read article
Excel Pro Tips
How to Alternate Row Color Based on Group in Excel
Learn how to alternate row colors in Excel based on groups using formulas, helper columns, and conditional formatting for any group size.
Read article
Excel Pro Tips
How to Highlight Cells That Contain Text from a List in Excel
Learn how to highlight cells containing text from a list in Excel using COUNTIF, MATCH, SEARCH, and SUMPRODUCT for exact and partial matches.
Read article
Excel Pro Tips
Excel Conditional Formatting Based on a Date in Another Cell
Learn how to apply conditional formatting based on dates in another cell, including highlighting before, after, equal & row-based date rules.
Read article
Excel Pro Tips
Excel Conditional Formatting Rules Based on Another Column
Learn how to set conditional formatting rules for a column based on another column in Excel using formulas for numbers & text conditions.
Read article
Advanced Excel
How to Use SUMPRODUCT with INDEX-MATCH Formula in Excel
Learn how to use SUMPRODUCT with INDEX-MATCH in Excel to sum data by text, cell references, multiple criteria, numeric conditions, etc.
Read article
Excel Pro Tips
Excel Conditional Formatting Formulas If Cell Contains Text
Learn how to use Conditional Formatting formulas in Excel to highlight cells containing specific, partial or multiple text values.
Read article
Excel Functions & Formulas
INDEX-MATCH with Multiple Criteria Across Rows and Columns
Learn how to use the INDEX-MATCH formula with multiple criteria across rows and columns in Excel to extract and lookup values efficiently.
Read article
Advanced Excel
How to Combine SUMIF with INDEX-MATCH Formula in Excel
Learn how to combine SUMIF with INDEX-MATCH in Excel to create dynamic, criteria-based summations and advanced lookup formulas.
Read article
Advanced Excel
How to Combine IF Function with INDEX-MATCH Formula in Excel
Learn how to combine IF with INDEX-MATCH in Excel for dynamic lookups, error handling, and conditional value extraction.
Read article
Advanced Excel
Return Multiple Values Vertically with INDEX-MATCH in Excel
Learn how to use the INDEX-MATCH formula in Excel to return multiple values vertically, including partial matches and multi-criteria results.
Read article