Excel Pivot Table
How to Create a Dropdown from a Slicer in Excel (with Easy Steps)
Learn how to create a dropdown from a slicer in Excel with simple steps—add a slicer, customize your pivot table, and finalize the dropdown.
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 Hide Filter Arrows in Excel Pivot Table
Learn how to hide filter arrows in Excel Pivot Tables by disabling field headers, captions, and using VBA for complete control.
Read article
Excel Pivot Table
How to Create and Use a Pivot Table Timeline in Excel
Learn how to create, use, and customize a Pivot Table Timeline in Excel, fix errors, and connect multiple Pivot Tables easily.
Read article
Excel Pivot Table
How to Filter Date Range in an Excel Pivot Table (4 Methods)
Learn how to filter a date range in an Excel Pivot Table using date filters, timelines, source data changes, or manual selection.
Read article
Excel Pivot Table
How to Filter Multiple Columns in an Excel Pivot Table
Learn how to filter multiple columns in an Excel Pivot Table using values, categories, and by adding multiple filters effectively.
Read article
Excel Pivot Table
How to Fix Dates Grouping Issues in Excel Pivot Table
Learn how to fix date grouping issues in Excel Pivot Tables with clear steps: check source data, adjust range, and create a new table.
Read article
Excel Pivot Table
How to Group a Pivot Table by Week in Excel (with Simple Steps)
Learn how to group a Pivot Table by week in Excel with easy steps using the Grouping option to organize your data efficiently.
Read article
Excel Pivot Table
How to Group a Pivot Table by Month in Excel (2 Criteria)
Learn how to group Pivot Tables by month in Excel using simple steps or create advanced custom groupings for better data analysis.
Read article
Excel Pivot Table
How to Fix Pivot Table Analyze Tab Missing Issue in Excel
Learn how to fix the missing PivotTable Analyze tab in Excel with these simple steps, from ribbon reset to Office 365 repair.
Read article
Excel Pivot Table
How to Move a Pivot Table in Excel (3 Simple Ways)
Learn how to move a Pivot Table in Excel using the Ribbon, Cut & Paste, or Drag & Drop methods with this easy step-by-step guide.
Read article
Excel Pivot Table
How to Collapse All Rows in a Pivot Table in Excel
Learn 5 easy methods to collapse all rows in an Excel Pivot Table using the context menu, ribbon, shortcuts, mouse, or VBA code.
Read article
Excel Pivot Table
How to Get Pivot Table Menu Back in Excel (3 Simple Ways)
Learn how to get the Pivot Table menu back in Excel using the context menu, ribbon options, or handy keyboard shortcuts.
Read article