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

"

"

How to Create Line Chart In Excel
01:51

How to Create Line Chart In Excel

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In this video, let us learn about how to create a Line Chart in Excel. Line Charts are excellent for visualizing trends over time and comparing data across different categories. First, let's set up our data for this demonstration. We have the % progress figures by month wise as the data to create a line chart to see the trend movement. Let’s create now. 🔔 **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 #linechart #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 Create a Pareto Chart in Excel
01:57

How to Create a Pareto Chart in Excel

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In today's video, we'll be learning how to create a Pareto Chart in Excel. Pareto Charts are a combination of bar and line graphs, which are used to identify the most significant factors in a dataset. They follow the Pareto principle, which states that 80% of the effects come from 20% of the causes. So, let's dive in and learn how to create a Pareto Chart in Excel! We have the complaints details of 16 features of a product and lets create a pareto chart now Steps: • Select the range from B7:C23 • Go to insert, in the Statistics chart, select the “Pareto chart” • Now, you will observe that these products are arranged in the descending order of their respective complaints • And this line chart has been automatically generated (if you are using the previous versions of excel, you have to manually create this kind of graph). This line chart is on the secondary axis plotted with the % portions of each product to the total. • So, using this chart you can prioritise on the top critical features so that you can solve most of your complaints or issues • Now adjust the formatting of this chart to make it better. 🔔 **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 #paretochart #paretoinexcel ⚡️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 Create a Histogram Chart in Excel
02:32

How to Create a Histogram Chart in Excel

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In this video, let us learn about the Histogram chart Purpose: A histogram is a graphical representation that organizes a group of data points into user-specified ranges Let’s understand this with an example We have the salary details of 16 employees and if we want to see the distribution by some slab wise, we have to create the histogram. Let’s create now. 🔔 **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 #histogram #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 Create a Column Chart in Excel
01:23

How to Create a Column Chart in Excel

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In this video, let us learn about the Column chart Purpose: : To compare values between different groups or to track changes over time We have this sample data range which we will use for creating the column chart now. 🔔 **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 #primavera #primaverafree #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 Create a Bar Chart in Excel
01:30

How to Create a Bar Chart in Excel

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In this video, let us learn about the Bar chart Purpose: To compare values between different groups or to track changes over time Here in this example, we have considered productivities of 2 employees by month-wise. So if we want to do some analysis with bar chart, we have to either draw trend or compare both employees. Let’s start building the simple bar chart first. 🔔 **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 #excelcharts #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 Create an Area Chart in Excel
02:23

How to Create an Area Chart in Excel

🌟 **Welcome to dptutorials! Subscribe for Exciting Content!** 🌟 In this video, let us learn about the Area chart in Excel. Purpose: Area charts are primarily used when the magnitude of the trend is to be communicated Now in this example data, we have the count of Male and Female employees against each month. And let us draw the trend if you want to compare with the proportion of each category. 🔔 **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 #excelcharts #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 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!
bottom of page