Excel Pro Tips
Custom Format to Add Text after Number in Excel
Learn how to add text after numbers in Excel using custom formats, conditional suffixes, scaling, symbols, and VBA alternatives.
Read article
Author & Spreadsheet Consultant
Ramisa Anjum
39 Articles PublishedPublishing since
Ramisa Anjum is pursuing a Computer Science and Engineering degree at North South University, building strong analytical and technical skills. With 3+ years of hands-on Excel and Google Sheets experience, she specializes in advanced text functions, complex logical formulas, lookup systems, macro automation, data cleaning, and instructional modeling. She has created structured datasets and enjoys simplifying complex tasks through formulas and automation.
Editorial Review
Articles Published by Ramisa Anjum
Articles by Ramisa Anjum 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 Functions & Formulas
How to Use SUMPRODUCT with IF Function in Excel
Learn how to use the SUMPRODUCT with IF function in Excel for single, multiple, and advanced conditions, including VBA examples.
Read article
Excel Functions & Formulas
How to Use SUMPRODUCT Across Multiple Columns in Excel
Learn how to use SUMPRODUCT across multiple columns in Excel, apply criteria, OR logic, dynamic ranges, and custom VBA functions.
Read article
Excel Functions & Formulas
How to Use SUMPRODUCT Function in Excel with Multiple Criteria
Learn how to use the SUMPRODUCT function in Excel with multiple criteria, including numeric, text, OR conditions, and VBA examples.
Read article
Excel Functions & Formulas
How to Sum Ranges of Multiple Columns with SUMIFS in Excel
Learn how to sum ranges across multiple columns in Excel using SUMIFS, BYCOL, INDEX, OFFSET, VBA, and other powerful methods.
Read article
Excel Pro Tips
How To Write Text And Formula in the Same Cell in Excel
Learn how to combine text and formulas in the same Excel cell using &, CONCAT, TEXTJOIN, VBA, Power Query, and IF functions.
Read article
Excel Pro Tips
How to Combine Text and Numbers in Excel (6 Suitable Ways)
Learn how to combine text and numbers in Excel using formulas, VBA, and Power Query for clean, dynamic, and well-formatted results.
Read article
Excel Pro Tips
How to Count Cells with Specific Text in Excel (7 Easy Ways)
Learn how to count cells with specific text in Excel using COUNTIF, SUMPRODUCT, FILTER, wildcards, VBA, and more.
Read article
Excel Pro Tips
How to Calculate Food Cost Percentage with Excel Formula
Learn how to calculate food cost percentage in Excel using formulas, tables, VBA, and charts to track and automate your restaurant costs.
Read article
Excel Pro Tips
How to Use Dynamic Named Range in Excel (5 Examples)
Master dynamic named ranges in Excel using OFFSET, INDEX, Tables, or VBA to create flexible, auto-updating ranges for smarter data handling.
Read article
Excel Pro Tips
How to Reference Cell in Another Excel Sheet Dynamically
Learn how to reference a cell in another Excel sheet dynamically using INDIRECT, drop-downs, named ranges, VBA, CHOOSE, or INDEX functions.
Read article
Excel Pro Tips
How to Find Multiple Values in Excel (6 Effective Methods)
Learn how to find multiple values in Excel using FILTER, TEXTJOIN, INDEX-SMALL-IF, Advanced Filter, VBA macros, or Power Query methods.
Read article