Excel Pivot Table
How to Edit a Calculated Field in Excel Pivot Table
Learn how to edit calculated fields in Excel PivotTables by adding new fields and modifying existing formulas step by step.
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 Pivot Table
How to Count Unique Values in Excel Pivot Table (2 Suitable Ways)
Learn how to count unique values in Excel PivotTables using the Data Model or by adding a helper column for accurate results.
Read article
Excel Pivot Table
How to Count the Number of Instances in Excel Pivot Table
Learn how to count the number of instances in an Excel PivotTable by creating the table, preparing it, and setting fields to count values.
Read article
Excel Pivot Table
How to Remove Subtotal in Excel Pivot Table (3 Suitable Cases)
Learn how to remove subtotals in Excel PivotTables for all fields or specific ones manually or by using VBA for a cleaner table view.
Read article
Excel Pivot Table
How to Show Grand Total at Top in Excel Pivot Table
Learn how to show the grand total at the top of an Excel PivotTable using formulas, XLOOKUP, MAX, source changes, or the data model.
Read article
Excel Pivot Table
How to Show Actual Value Not Sum in Excel Pivot Table
Learn how to show actual values instead of sums in Excel PivotTables by creating measures and organizing fields for accurate data display.
Read article
Excel Pivot Table
How to Add a Pivot Table to the Data Model in Excel (2 Methods)
Learn how to add a pivot table to the data model in Excel, including steps for new and existing tables and managing your data model.
Read article
Excel Pivot Table
How to Remove Pivot Table but Keep Data in Excel (2 Easy Ways)
Learn how to remove a PivotTable but keep data in Excel by copying values, formats, or using VBA for quick and clean results.
Read article
Excel Pivot Table
How to Convert Pivot Table to a Table in Excel (2 Quick Methods)
Learn how to convert a PivotTable to a regular table in Excel manually or automatically using VBA for easier data editing.
Read article
Excel Pivot Table
How to Copy a Pivot Table to Another Sheet in Excel (4 Easy Ways)
Learn how to copy a PivotTable to another Excel sheet using clipboard, dragging, Move or Copy dialog, duplicating sheets, or VBA code.
Read article
Excel Pivot Table
How to Use GETPIVOTDATA with Dynamic Referencing in Excel
Learn how to use GetPivotData in Excel with dynamic referencing by converting static references for flexible and accurate data retrieval.
Read article
Excel Pivot Table
How to Create a Chart from a Pivot Table (2 Easy Methods)
Learn how to create a chart from a PivotTable in Excel, including manual methods and keyboard shortcuts for quick Pivot Chart creation.
Read article