top of page
Working on a Project

aboutus

Dptutorials is a Project Management resource site run by me, to help people gain the knowledge they need so they can create useful tools, solve problems and get more done.

โ€‹

My courses & tutorials are for those who use Project management tools along with some necessary tools like Excel at work and want to become better. For those that want to contribute by coming up with solutions to problems.

LEARN MORE

Join our mailing list

Never miss an update

Project Management Learning made easy with
"dptutorials"

Dptutorials is an advanced Project Controls Training platform. The training tutorials leads you through the entire project life cycle, from planning to execution. You'll develop a thorough understanding of how to plan and schedule easily. You can also enrol in the private training which will help you understand P6 professional's basic features and functionality so you can apply them to your organization's project management processes.

 

We believe that anyone can create good schedules and manage to drive a successful project. One just needs focus, guidance and dedicated learning.

โ€‹

if your into Project management, here is where you can gain and share as well your project management knowledge.

๏ปฟDifferent Students 
๏ปฟRequire Different
Approaches to Learning

Dptutorials is also featuring a YouTube channel with 220+ video tutorials including 75+ Primavera P6 easy learning tutorials that demonstrate Primavera’s different features in short, up to 10 minutes videos. One can get essential training tutorials and advanced techniques for working as part of project management. You'll also learn how to manage projects on time and within budget to ensure optimal outcomes from capital and resource investments.

โ€‹

dptutorials channel will help you in learning some of the Project Management tools like Primavera P6, Microsoft Project, Microsoft Office,through easy learning tutorials and thus making your work pleasurable and productive.

Visit www.youtube.com/c/dptutorials

Popular Posts
Create One Month Filter in Primavera P6
 

Lets learn How to Create a One Month filter in Primavera now in this tutorial now

โ€‹

Step 1: 

After Opening a Schedule in Primavera, click on the Filter Icon

Export Schedule from Primavera P6 to Excel
 

Lets see How to export the P6 Schedule in to Excel in an easy way.

โ€‹

Step 1:

First Open the schedule

New on the Blog
Testimonials 

    This was driving me nuts but your video helped me to get an auto-numbering cust. id column going in my spreadsheet. Thnx.

"

"

       thank you very much sir for explaining..i need cause i have project in msp of activities 4500 nos and wanted to import into primavera..now i got the solution..thanks๏ปฟ

"

"

     Nice video bro and thanks for the tip, may i ask you something more ? Thanks in advance and keep up the good work !๏ปฟ

"

"

— Contiyo

     Awesome tip, great way to organize and identify mass amount of people/students that are hard to identify after a long period of time๏ปฟ

"

"

Excel Tricks Master the RIGHT Function Like a Pro
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
How to Link and Unlink Activities in Primavera P6 โ€“ Explained with Example
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
How to Copy Data from PDF to Excel Easily | Excel Tutorial for Beginners
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
Rapidly Find Matches Between Two Lists in Excel
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
Mastering Excel's DROP Function: Step-by-Step Guide
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
โœ… How to Prevent Duplicate Entries in Excel | Data Validation Tips & Tricks
02:37

โœ… How to Prevent Duplicate Entries in Excel | Data Validation Tips & Tricks

In this tutorial, Iโ€™ll show you how to prevent duplicate entries in Excel using simple and effective methods. Say goodbye to repeated data errors and keep your spreadsheets clean and accurate! ๐Ÿ” Why Prevent Duplicate Entries in Excel? โœ… Avoid Data Errors โ€“ Keep your records accurate. โœ… Improve Efficiency โ€“ No more wasted time fixing duplicate data. โœ… Enhance Data Integrity โ€“ Maintain clean and structured spreadsheets. ๐Ÿ’ก What You'll Learn: โœ”๏ธ Data Validation โ€“ Set rules to prevent duplicates. โœ”๏ธ Conditional Formatting โ€“ Identify duplicate entries visually. โœ”๏ธ Advanced Excel Tips โ€“ Smart ways to keep data unique. ๐ŸŽฏ By the end of this video, you'll master these techniques and ensure a flawless Excel experience! ๐Ÿ”” Don't Miss Future Tutorials โ€“ Subscribe Now! ๐Ÿ”” โžก๏ธ https://bit.ly/4c1OMot ๐Ÿ’ก About dptutorials At dptutorials, we make learning Microsoft Excel, Oracle Primavera P6, and Microsoft Project simple and fun! ๐ŸŒ 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 #DataValidation #DuplicateEntries #ExcelForBusiness #MicrosoftExcel
How to Use the SWITCH Function Instead of Nested IF in Excel | Simplify Complex Formulas
02:24

How to Use the SWITCH Function Instead of Nested IF in Excel | Simplify Complex Formulas

๐Ÿš€ Welcome to dptutorials! Ready to Simplify Your Excel Formulas? ๐Ÿš€ Tired of using complicated Nested IF functions in Excel? In this tutorial, I'll show you how to use the SWITCH function to make your formulas cleaner, more efficient, and easier to manage! ๐Ÿ” What is the SWITCH Function in Excel? The SWITCH function is a powerful alternative to Nested IFs, allowing you to evaluate multiple conditions in a simpler and more readable way. ๐Ÿ’ก Why Use the SWITCH Function? โœ… Eliminate Long Nested IF Statements โ€“ Write cleaner formulas โœ… Improve Readability โ€“ Easier to understand and modify โœ… Boost Performance โ€“ Faster calculations compared to multiple IFs โœ… Enhance Efficiency โ€“ Ideal for decision-based logic ๐ŸŽฏ By the end of this video, youโ€™ll master the SWITCH function and simplify your Excel formulas 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. ๐ŸŒ 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 #SWITCHFunction #ExcelFormulas #ExcelTricks #ProductivityHacks #MicrosoftExcel #ExcelForBusiness
How to Create Dynamic Drop Down List Using Named Ranges in Excel
05:32

How to Create Dynamic Drop Down List Using Named Ranges in Excel

๐ŸŒŸ **Welcome to dptutorials! Subscribe for Exciting Content!** ๐ŸŒŸ In today's video, Iโ€™ll show you how to create a Dynamic Drop-Down List using Named Ranges in Excel. This is an essential trick for anyone working with data validation, forms, or interactive spreadsheets!, again Weโ€™ll create a dynamic drop-down list of products based on the Category selected. We have the data like this from A1 to B13. ๐Ÿ”” **Subscribe โžก๏ธ https://bit.ly/3sPIZvD and Hit the Bell Icon** ๐Ÿ”” to stay updated with our latest videos! Don't miss out on the fun, learning, and inspiration! ๐Ÿ‘ **Enjoyed the video? Give it a Thumbs Up!** ๐Ÿ‘ It helps us a lot! ๐Ÿ’ก **About dptutorials:** dptutorials is your go-to place for project management related tools like Oracle Primavera P6, Microsoft Project including necessary business skills/tools like Microsoft Office, through easy learning tutorials and thus making your work pleasurable and productive.Join our community for sharing valuable knowledge to the project management industry. ๐ŸŽฅ **Watch Next:** ๐Ÿ“—Oracle Primavera Tutorials : https://bit.ly/3fn9PFH ๐Ÿ“—Microsoft Excel Tutorials : https://bit.ly/2V5de5l ๐Ÿ“—Microsoft Project Tutorials : https://bit.ly/37guNl7 ๐Ÿ”— **Affiliate Links:** Support our channel by using our affiliate links for your online shopping: 1. Amazon [India] - https://amzn.to/3tqYzSO 2. Flipkart - http://fkrt.it/6SZEgVNNNN ๐Ÿ›๏ธ **Visit Website:** Check out our website www.dptutorials.com and show your support! ๐ŸŽ‰ **Best Equipment & Tools for YouTube Channel** : โžก๏ธ https://www.dptutorials.com/besttoolsforyoutubechannel ๐Ÿ’ฌ **Connect With Us:** Follow us on [Social Media Platform] for behind-the-scenes, updates, and more! ๐Ÿ’ŽYouTube: http://www.youtube.com/c/dptutorials ๐Ÿ’ŽInstagram: https://www.instagram.com/dptutorials/ ๐Ÿ’ŽG+: http://ift.tt/2kAOpa6 ๐Ÿ’ŽTwitter: https://twitter.com/dptutorials15 ๐Ÿ’ŽFacebook: http://ift.tt/2kfRnDi ๐Ÿ’ŽBlogSpot: http://ift.tt/2kB14dh ๐Ÿ’ŽWebsites: http://www.dptutorials.com & ๐Ÿ’Žhttp://www.askplanner.blogspot.com ๐Ÿ’ŽTelegram: https://t.me/dptutorials16 ๐Ÿ’Œ **Business Inquiries:** For collaborations and business inquiries, contact us at info@dptutorials.com Thank you for your support! Let's create, learn, and have fun together! ๐Ÿš€โœจ #dptutorials #dynamicdropdownlist #exceltraining #exceltricks #exceltips #excelfreetraining #excelfreelearning โšก๏ธTags: - excel formulas in english, excel in english, excel tutorial in english,ms excel in english,ms excel tutorial in english, learn excel in english,vlookup in excel in english, learn ms excel in english, excel training, excel tutorial, microsoft excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Excel dynamic drop-down list, create drop-down list in Excel, Excel named ranges drop-down, dependent drop-down list in Excel, Excel data validation drop-down, how to create a dynamic drop-down list, Excel drop-down list tutorial, advanced Excel drop-down list, Excel tips and tricks, Excel tutorial for beginners, Excel 2016 drop-down list, Excel 2019 drop-down list, Excel Office 365 drop-down, Excel drop-down list based on another cell, Excel dropdown using named ranges, DP Tutorials Excel ๐ŸŽNote: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
bottom of page