Excel Pivot Table
How to Insert Slicer in Excel with Pivot Table (with Simple Steps)
Learn how to insert a slicer in Excel with a PivotTable, add filters, and design slicers for interactive and easy data analysis.
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 Show Top 10 in Pivot Table (with Filter & VBA)
Learn how to show the Top 10 items in a pivot table in Excel using built-in filters or VBA code for advanced customization.
Read article
Excel Pivot Table
How to Filter Values with Greater Than in Excel Pivot Table
Learn how to filter values using the Greater Than option in a pivot table, including using helper columns for advanced filtering needs.
Read article
Excel Pivot Table
How to Filter a Pivot Table with a Custom List in Excel
Learn how to filter a pivot table with a custom list in Excel by adding the list, refreshing the table, and applying the filter effectively.
Read article
Excel Pivot Table
How to Sort Pivot Table by Grand Total (Including VBA)
Learn how to sort a pivot table by grand total in Excel manually or using VBA code to organize data and highlight top or bottom values.
Read article
Excel Pivot Table
How to Sort Dates in a Pivot Table (with Simple & Detailed Steps)
Learn how to sort dates in a pivot table by creating or editing tables and ensuring dates are in the correct format for accurate sorting.
Read article
Excel Pivot Table
Transfer Pivot Table Row Labels in Separate Columns in Excel
Learn how to transfer pivot table row labels to separate columns in Excel by creating tables, transposing, and formatting the pivot table.
Read article
Excel Pivot Table
How to Change Pivot Table Layout in Excel (3 Suitable Options)
Learn how to change pivot table layout in Excel by adjusting basic layout, totals, rows, formatting, and using VBA scripts for customization.
Read article
Excel Pivot Table
How to Change Pivot Table Data Source in Excel
Learn how to change pivot table data source in Excel using Analyze tab, VBA, tables, and how to refresh manually or automatically.
Read article
Excel Pivot Table
How to Create a Pivot Table from Multiple Excel Tables
Learn how to create a pivot table from multiple Excel tables using Power Query, appending queries, and creating relationships step-by-step.
Read article
Excel Pro Tips
How to Convert Date to Text YYYYMMDD in Excel
Convert dates to YYYYMMDD format in Excel using TEXT, CONCATENATE, custom number formatting, or VBA for consistent text-based date values.
Read article
Excel Pro Tips
How to Create a Web Form to Populate an Excel Spreadsheet
Create a web form to populate an Excel spreadsheet. Learn how to build, share, and connect forms directly to Excel for easy data collection.
Read article