Excel Functions & Formulas
How to Use COUNTIF Function to Calculate Percentage in Excel
Learn how to use COUNTIF in Excel to calculate percentages for text, numeric thresholds, completion rates, and non-blank responses easily.
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 Functions & Formulas
Excel COUNTIFS Function with 7 Advanced Practical Examples
Learn advanced Excel COUNTIFS techniques to count data by date ranges, partial matches, OR logic, exclusions, and structured references.
Read article
Excel Functions & Formulas
How to Rank Data in Excel with Sorting (5 Useful Methods)
Learn how to rank data in Excel with sorting using SORT, RANK, INDEX, and MATCH functions, plus VBA for automatic ranking and tie-breaking.
Read article
Excel Functions & Formulas
How to Use SUMIFS with Date Range by Month in Excel
Learn how to use SUMIF in Excel with a date range by month using SUMIFS, EDATE, and EOMONTH functions for dynamic & accurate monthly totals.
Read article
Excel Functions & Formulas
How to Use SUMIF with Not Equal to Condition in Excel
Learn how to use SUMIF in Excel with a not equal to condition to exclude values, skip blanks, apply wildcards, and handle multiple criteria.
Read article
Excel Functions & Formulas
SUMIFS with Multiple Criteria across Columns and Rows in Excel
Learn how to use SUMIFS in Excel with multiple criteria across columns and rows, including date ranges, wildcards, and numeric conditions.
Read article
Excel Pro Tips
How to Add Text to Beginning of Cell in Excel (7 Easy Methods)
Learn how to add text to the beginning of a cell in Excel using formulas, Flash Fill, custom formatting, or VBA for quick prefix insertion.
Read article
Excel Pro Tips
How to Count If Cell Contains Number in Excel (6 Easy Ways)
Learn how to count cells containing numbers in Excel using COUNT, COUNTIF, COUNTIFS, SUBTOTAL, and SUMPRODUCT with practical examples.
Read article
Excel Pro Tips
How to Edit a Named Range in Excel (with Quick Steps)
Learn how to edit a named range in Excel using Name Manager by changing the name or cell reference and saving your updates easily.
Read article
Excel Pro Tips
How to Find a Circular Reference in Excel (4 Effective Ways)
Discover how to find circular references in Excel using the Formulas tab, status bar, formula view, and by disabling iterative calculations.
Read article
Excel Pro Tips
4 Useful Examples of Mixed Cell Reference in Excel
Learn how to use mixed cell references in Excel with easy examples to lock rows or columns, boost accuracy, and simplify calculations.
Read article
Excel Pro Tips
How to Print with Comments in Excel (2 Suitable Ways)
Learn how to print comments in Excel, either at the end of the sheet or as displayed on the sheet, using simple Page Layout options.
Read article