top of page
The Project Management Blog
DP
Tutorials
Learning Made Easy...
Home
Tutorials
Resources
YouTube Tools
Templates
Services
About Me
Blog
More
Use tab to navigate through the menu items.
EMPOWER YOURSELF
BECOME THE GO-TO SPREADSHEET EXPERT AT YOUR WORKPLACE
START NOW
HOW CAN I HELP YOU?
Tutorials
Tutorials
Tutorials
Tutorials
1/3
TUTORIALS
Templates
Templates
Templates
Templates
1/3
templates
Consulting
Consulting
Consulting
Consulting
1/3
CONSULTING
Mentoring
Mentoring
Mentoring
Mentoring
1/3
REPORTS
NEW ON THE BLOG
Project Scheduling Glossary
Activity: A task or work item that needs to be completed as part of a project. Actual Finish Date: The date on which an activity was...
10 Must to Know Excel Tricks to improve your productivity
10 Must to Know Excel Tricks to improve your productivity
Highlight activities using Filters and Spotlight feature in Primavera P6
Primavera P6 is a comprehensive project management software that is widely used in construction, engineering, and other industries. It...
Count Unique Numeric Values In A Range
In this tutorial, let us learn how to Count unique numeric values in a range using the combination of Frequency and Sum functions Let us...
LATEST TUTORIALS
Learn a new tip or trick every week. You’ll find some Primavera or Excel tips and articles here.
dptutorials
Play Video
Play Video
02:42
Visualize Delays Like a Pro - Master Float Paths in Primavera P6
🚀 Welcome to dptutorials! If you're ready to level up your project scheduling skills, you’re in the right place! 🚀 In this tutorial, I’ll guide you through how to master Float Paths in Primavera P6 so you can easily visualize delays, manage risks, and control your project schedule like a pro. 🔍 What are Float Paths in Primavera P6? Float Paths help you identify the sequence of activities that are most at risk of causing delays. Understanding them is essential for project control, delay analysis, and staying on track with deadlines. 💡 What You’ll Learn: ✅ How Float Paths work in Primavera P6 ✅ How to configure and interpret float paths ✅ Tips to visualize and analyze project delays ✅ Best practices for proactive project management 🎯 By the end of this video, you'll be able to use Float Paths to manage schedule slippage, prioritize activities, and ensure timely project delivery. 📌 Want More Tricks? Watch These! 📗 Oracle Primavera Tutorials: https://bit.ly/3fn9PFH 📗 Microsoft Excel Tutorials: https://bit.ly/2V5de5l 📗 Microsoft Project Tutorials: https://bit.ly/37guNl7 🔔 Don't Miss Future Tutorials – Subscribe Now! 🔔 ➡️ https://bit.ly/4c1OMot 👍 If you found this video helpful, give it a THUMBS UP & leave a comment below! 💬 Have any questions? Let me know in the comments! I respond to every question! 💡 About dptutorials At dptutorials, we bring you easy-to-follow tutorials on Microsoft Excel, Oracle Primavera P6, Microsoft Project, and other essential business tools. 🌐 Visit Our Website for More Resources: www.dptutorials.com 📩 Business Inquiries & Collaborations: 📧 Email us at: info@dptutorials.com 🔗 Connect With Us 🌎 Website: www.dptutorials.com 📢 YouTube: www.youtube.com/c/dptutorials 📷 Instagram: @dptutorials 📘 Facebook: dptutorials 🐦 Twitter: @dptutorials15 📢 Telegram: Join Our Community 🚀 Thank you for watching! Let's learn, grow, and succeed together! 🚀 📢 #PrimaveraP6 #FloatPaths #DelayAnalysis #ProjectScheduling #ConstructionManagement #CriticalPath #ProjectControl #dptutorials
Play Video
Play Video
02:40
How to Create Custom and Autofill Lists in Excel
🚀 Welcome to dptutorials! If you're looking to enhance your Excel skills, you’re in the right place! 🚀 In this tutorial, I’ll walk you through how to create and use custom and AutoFill lists in Excel—perfect for saving time and streamlining repetitive data entry tasks. 🔍 Why Use Custom & AutoFill Lists in Excel? Excel’s AutoFill feature is powerful—but did you know you can customize it to include your own lists? Whether it's a sequence of departments, employee names, or codes, custom lists make data entry effortless! 💡 What You’ll Learn: ✅ How to create your own custom lists in Excel ✅ How to use AutoFill with both default and custom lists ✅ Practical examples for business use ✅ Tips to save time and improve accuracy 🎯 By the end of this video, you’ll be able to create, manage, and fill custom lists automatically—a game changer for repetitive Excel tasks! 📌 Want More Tricks? Watch These! 📗 Oracle Primavera Tutorials: https://bit.ly/3fn9PFH 📗 Microsoft Excel Tutorials: https://bit.ly/2V5de5l 📗 Microsoft Project Tutorials: https://bit.ly/37guNl7 🔔 Don't Miss Future Tutorials – Subscribe Now! 🔔 ➡️ https://bit.ly/4c1OMot 👍 If you found this video helpful, give it a THUMBS UP & leave a comment below! 💬 Have any questions? Let me know in the comments! I respond to every question! 💡 About dptutorials At dptutorials, we bring you easy-to-follow tutorials on Microsoft Excel, Oracle Primavera P6, Microsoft Project, and other essential business tools. 🌐 Visit Our Website for More Resources: www.dptutorials.com 📩 Business Inquiries & Collaborations: 📧 Email us at: info@dptutorials.com 🔗 Connect With Us 🌎 Website: www.dptutorials.com 📢 YouTube: www.youtube.com/c/dptutorials 📷 Instagram: @dptutorials 📘 Facebook: dptutorials 🐦 Twitter: @dptutorials15 📢 Telegram: Join Our Community 🚀 Thank you for watching! Let's learn, grow, and succeed together! 🚀 📢 #ExcelTips #CustomLists #AutoFillExcel #ExcelShortcuts #ExcelProductivity #MicrosoftExcel #dptutorials
Play Video
Play Video
04:05
Do Earned Value Analysis In Primavera P6 Without Cost Modules
🚀 Welcome to dptutorials! If you're looking to enhance your Excel skills, you're in the right place! 🚀 In this tutorial, I'll walk you through how to perform Earned Value Analysis (EVA) in Primavera P6 without using the cost modules. Perfect for project managers who want to track project performance based purely on schedule progress! 🔍 Why Perform Earned Value Analysis Without Cost Modules? Sometimes, full cost integration isn't possible or necessary. Using just schedule data, you can still monitor project health, performance indices, and forecast potential delays effectively. 💡 What You'll Learn: ✅ How to configure Primavera P6 for EVA without costs ✅ Understanding Planned Value (PV), Earned Value (EV), and Actual Progress ✅ Calculate key performance indicators (CPI, SPI) using schedule data ✅ Practical tips to improve project tracking accuracy 🎯 By the end of this video, you'll be able to confidently perform Earned Value Analysis in P6 even without detailed cost-loaded schedules! 📌 Want More Tricks? Watch These! 📗 Oracle Primavera Tutorials: https://bit.ly/3fn9PFH 📗 Microsoft Excel Tutorials: https://bit.ly/2V5de5l 📗 Microsoft Project Tutorials: https://bit.ly/37guNl7 🔔 Don't Miss Future Tutorials – Subscribe Now! 🔔 ➡️ https://bit.ly/4c1OMot 👍 If you found this video helpful, give it a THUMBS UP & leave a comment below! 💬 Have any questions? Let me know in the comments! I respond to every question! 💡 About dptutorials At dptutorials, we bring you easy-to-follow tutorials on Microsoft Excel, Oracle Primavera P6, Microsoft Project, and other essential business tools. 🌐 Visit Our Website for More Resources: www.dptutorials.com 📩 Business Inquiries & Collaborations: 📧 Email us at: info@dptutorials.com 🔗 Connect With Us 🌎 Website: www.dptutorials.com 📢 YouTube: www.youtube.com/c/dptutorials 📷 Instagram: @dptutorials 📘 Facebook: dptutorials 🐦 Twitter: @dptutorials15 📢 Telegram: Join Our Community 🚀 Thank you for watching! Let's learn, grow, and succeed together! 🚀 📢 #earnedvalue #EVA #earnedvalueanalysis #primaverap6 #primaveratips
Play Video
Play Video
02:11
Excel Tricks Master the RIGHT Function Like a Pro
🚀 Welcome to dptutorials! If you're looking to enhance your Excel skills, you’re in the right place! 🚀 In this tutorial, I’ll teach you how to master the RIGHT function in Excel—an essential tool for extracting text from the end of any cell value. Whether you’re working with codes, names, or numbers, this trick can make your data work faster and smarter! 🔍 What is the RIGHT Function in Excel? The RIGHT function allows you to pull a specific number of characters from the end (right side) of a text string. It's perfect for slicing data efficiently without using complex formulas. 💡 Why Use the RIGHT Function? ✅ Simplifies text manipulation ✅ Extracts suffixes, codes, IDs, and more ✅ Combines well with other text functions ✅ Saves time on repetitive tasks 🎯 By the end of this video, you'll be able to use the RIGHT function like a pro to clean, transform, and analyze your data with ease! 📌 Want More Tricks? Watch These! 📗 Oracle Primavera Tutorials: https://bit.ly/3fn9PFH 📗 Microsoft Excel Tutorials: https://bit.ly/2V5de5l 📗 Microsoft Project Tutorials: https://bit.ly/37guNl7 🔔 Don't Miss Future Tutorials – Subscribe Now! 🔔 ➡️ https://bit.ly/4c1OMot 👍 If you found this video helpful, give it a THUMBS UP & leave a comment below! 💬 Have any questions? Let me know in the comments! I respond to every question! 💡 About dptutorials At dptutorials, we bring you easy-to-follow tutorials on Microsoft Excel, Oracle Primavera P6, Microsoft Project, and other essential business tools. 🌐 Visit Our Website for More Resources: www.dptutorials.com 📩 Business Inquiries & Collaborations: 📧 Email us at: info@dptutorials.com 🔗 Connect With Us 🌎 Website: www.dptutorials.com 📢 YouTube: www.youtube.com/c/dptutorials 📷 Instagram: @dptutorials 📘 Facebook: dptutorials 🐦 Twitter: @dptutorials15 📢 Telegram: Join Our Community 🚀 Thank you for watching! Let's learn, grow, and succeed together! 🚀 📢 #ExcelTips #rightFunction #ExcelTricks #DataCleaning #ProductivityHacks #MicrosoftExcel #ExcelForBusiness
Play Video
Play Video
03:06
How to Link and Unlink Activities in Primavera P6 – Explained with Example
🚀 Welcome to dptutorials! If you're looking to master project scheduling with Primavera P6, you’re in the right place! 🚀 In this tutorial, I’ll walk you through how to link and unlink activities in Oracle Primavera P6, which is a fundamental skill for creating and managing project schedules effectively. 🔍 Why Linking Activities is Important in Primavera P6: Establishing relationships between tasks ensures accurate sequencing, critical path calculation, and resource planning. This video shows you how to easily create and break those links using both graphical and tabular views. 💡 What You’ll Learn: ✅ How to link activities using Finish-to-Start (FS), Start-to-Start (SS), and other relationships ✅ Step-by-step method to unlink or remove relationships ✅ Tips to avoid common mistakes in scheduling ✅ Best practices for maintaining clean and logical project plans 🎯 By the end of this video, you’ll confidently manage activity relationships to build robust and efficient project schedules in P6. 🔔 Don't Miss Future Tutorials – Subscribe Now! 🔔 ➡️ https://bit.ly/4c1OMot 👍 If you found this video helpful, give it a THUMBS UP & leave a comment below! 💬 Have any questions? Let me know in the comments! I respond to every question! 💡 About dptutorials At dptutorials, we bring you easy-to-follow tutorials on Microsoft Excel, Oracle Primavera P6, Microsoft Project, and other essential business tools. 🌐 Visit Our Website for More Resources: www.dptutorials.com 📩 Business Inquiries & Collaborations: 📧 Email us at: info@dptutorials.com 🔗 Connect With Us 🌎 Website: www.dptutorials.com 📢 YouTube: www.youtube.com/c/dptutorials 📷 Instagram: @dptutorials 📘 Facebook: dptutorials 🐦 Twitter: @dptutorials15 📢 Telegram: Join Our Community 🚀 Thank you for watching! Let's learn, grow, and succeed together! 🚀 📢 #PrimaveraP6 #ProjectScheduling #P6Tutorial #ActivityLinking #ConstructionPlanning #ProjectManagementTools #dptutorials #PrimaveraTips
Play Video
Play Video
02:29
How to Copy Data from PDF to Excel Easily | Excel Tutorial for Beginners
🚀 Welcome to dptutorials! If you're looking to enhance your Excel skills, you’re in the right place! 🚀 In this tutorial, I’ll walk you through how to copy data from a PDF file into Excel—the clean, quick, and correct way! Say goodbye to formatting issues and hours of manual adjustments. 🔍 Why Copy PDF Data into Excel? Often, reports, invoices, and data sheets are shared in PDF format, but Excel is where the real data work happens. This video shows you how to transfer that data flawlessly, even if the format looks complex! 💡 What You’ll Learn: ✅ Methods to import PDF data into Excel ✅ How to handle formatting issues ✅ Tips to clean the data after pasting ✅ Best practices for consistent results 🎯 By the end of this video, you'll know exactly how to convert any PDF content into an editable Excel format, saving time and boosting productivity! 🔔 Don't Miss Future Tutorials – Subscribe Now! 🔔 ➡️ https://bit.ly/4c1OMot 💡 About dptutorials At dptutorials, we bring you easy-to-follow tutorials on Microsoft Excel, Oracle Primavera P6, Microsoft Project, and other essential business tools. 🌐 Visit Our Website for More Resources: https://www.dptutorials.com 📩 Business Inquiries & Collaborations: info@dptutorials.com 🚀 Thank you for watching! Let's learn, grow, and succeed together! 🚀 📢 #ExcelTips #PDFtoExcel #ExcelTricks #DataImport #ExcelForBeginners #MicrosoftExcel #productivityhacks
Play Video
Play Video
03:53
Rapidly Find Matches Between Two Lists in Excel
🚀 Welcome to dptutorials! If you're looking to enhance your Excel skills, you’re in the right place! 🚀 In this tutorial, I’ll walk you through how to rapidly find matching values between two lists in Excel using simple yet powerful techniques. No more manual comparisons—let Excel do the work for you! 🔍 How to Match Two Lists in Excel? This method helps you quickly compare two datasets and find duplicate or unique values with ease, saving time and improving accuracy. 💡 Why Use This Technique? ✅ Instantly Identify Matches – No more manual searching. ✅ Boost Productivity – Automate data comparison in seconds. ✅ Reduce Errors – Get accurate results without missing any data. ✅ Improve Data Analysis – Quickly spot duplicate or missing entries. 🎯 By the end of this video, you’ll be able to confidently compare two lists and find matches like a pro! 🔔 Don't Miss Future Tutorials – Subscribe Now! 🔔 ➡️ https://bit.ly/4c1OMot 💡 About dptutorials At dptutorials, we bring you easy-to-follow tutorials on Microsoft Excel, Oracle Primavera P6, Microsoft Project, and other essential business tools to enhance productivity. 🌐 Visit Our Website for More Resources: https://www.dptutorials.com 📩 Business Inquiries & Collaborations: info@dptutorials.com 🚀 Thank you for watching! Let's learn, grow, and succeed together! 🚀 📢 #ExcelTips #ExcelTricks #CompareLists #FindDuplicates #ExcelShortcuts #ProductivityHacks #MicrosoftExcel #ExcelForBusiness
Play Video
Play Video
03:10
Mastering Excel's DROP Function: Step-by-Step Guide
🚀 Welcome to dptutorials! If you're looking to enhance your Excel skills, you're in the right place! 🚀 In this tutorial, I'll walk you through how to master the DROP function in Excel to quickly remove unwanted rows and columns from your dataset. No more manual deletions-just seamless data cleaning with one function! 🔍 What is the DROP Function in Excel? The DROP function is a powerful tool in Excel that dynamically removes specific rows or columns from a dataset, making data management easier and more efficient. 💡 Why Use the DROP Function? ✅ Boost Productivity – No need for manual data cleaning. ✅ Automate Data Management – Works with real-time updates. ✅ Minimize Errors – Ensures structured and accurate data. ✅ Improve Data Analysis – Extract relevant information effortlessly. 🎯 By the end of this video, you'll be able to confidently use the DROP function to streamline your Excel workflow! 🔔 Don't Miss Future Tutorials – Subscribe Now! 🔔 ➡️ https://bit.ly/4c1OMot 💡 About dptutorials At dptutorials, we bring you easy-to-follow tutorials on Microsoft Excel, Oracle Primavera P6, Microsoft Project, and other essential business tools. 🌐 Visit Our Website for More Resources: https://www.dptutorials.com 📩 Business Inquiries & Collaborations: info@dptutorials.com 🚀 Thank you for watching! Let's learn, grow, and succeed together! 🚀 📢 #ExcelTips #DROPFunction #ExcelTricks #DataCleaning #ProductivityHacks #MicrosoftExcel #ExcelForBusiness
LOOKING FOR SOMETHING SPECIFIC?
Get my Tutorials & updates from me, directly to your Inbox:
Subscribe Now
bottom of page