DPTutorials

Welcome to dptutorials. In this video, you’ll learn how to count unique values in Excel based on a specific condition using modern Excel formulas. This is a very common requirement in HR analytics, audits, sales analysis, and dashboard reporting. The formula dynamically updates and avoids counting duplicates. A real-world dataset with 50 rows is included so you can practice immediately. Count Unique Values Based on Criteria in Excel #ExcelShorts #ExcelTips #ExcelAnalytics

Welcome to dptutorials. In this video, you’ll learn how to extract a unique list across multiple columns in Excel using a single dynamic formula. This technique is extremely useful when data is scattered across columns and you need one clean master list. The formula updates automatically and works perfectly for dashboards, audits, HR data, and reporting. A large real-world dataset is included so you can practice instantly. Unique List Across Multiple Columns in Excel | Smart Formula #ExcelShorts #ExcelTips #ExcelFormulas

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