Skip to main content

Posts

Showing posts from May, 2018

Excel Trick#46 : How to Sum Across Multiple Sheets in Microsoft Excel || Excel Tips || dptutorials

In this tutorial, let us learn how to add cells from different sheets in Microsoft Excel, in an easier way. i.e Data consolidation. For example, Consider a scenario where you want a formula that will give you the sum, totaling from the same cell address in multiple sheets in a workbook. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR ************************************************************** You Can Conn

2.1 : Primavera Learning - Getting Started | Navigation toolbars || Primavera Tutorial ||dptutorials

Hello Friends, Let us get to know the general idea of primavera software After the installation, let us open the tool On the Login Screen,by default the login credentials are admin for both the login name and password. On the database, by default it is ORAPMDB. If you have any other installed serves in your organization, you can select that. if not, let the default be there and Click Ok to Login. This is the startup window containing the Enterprise data and project data. Enterprise data comprises of Projects, Resources, Reports, Tracking Project Data comprises of WBS, Activities, WPs&Docs, which gets enabled only when a project is opened. First let us see how to set the startup window. Go to Edit tab, click on User Preferences, go to application section and in the Startup window, from the drop down menu, select the particular section that you wish to see as a startup window. You can change the password by going to the password section and then set the new password

Excel Tricks : How To Compare Two Excel Sheets With Inquire Addin || Excel Tips || dptutorials

If your are using the Excel 2013, then you can have access to the mentioned Inquire Feature that allows you to compare two workbooks to identify the differences and find the unique values . This is very easy to use and very powerful tool which can save lot of time. For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR ************************************************************** You Can Connect With Me at G+ :  h

How To Remove Actual Progress From Primavera P6 Schedule || Primavera tutoring || dptutorials

For Personalized detail learning, write to dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR ************************************************************** You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6 Twitter :  https://twitter.com/dptutorials15 Facebook :  http://ift.tt/2kfRnDi Blogspot :  http://ift.tt/2kB14dh