Excel Pro Tips
How to Create a Search Box for Multiple Sheets in Excel
Learn how to create a search box for multiple sheets in Excel using FILTER, VSTACK, ActiveX controls, and dynamic formulas.
Read article
Author & Spreadsheet Consultant
Sazeda Rahman
104 Articles PublishedPublishing since
Sazeda Rahman Setu holds a BSc and MSc in Mathematics from National University, providing a strong foundation in analytical and logical thinking for spreadsheet work. Since May 2025, she has gained hands-on experience with Excel and Google Sheets, focusing on formulas, functions, troubleshooting, and step-by-step tutorials. She enjoys creating example datasets and clear guides to help beginners solve spreadsheet problems.
Editorial Review
Articles Published by Sazeda Rahman
Articles by Sazeda Rahman 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 Do Matrix Multiplication in Excel (3 Suitable Ways)
Learn how to do matrix multiplication in Excel using MMULT, SUMPRODUCT, and TRANSPOSE functions with clear examples.
Read article
Excel Charts
How to Make a Bar Graph in Excel with 3 Variables
Learn how to make a bar graph in Excel with 3 variables using clustered, stacked, and 100% stacked bar charts in 2-D or 3-D formats.
Read article
Excel Charts
How to Create a Stacked Column Chart in Excel (4 Examples)
Learn how to create 2-D and 3-D stacked column charts in Excel, including standard and 100% types, to visualize your data effectively.
Read article
Excel Pro Tips
How to Transpose Multiple Rows in Groups to Columns in Excel
Learn how to transpose multiple rows in groups to columns in Excel using formulas, Paste Special, Power Query, and VBA automation.
Read article
Excel Pro Tips
How to Transpose a Reference and Autofill in Excel
Learn how to transpose a reference and autofill in Excel using Copy Paste, TRANSPOSE, INDIRECT, INDEX, and Power Query methods.
Read article
Excel Pro Tips
How to Create an Employee Database in Excel
Learn how to create an employee database in Excel with structured tables, data validation, conditional formatting, and protection tips.
Read article
Excel Pro Tips
How to Use Structured Reference in Excel Formula (6 Examples)
Learn 6 easy methods to use structured references in Excel formulas, including SUM, AVERAGE, IF, VLOOKUP, and more.
Read article
Excel Pro Tips
How to Convert Image to Table in Excel (4 Suitable Ways)
Learn 4 easy methods to convert an image to a table in Excel using built-in tools, OneNote OCR, online OCR, and ChatGPT.
Read article
Excel Pro Tips
How to Add a Column to a Table in Excel (6 Easy Ways)
Learn step-by-step methods to add a column to a table in Excel using the ribbon, context menu, shortcuts, or Power Query.
Read article
Excel Pro Tips
How to Convert a Table to a Range in Excel (5 Easy Ways)
Learn how to convert a table to a range in Excel using Table Design, context menu, VBA, or by removing filters and formatting.
Read article
Excel Pro Tips
How to Sort Rows by Column in Excel (5 Effective Ways)
Learn how to sort rows by column in Excel using Sort & Filter, Sort dialog box, custom sorts, and the SORT function easily.
Read article