DPTutorials

Welcome to dptutorials, where Excel analytics becomes simple and powerful. In this video, you’ll learn how to find unique values in Excel based on a specific condition using modern Excel formulas. This is a very common real-world requirement when working with HR data, sales records, audit lists, or MIS reports. Instead of manually removing duplicates or using Pivot Tables, this tutorial demonstrates a clean and dynamic solution using the UNIQUE and FILTER functions. The result updates automatically whenever the criteria or source data changes, making it perfect for dashboards and reusable reports. A large real-world dataset with 50 rows is included so you can practice immediately. If you want to master conditional data extraction in Excel and solve interview-level problems confidently, this is a must-know Excel technique. Subscribe to dptutorials for more Excel formulas, analytics tricks, and real-world productivity tutorials. Can You Find Unique Values in Excel in Just 1 Minute with This Simple Trick #ExcelShorts #ExcelTips #ExcelFormulas

Welcome to dptutorials, where Excel analytics is explained clearly and practically. In this video, you’ll learn how to calculate percentiles in Excel using the PERCENTILE.INC function. Percentiles are widely used to understand data distribution, performance benchmarking, and ranking analysis. This tutorial explains what percentiles mean in simple terms and shows how to calculate common percentiles like the 25th, 50th, 75th, and 90th percentile. You’ll also learn the important difference between PERCENTILE.INC and PERCENTILE.EXC, which is a frequent interview question. A real-world dataset with 50 values is included so you can practice immediately. If you want to strengthen your Excel analytics skills and confidently handle percentile-based questions, this is a must-know Excel concept. Subscribe to dptutorials for more Excel formulas, analytics tricks, and real-world productivity tutorials. Percentile Calculation in Excel | Simple Explanation #ExcelShorts #ExcelTips #ExcelAnalytics

Welcome to dptutorials! In this Primavera P6 Desktop tutorial, you’ll learn how to create a professional 3-Week Look Ahead Plan directly from your project schedule — without exporting to Excel or using any external tools. This video covers: What a 3-Week Look Ahead Plan is Why it’s critical for site execution How to use Data Date, Filters, and Layouts How to extract only executable activities How to exclude completed and non-site tasks How to present a clean look-ahead report We’ll use a realistic construction project example so you can apply this method immediately on your live projects. This tutorial is ideal for: Planning Engineers Site Engineers PMO Teams Project Managers Primavera P6 Users 👍 Like | 🔔 Subscribe | 💬 Comment for more Primavera P6 tutorials every week. #PrimaveraP6 #DPTutorials #LookAheadPlan #ConstructionPlanning #P6Training #ProjectManagement #SitePlanning #PrimaveraTips #PMO #WeeklyPlanning

Welcome to dptutorials, where Excel analytics becomes simple and practical. In this video, you’ll learn how to extract the bottom 5 values per category in Excel using formulas only. This technique is widely used to identify low performers, risks, and problem areas in business data. Instead of sorting data manually or using Pivot Tables, this tutorial uses the powerful combination of FILTER, SMALL, and ROW functions to dynamically return the lowest values for any selected category. The result updates instantly when the category changes, making it ideal for dashboards and management reports. A real-world dataset with 50 rows is included so you can practice immediately. If you want to master Excel analytics and handle interview-level problems confidently, this is a must-know formula technique. Subscribe to dptutorials for more Excel formulas, reporting tricks, and real-world productivity tutorials. Bottom 5 Values per Category in Excel | Formula Trick #ExcelShorts #ExcelTips #ExcelFormulas

Welcome to dptutorials, where Excel analytics becomes simple and powerful. In this video, you’ll learn how to extract the top 5 values per month in Excel using formulas only. This is a very common requirement in sales analysis, finance reports, and management dashboards. Instead of relying on Pivot Tables, this tutorial demonstrates a dynamic formula-based approach using FILTER, LARGE, and ROW functions. The result updates automatically when the month selection changes, making it perfect for dashboards and reusable reports. A real-world dataset with 50 rows is included so you can practice immediately. If you want to improve your Excel analytics skills and solve interview-level problems confidently, this is a must-know technique. Subscribe to dptutorials for more Excel formulas, reporting tricks, and real-world productivity tutorials. Top 5 Values per Month in Excel Formula Method #ExcelShorts #ExcelTips #ExcelFormulas

Welcome to dptutorials, where Excel reporting becomes smarter and faster. In this video, you’ll learn how to create running totals in Excel without using any formulas. Most users rely on SUM formulas for cumulative totals, but Excel provides a built-in method that is cleaner and more powerful. This tutorial shows how to use Pivot Tables and the “Show Values As – Running Total” option to calculate cumulative totals automatically. The running total updates dynamically when data changes or filters are applied, making it perfect for sales reports, financial analysis, and MIS dashboards. A real-world dataset with 50 rows is included so you can practice immediately. If you want error-free, professional running totals without maintaining formulas, this is a must-know Excel technique. Subscribe to dptutorials for more Excel tips, reporting tricks, shortcuts, and real-world productivity tutorials. Create Running Totals in Excel WITHOUT Using Formulas #ExcelShorts #ExcelTips #ExcelReports

Welcome to dptutorials, where Excel reporting becomes simple and professional. In this video, you’ll learn how to create subtotals automatically in Excel using the built-in Subtotal feature. This method eliminates the need for manual SUM formulas and ensures accurate group-wise totals. The tutorial explains how to sort data correctly, apply the Subtotal command, and use outline levels to expand or collapse detailed information. Subtotals are widely used in sales reports, finance summaries, MIS dashboards, and management reviews. A large real-world dataset with 50 rows is included so you can practice immediately. If you want to build clean, expandable, and management-ready Excel reports, this is a must-know Excel feature. Subscribe to dptutorials for more Excel tips, reporting tricks, shortcuts, and real-world productivity tutorials. Create Subtotals Automatically in Excel | Step by Step #ExcelShorts #ExcelTips #ExcelReports

Welcome to dptutorials, where Excel reporting becomes professional and powerful. In this video, you’ll learn how to use Auto Outline in Excel to group rows and columns automatically for clean, collapsible reports. This feature is widely used in financial statements, MIS reports, and management dashboards. Auto Outline allows you to expand and collapse detailed data with plus and minus buttons, making large datasets easy to review and present. This tutorial walks through preparing the data correctly, applying Auto Outline, understanding outline levels, and manually grouping rows or columns when required. A large 50-row real-world dataset is included so you can practice immediately. If you want your Excel reports to look professional and management-ready, this is a must-know Excel feature. Subscribe to dptutorials for more Excel shortcuts, formulas, reporting tricks, and real-world productivity tips. Auto Outline in Excel | Group Rows & Columns Like a Pro #ExcelShorts #ExcelTips #ExcelReports