Excel for Finance
How to Calculate Annual Growth Rate in Excel (3 Criteria)
Learn how to calculate annual growth rate in Excel using formulas, functions, and methods like AVERAGE, RRI, and RATE for accurate results.
Read article
Author & Spreadsheet Consultant
Rudra Nil Utsa
128 Articles PublishedPublishing since
Rudra Nil Utsa holds a BBA and MBA in Marketing from Jahangirnagar University, where he developed strong analytical and spreadsheet-focused skills. With 3+ years of Excel experience, including 7 months dedicated to advanced workflows, he specializes in formulas, text functions, PivotTables, financial calculations, automation, and data cleanup. He has created extensive tutorials, workflow guides, and troubleshooting resources. He enjoys exploring formula tricks and automation techniques.
Editorial Review
Articles Published by Rudra Nil Utsa
Articles by Rudra Nil Utsa 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 for Finance
How to Create a Profit And Loss Statement in Excel
Learn how to create a profit and loss statement in Excel, from monthly to semiannual reports, using formulas and pivot tables.
Read article
Excel for Finance
XIRR vs IRR in Excel: Explained with Examples
Learn the key differences between XIRR and IRR in Excel, how to calculate them, and when to use each for accurate investment analysis.
Read article
Excel Pro Tips
How to Make an Excel File Read-Only (3 Suitable Ways)
Learn how to make an Excel file read-only by setting file preferences, adding a password, and applying OS-level protection.
Read article
Excel Pivot Table
Enable a Greyed‑Out Calculated Field in Excel Pivot Table
Learn how to enable a greyed-out calculated field in Excel Pivot Tables with easy steps to isolate and fix the issue quickly.
Read article
Excel Pivot Table
Calculated Field in Excel Pivot Table Based on Column Values
Learn how to create a calculated field in an Excel Pivot Table using column values with clear, step-by-step instructions.
Read article
Excel Pivot Table
How to Fix Missing Distinct Count in Pivot Tables
Learn how to fix missing distinct count in Excel Pivot Tables with easy solutions using the Data Model or upgrading Excel.
Read article
Excel Pivot Table
How to Remove Grand Total from Pivot Table in Excel
Learn how to remove grand totals from Pivot Tables in Excel using the Design tab, PivotTable options, and VBA for advanced control.
Read article
Excel Pivot Table
How to Fix a PivotTable Report Overlapping Error in Excel
Learn how to fix the “A PivotTable Report Cannot Overlap Another PivotTable Report” error by moving the table or adding space.
Read article
Excel Pivot Table
How to Fix a Pivot Table Not Showing All Data in Excel
Learn how to fix a Pivot Table not showing all data in Excel with steps to clear filters, refresh, expand, and adjust layout settings.
Read article
![[Fixed] 'Add This Data to the Data Model' Missing in Excel](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-add-this-data-to-the-data-model-missing-9123bcc6.webp)
Excel Pivot Table
[Fixed] 'Add This Data to the Data Model' Missing in Excel
Learn how to restore the missing “Add This Data to the Data Model” option in Excel by fixing file format, PivotTables, and version issues.
Read article
Excel Pivot Table
How to Fix Pivot Table Not Refreshing Issues in Excel
Learn how to fix Excel Pivot Table not refreshing issues with easy solutions for new data, filters, field errors, and overlaps.
Read article