top of page

EMPOWER YOURSELF

BECOME THE GO-TO SPREADSHEET EXPERT AT YOUR WORKPLACE

Top-5-Teaching-Strategies-scaled-removebg-preview.png
  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • LinkedIn
  • Instagram

HOW CAN I HELP YOU?

NEW ON THE BLOG

LATEST TUTORIALS

Learn a new tip or trick every week. You’ll find some Primavera or Excel tips and articles here.

How to Highlight the Active Cell and Row in Excel with a Click
02:14

How to Highlight the Active Cell and Row in Excel with a Click

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In today's video, we'll explore a visually effective technique: how to highlight the active cell and row in Excel with a click. Before we start, let's consider this worksheet for this demonstration. To highlight the active cell and row, we'll use a simple VBA 👉Link to VBA code: https://bit.ly/3yv5M6J 🔔 **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 #excelvbaguide #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,microsoft excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in hindi, excel formulas and functions in hindi, excel tricks, excel in hindi, excel shortcut keys, excel vlookup, excel formulas in hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, excel sum formula, sum formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft 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!
How to Copy and Paste Multiple Cells into a Single Cell as a Stacked Column in Excel
02:57

How to Copy and Paste Multiple Cells into a Single Cell as a Stacked Column in Excel

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In today's video, we'll be tackling a unique and practical Excel tip: how to copy and paste multiple cells into a single cell as a stacked column. This is the column with the data that we want to combine into a single cell. 👉Excel File: https://bit.ly/44N3RGK 👉VBA code: https://bit.ly/4bnfAhy 🔔 **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 #excelcopypaste #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,microsoft excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in hindi, excel formulas and functions in hindi, excel tricks, excel in hindi, excel shortcut keys, excel vlookup, excel formulas in hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, excel sum formula, sum formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft 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!
How to Automatically Generate Serial Numbers Based on Data in Excel
03:02

How to Automatically Generate Serial Numbers Based on Data in Excel

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In today's video, we'll be covering a practical and time-saving feature in Excel: automatically generating serial numbers based on data entered in your spreadsheet. 🔔 **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 #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,microsoft excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in hindi, excel formulas and functions in hindi, excel tricks, excel in hindi, excel shortcut keys, excel vlookup, excel formulas in hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, excel sum formula, sum formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft 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!
How to Use the FILTER Function With Multiple Criteria
04:06

How to Use the FILTER Function With Multiple Criteria

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In today's video, we'll be exploring a powerful feature in Excel: using the FILTER function With Multiple Criteria. Consider this example data with the headers. Now, let's use the FILTER function to filter our data based on specific criteria: 🔔 **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 #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,microsoft excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in hindi, excel formulas and functions in hindi, excel tricks, excel in hindi, excel shortcut keys, excel vlookup, excel formulas in hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, excel sum formula, sum formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft 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!
Easy Excel Hack: How to Create a Birthday Reminder in Excel
03:53

Easy Excel Hack: How to Create a Birthday Reminder in Excel

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 Learn a simple Excel hack to never forget a birthday again! In this tutorial, you will discover how to easily create a birthday reminder table using Excel. Say goodbye to missing important dates with this easy-to-follow guide. Stay organized and on top of all your loved ones' special days with this Excel birthday reminder trick! 🔔 **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 #excelbirthday #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,microsoft excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in hindi, excel formulas and functions in hindi, excel tricks, excel in hindi, excel shortcut keys, excel vlookup, excel formulas in hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, excel sum formula, sum formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft 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!