Impressive Excel Function - =GPT3()
0:46
Amazing Excel Trick
0:45
2 жыл бұрын
Пікірлер
@GaneshPandit-x1i
@GaneshPandit-x1i 12 күн бұрын
It was so helpful, Thanks a ton..!
@saudpm40
@saudpm40 Ай бұрын
Should we assign qty and man-hours to every activity? If Management demands Resource loaded schedule should we provide this schedule?
@mohammednaseef3980
@mohammednaseef3980 Ай бұрын
good explanation.
@DineshKumar-qk5st
@DineshKumar-qk5st Ай бұрын
Paste link edges are not showing in the presentation, do you have any reason?
@blainecote8134
@blainecote8134 Ай бұрын
Thank you very easy to follow
@GK.finansal
@GK.finansal 2 ай бұрын
Hi, I lost the connection between powerpoint and excel. So, how can I reconnect them? In powerpoint screen, there is just always pop-ups that saying "there is no connection".
@extrainch4188
@extrainch4188 2 ай бұрын
It depend on the file location
@noorbassam3929
@noorbassam3929 3 ай бұрын
Useful . Thanks ❤
@extrainch4188
@extrainch4188 2 ай бұрын
Happy to help
@ahmetsoner9106
@ahmetsoner9106 3 ай бұрын
hi download link please
@sbyessix
@sbyessix 3 ай бұрын
For manhour average, why do you devided by 260.
@extrainch4188
@extrainch4188 2 ай бұрын
26 working days per month
@ayebida6620
@ayebida6620 6 күн бұрын
@@extrainch4188 This means you are using 10hrs calender
@badriabdellatif2165
@badriabdellatif2165 4 ай бұрын
Many thanks for your effort
@extrainch4188
@extrainch4188 2 ай бұрын
My pleasure
@Alex-dn2ln
@Alex-dn2ln 4 ай бұрын
Thank you for this tutorial! Maybe you can help me with the following question. Ok, we added quantities for each activity here, and then got the sum of all the quantities at the WBS line (node) which is not desired because we have different UoM. So, is it possible not to sum these values at WBS level??
@extrainch4188
@extrainch4188 2 ай бұрын
Yes, you can
@karimwaleedelmohandes1674
@karimwaleedelmohandes1674 4 ай бұрын
THAT WAS DOPE NOT USEFUL MAN !! THX
@extrainch4188
@extrainch4188 2 ай бұрын
Glad it helped
@dejifamilola3397
@dejifamilola3397 4 ай бұрын
Great Video!!!!
@extrainch4188
@extrainch4188 2 ай бұрын
Many thanks
@battlefieldtours
@battlefieldtours 4 ай бұрын
To create a live dashboard, how can you update PP with excel data whilst running the slide show in a loop?
@rondagallagher8479
@rondagallagher8479 5 ай бұрын
If you are linking a date formula from excel to PowerPoint is there a way to set it so the date updates daily. Using this as a "days since" counter and would like to have the PowerPoint display the new date and count daily without having to refresh manually. Thank you for the video
@Shahanshababa
@Shahanshababa 6 ай бұрын
good
@extrainch4188
@extrainch4188 6 ай бұрын
Thanks
@HassanAhmed-nc7kc
@HassanAhmed-nc7kc 6 ай бұрын
❤️👍🌹
@reginaldibenne6875
@reginaldibenne6875 6 ай бұрын
Nice video! How do you get the Quantities and Standard Manhour?
@extrainch4188
@extrainch4188 6 ай бұрын
Many thanks, you can get quantities from BOQ and manhours by devided on the productivities
@aaqilrm564
@aaqilrm564 6 ай бұрын
Thank u
@extrainch4188
@extrainch4188 6 ай бұрын
Welcome
@whereisdamn22
@whereisdamn22 7 ай бұрын
thanks man
@extrainch4188
@extrainch4188 6 ай бұрын
Happy to help
@muhammadanjum4998
@muhammadanjum4998 8 ай бұрын
How did you incorporate Qty and Std.Mh in user defined fields? Manually or Automatically?
@extrainch4188
@extrainch4188 6 ай бұрын
You can import by excel
@abdulrauf-qj6ds
@abdulrauf-qj6ds 8 ай бұрын
EXCELLENT
@extrainch4188
@extrainch4188 6 ай бұрын
Many thanks!
@ivanrojas9194
@ivanrojas9194 8 ай бұрын
Clear, concise, easy and practical. Thank you Useful Information
@extrainch4188
@extrainch4188 8 ай бұрын
Glad it was helpful!
@ElizabethPerez-cx5nj
@ElizabethPerez-cx5nj 9 ай бұрын
How did you insert all of those check boxes at once? Did you speed up the video or can something else be done? Because when I tried to follow your video, the path developer > insert > checkboxes does not look like that as it includes a text box also and have to do 1 at a time.
@extrainch4188
@extrainch4188 6 ай бұрын
It depends on the revision your usuling
@CatMedia-iy1gk
@CatMedia-iy1gk 9 ай бұрын
So if we want to change Activity for each WBS, means that each WBS has a different Activity ID, how we can do that?. Thanks!
@extrainch4188
@extrainch4188 6 ай бұрын
Many ways such change it in excel and import or using user feilds
@CatMedia-iy1gk
@CatMedia-iy1gk 9 ай бұрын
When import activity from excel to Primavera, all the start date are not the same with start date in execl. How to fix it? Thanks!
@extrainch4188
@extrainch4188 6 ай бұрын
First you need to link to each other, if there is no links it will be the same starting dates
@mouh48
@mouh48 10 ай бұрын
GREAT PRESENTATION SIR , just a question is it possible to do in the same way for the planned mahours % , thanks in advance for your precious reply
@extrainch4188
@extrainch4188 6 ай бұрын
Yes, definitely
@MustafaAhmed-uy6qk
@MustafaAhmed-uy6qk 10 ай бұрын
When i changes rows it doesn't reflect changes to powerpoint, how to do it.
@extrainch4188
@extrainch4188 6 ай бұрын
Actually it should change
@895games2
@895games2 10 ай бұрын
Process did not complete successfully. See log file for details. what to do.., tried multiple times. can you help..?!
@extrainch4188
@extrainch4188 6 ай бұрын
Send me the files
@reginaldibenne6875
@reginaldibenne6875 11 ай бұрын
Nice one, sir. Pls, is Project report different from Cash flow generation?
@extrainch4188
@extrainch4188 6 ай бұрын
Yes, it is
@ShahTV88
@ShahTV88 11 ай бұрын
I am facing an import issue after calculation. The sumif formula was not working in the Excel sheet, so I removed the error in the Excel cell and converted it to a number. After the formula worked and when I imported the file it was successful.
@extrainch4188
@extrainch4188 11 ай бұрын
Well done! All the luck Shah
@AbdulKareemAbdulRahman
@AbdulKareemAbdulRahman 11 ай бұрын
does this work with pivot tables?
@extrainch4188
@extrainch4188 11 ай бұрын
Sure, it will work with pivot table
@summitengineeringconsultan1700
@summitengineeringconsultan1700 11 ай бұрын
assalamu alaikum...usefull videos good explanation..how can i add that three columns(qty,std.mh,mh)
@extrainch4188
@extrainch4188 11 ай бұрын
Welcome, you can added it from the columns options
@Loganstjohn8
@Loganstjohn8 Жыл бұрын
Thank you so much, this worked like a charm!
@extrainch4188
@extrainch4188 Жыл бұрын
I'm glad you like it Logan ❣️
@davidpius6676
@davidpius6676 Жыл бұрын
Nice!
@extrainch4188
@extrainch4188 Жыл бұрын
Thank you! Cheers!
@bubble1231
@bubble1231 Жыл бұрын
Need more Power Bi videos and cover DAx
@extrainch4188
@extrainch4188 Жыл бұрын
Sure, we are working on it
@bubble1231
@bubble1231 Жыл бұрын
Explained very nicely and quickly
@extrainch4188
@extrainch4188 Жыл бұрын
Thanks alot ❤️
@jayaraza8469
@jayaraza8469 Жыл бұрын
Hi, Thanks for sharing this. Is there a way to import the exact dates from excel to P6?
@extrainch4188
@extrainch4188 Жыл бұрын
Sure, you need to arrange those dates along with each activity ID number
@LaiDerek-yg9rg
@LaiDerek-yg9rg Жыл бұрын
I tried your method. It works at the beginning, however, after I save and leave the file. Open it again, all excel links are not working. How can I deal with it? Thanks
@extrainch4188
@extrainch4188 Жыл бұрын
It may happen if you changed the files location
@farooqbashir4111
@farooqbashir4111 Жыл бұрын
Very Useful, Thanks
@extrainch4188
@extrainch4188 Жыл бұрын
Thank you Farooq
@TJ-pn4sp
@TJ-pn4sp Жыл бұрын
🌹 "promo sm"
@sathishvelayudham9289
@sathishvelayudham9289 Жыл бұрын
Good explanation we are expecting more videos to update our knowledge
@extrainch4188
@extrainch4188 Жыл бұрын
Will upload soon ❣️
@shaivyasingh5417
@shaivyasingh5417 Жыл бұрын
Hello. Can the source of the Excel be changed in the powerpoint that's linked to it?
@extrainch4188
@extrainch4188 Жыл бұрын
Then you have to link it with the new source
@leelopez160
@leelopez160 Жыл бұрын
😁What an amazing introduction to VBA.Thank you for sharing your knowledge with us all.👍👍👍👍
@extrainch4188
@extrainch4188 Жыл бұрын
Thanks Lee, Glad you like it ❣️
@ganeshfluor
@ganeshfluor Жыл бұрын
Perfect video, 100% practical
@extrainch4188
@extrainch4188 Жыл бұрын
Thanks gp, Glad you found it useful ❣️
@balakrishnadoddabele528
@balakrishnadoddabele528 Жыл бұрын
Hi ! This small video has found solutions to many big issues... !! in a single shot.P6-Excel-P6-V-Look Up !! Loading through & reconciling data on Excel is super fast unlike the P6. Same logic for material/labor loading as the cost. 👍👍
@extrainch4188
@extrainch4188 Жыл бұрын
Glad it helped!
@Fatimalnx
@Fatimalnx Жыл бұрын
Short and helpful. I appreciate it.
@extrainch4188
@extrainch4188 Жыл бұрын
Glad it was helpful!
@RamintaSøsted
@RamintaSøsted Жыл бұрын
Short and clear. Advantages and disadvantages. Loved it, thank you.
@extrainch4188
@extrainch4188 Жыл бұрын
Glad it was helpful!
@raphaelpetersamat9897
@raphaelpetersamat9897 Жыл бұрын
OMG thanks for this great tutorial/ tips & tricks
@extrainch4188
@extrainch4188 Жыл бұрын
You're so welcome!
@ranafamily863
@ranafamily863 Жыл бұрын
this video deserves 100b likes
@extrainch4188
@extrainch4188 Жыл бұрын
Thank you ❣️