Extra Inch
Extra Inch
  • 99
  • 322 090
How to create a dynamic filter with advance filter & macro?
At this video you will learn how to create a dynamic filter with advance filter & macro.
Переглядів: 153

Відео

Impressive Excel Function - =GPT3()
Переглядів 8322 роки тому
Impressive Excel function, It can figure out and match exsiting data patterns and retreive any information available on the web such as state populations or peoples twitter usernames
Fill Down Command in Primavera P6 #construction management
Переглядів 5922 роки тому
I will share with you today one of my knowledge areas on Oracle's Primavera solutions which integrates project and portfolio planning and delivery teams for planning, resourcing, risk mitigation, scheduling, and program management. Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource managem...
Amazing Excel Trick
Переглядів 892 роки тому
This is an Excel trick for importing data from online pages, hope you enjoy it and find it useful @extrainch4188
Suspense Activities in Primavera P6 #planning engineer
Переглядів 8142 роки тому
I will share with you today one of my knowledge areas on Oracle's Primavera solutions which integrates project and portfolio planning and delivery teams for planning, resourcing, risk mitigation, scheduling, and program management. Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource managem...
Automatic Activity ID settings in Primavera #project control
Переглядів 6462 роки тому
I will share with you today one of my knowledge areas on Oracle's Primavera solutions which integrates project and portfolio planning and delivery teams for planning, resourcing, risk mitigation, scheduling, and program management. Primavera is an enterprise project portfolio management software. It includes project management, scheduling, risk analysis, opportunity management, resource managem...
Resource Levelling in Primavera P6 #project management
Переглядів 7712 роки тому
Resource Levelling in Primavera P6 #project management
Earned Value Management in Primavera P6 #Project Management
Переглядів 1,3 тис.2 роки тому
Earned Value Management in Primavera P6 #Project Management
Modify Activities ID in Primavera P6 #oracle primavera
Переглядів 6062 роки тому
Modify Activities ID in Primavera P6 #oracle primavera
Create & Modify Cash Flow in Primavera #Project Management
Переглядів 1,9 тис.2 роки тому
Create & Modify Cash Flow in Primavera #Project Management
How to use Project Reflections in Primavera P6 #p6 tutorial
Переглядів 1,3 тис.2 роки тому
How to use Project Reflections in Primavera P6 #p6 tutorial
Prepare Scurve, no Resource Loading in Primavera P6 #SCURVE
Переглядів 1,2 тис.2 роки тому
Prepare Scurve, no Resource Loading in Primavera P6 #SCURVE
Prepare Lookahead Schedule #Primavera P6 #Planning Engineer
Переглядів 1,2 тис.2 роки тому
Prepare Lookahead Schedule #Primavera P6 #Planning Engineer
Prepare and Save Layouts in Primavera P6 #Planning Engineer
Переглядів 5802 роки тому
Prepare and Save Layouts in Primavera P6 #Planning Engineer
How to use Global Change in Primavera P6 #Planning Engineer
Переглядів 1,1 тис.2 роки тому
How to use Global Change in Primavera P6 #Planning Engineer
How to use Activity Codes in Primavera P6 #Planning Engineer
Переглядів 1 тис.2 роки тому
How to use Activity Codes in Primavera P6 #Planning Engineer
Protect your Schedule in Primavera P6 #Planning Engineer
Переглядів 4012 роки тому
Protect your Schedule in Primavera P6 #Planning Engineer
Link my Schedule to External Schedules #Primavera P6
Переглядів 4932 роки тому
Link my Schedule to External Schedules #Primavera P6
Create lags Report in Primavera P6 #project management
Переглядів 4192 роки тому
Create lags Report in Primavera P6 #project management
Fix Open Relationships in Primavera P6 #Planning Engineer
Переглядів 5362 роки тому
Fix Open Relationships in Primavera P6 #Planning Engineer
How to Create a Professional Organization Chart in PowerPoint
Переглядів 2662 роки тому
How to Create a Professional Organization Chart in PowerPoint
How to Export & Import Excel file #Import Excel to Primavera
Переглядів 1 тис.2 роки тому
How to Export & Import Excel file #Import Excel to Primavera
How to Create Animated YouTube Videos - Beginners Tutorial
Переглядів 632 роки тому
How to Create Animated UA-cam Videos - Beginners Tutorial
How to Assign documents in Primavera P6 #Planning Engineer
Переглядів 7102 роки тому
How to Assign documents in Primavera P6 #Planning Engineer
How to Trace Logic in Primavera P6 #planning engineer
Переглядів 1,3 тис.2 роки тому
How to Trace Logic in Primavera P6 #planning engineer
Define & Mark Critical Activities in Primavera P6 #Planning
Переглядів 7392 роки тому
Define & Mark Critical Activities in Primavera P6 #Planning
How to Import Activities from Excel to Primavera P6
Переглядів 5 тис.2 роки тому
How to Import Activities from Excel to Primavera P6
How to create a new report in Primavera P6 #Create Reports
Переглядів 3,9 тис.2 роки тому
How to create a new report in Primavera P6 #Create Reports
Activity duration types in Primavera P6 #Planning Engineer
Переглядів 2,7 тис.2 роки тому
Activity duration types in Primavera P6 #Planning Engineer
Program copy options in Primavera P6 #primavera p6 training
Переглядів 5412 роки тому
Program copy options in Primavera P6 #primavera p6 training

КОМЕНТАРІ

  • @GK.finansal
    @GK.finansal 18 днів тому

    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".

  • @noorbassam3929
    @noorbassam3929 Місяць тому

    Useful . Thanks ❤

  • @ahmetsoner9106
    @ahmetsoner9106 Місяць тому

    hi download link please

  • @sbyessix
    @sbyessix Місяць тому

    For manhour average, why do you devided by 260.

  • @badriabdellatif2165
    @badriabdellatif2165 2 місяці тому

    Many thanks for your effort

  • @Alex-dn2ln
    @Alex-dn2ln 2 місяці тому

    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??

  • @karimwaleedelmohandes1674
    @karimwaleedelmohandes1674 2 місяці тому

    THAT WAS DOPE NOT USEFUL MAN !! THX

  • @dejifamilola3397
    @dejifamilola3397 2 місяці тому

    Great Video!!!!

  • @battlefieldtours
    @battlefieldtours 2 місяці тому

    To create a live dashboard, how can you update PP with excel data whilst running the slide show in a loop?

  • @rondagallagher8479
    @rondagallagher8479 3 місяці тому

    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 4 місяці тому

    good

  • @HassanAhmed-nc7kc
    @HassanAhmed-nc7kc 4 місяці тому

    ❤️👍🌹

  • @reginaldibenne6875
    @reginaldibenne6875 4 місяці тому

    Nice video! How do you get the Quantities and Standard Manhour?

    • @extrainch4188
      @extrainch4188 4 місяці тому

      Many thanks, you can get quantities from BOQ and manhours by devided on the productivities

  • @aaqilrm564
    @aaqilrm564 4 місяці тому

    Thank u

  • @whereisdamn22
    @whereisdamn22 5 місяців тому

    thanks man

  • @muhammadanjum4998
    @muhammadanjum4998 6 місяців тому

    How did you incorporate Qty and Std.Mh in user defined fields? Manually or Automatically?

  • @abdulrauf-qj6ds
    @abdulrauf-qj6ds 6 місяців тому

    EXCELLENT

  • @ivanrojas9194
    @ivanrojas9194 6 місяців тому

    Clear, concise, easy and practical. Thank you Useful Information

  • @ElizabethPerez-cx5nj
    @ElizabethPerez-cx5nj 7 місяців тому

    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 4 місяці тому

      It depends on the revision your usuling

  • @CatMedia-iy1gk
    @CatMedia-iy1gk 7 місяців тому

    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 4 місяці тому

      Many ways such change it in excel and import or using user feilds

  • @CatMedia-iy1gk
    @CatMedia-iy1gk 7 місяців тому

    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 4 місяці тому

      First you need to link to each other, if there is no links it will be the same starting dates

  • @mouh48
    @mouh48 8 місяців тому

    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

  • @MustafaAhmed-uy6qk
    @MustafaAhmed-uy6qk 8 місяців тому

    When i changes rows it doesn't reflect changes to powerpoint, how to do it.

  • @895games2
    @895games2 9 місяців тому

    Process did not complete successfully. See log file for details. what to do.., tried multiple times. can you help..?!

  • @reginaldibenne6875
    @reginaldibenne6875 9 місяців тому

    Nice one, sir. Pls, is Project report different from Cash flow generation?

  • @ShahTV88
    @ShahTV88 9 місяців тому

    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.

  • @AbdulKareemAbdulRahman
    @AbdulKareemAbdulRahman 9 місяців тому

    does this work with pivot tables?

    • @extrainch4188
      @extrainch4188 9 місяців тому

      Sure, it will work with pivot table

  • @summitengineeringconsultan1700
    @summitengineeringconsultan1700 9 місяців тому

    assalamu alaikum...usefull videos good explanation..how can i add that three columns(qty,std.mh,mh)

    • @extrainch4188
      @extrainch4188 9 місяців тому

      Welcome, you can added it from the columns options

  • @Loganstjohn8
    @Loganstjohn8 Рік тому

    Thank you so much, this worked like a charm!

  • @davidpius6676
    @davidpius6676 Рік тому

    Nice!

  • @bubble1231
    @bubble1231 Рік тому

    Need more Power Bi videos and cover DAx

  • @bubble1231
    @bubble1231 Рік тому

    Explained very nicely and quickly

  • @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

  • @TJ-pn4sp
    @TJ-pn4sp Рік тому

    🌹 "promo sm"

  • @sathishvelayudham9289
    @sathishvelayudham9289 Рік тому

    Good explanation we are expecting more videos to update our knowledge

  • @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.👍👍👍👍

  • @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. 👍👍

  • @Fatimalnx
    @Fatimalnx Рік тому

    Short and helpful. I appreciate it.

  • @RamintaSøsted
    @RamintaSøsted Рік тому

    Short and clear. Advantages and disadvantages. Loved it, thank you.

  • @raphaelpetersamat9897
    @raphaelpetersamat9897 Рік тому

    OMG thanks for this great tutorial/ tips & tricks

  • @ranafamily863
    @ranafamily863 Рік тому

    this video deserves 100b likes

  • @farandawaytom5511
    @farandawaytom5511 Рік тому

    Hi, as the Unit of Measurement for different types of activities are different, the quantity histogram and s-curve is not reasonable. Is there any good method to show the quantity of different types of activities and generate graphs for different types of activities separately?

    • @extrainch4188
      @extrainch4188 Рік тому

      Sure it can be done, one of the methods is to assign an activity coding to activities and filter those reasources using activity coding.

  • @Planning.Engineer
    @Planning.Engineer Рік тому

    i think the BOQ was in the other content creator who also teach Primavera P6. Can we have a copy of the BOQ sir?

    • @extrainch4188
      @extrainch4188 Рік тому

      I'm sorry I can't. it includes private prices

  • @mohammedmuzamil5976
    @mohammedmuzamil5976 Рік тому

    calculate 260 average, 12:02 ???? Explain please

    • @extrainch4188
      @extrainch4188 Рік тому

      Its 26 working day per month mutiply by 10 working hours per day

    • @dejifamilola3397
      @dejifamilola3397 2 місяці тому

      @@extrainch4188 He never mentioned daily working hour and he used 5 work week calendar. Hence, the best answer was from @pohhio who says 52 weeks (1 year) x 5 days work week = 260

  • @syedobaid8598
    @syedobaid8598 Рік тому

    how you ll import the activities to the desired WBS using excel

    • @extrainch4188
      @extrainch4188 Рік тому

      If you mean import from excel, then you have to add a column for the WBS level you want that activity to be imported to

  • @farooqbashir4111
    @farooqbashir4111 Рік тому

    Sir, Very Good Explaining, Useful and Guidance, Thanks