Fetch Files & Folders Path + VLOOKUP, IFERROR, and Conditional Formatting

Поделиться
HTML-код
  • Опубликовано: 26 дек 2024

Комментарии • 26

  • @AyseArif-l6h
    @AyseArif-l6h 9 дней назад

    The step-by-step guide on retrieving file paths is exceptionally clear and accessible for beginners-commendable work.

  • @ArgentinaPosada
    @ArgentinaPosada 9 дней назад

    This tutorial on retrieving file and folder paths in Excel represents a significant advancement in streamlining data management practices.

  • @LasandraWellman
    @LasandraWellman 9 дней назад

    The practical guidance on using conditional formatting will undoubtedly help me manage and organise data more effectively.

  • @MucellaEsra
    @MucellaEsra 9 дней назад

    The application of VLOOKUP and IFERROR is elegantly simple yet incredibly effective for managing missing data-a truly brilliant tip.

  • @AlperDilek-pr9vm
    @AlperDilek-pr9vm 9 дней назад

    This video succeeds in simplifying often confusing concepts, such as data importation and lookup functions. A fantastic resource!

  • @AykanEmine
    @AykanEmine 9 дней назад

    The guidance on customising the IFERROR function with text is an outstanding tip that will enhance clarity and organisation.

  • @Ayeshazaheer333
    @Ayeshazaheer333 18 дней назад +1

    Nice job 👏👏👏👏

  • @BARRYIbarra-p9d
    @BARRYIbarra-p9d 9 дней назад

    The explanation of the VLOOKUP function was succinct and highly comprehensible-this will certainly encourage more frequent use.

  • @FatmaSafak-f1o
    @FatmaSafak-f1o 9 дней назад

    The clear explanation of VLOOKUP’s syntax was invaluable-I will be able to immediately apply this knowledge.

  • @aliyousaf6289
    @aliyousaf6289 18 дней назад +1

    Nice work

  • @JongBowman
    @JongBowman 9 дней назад

    The tips for keeping Excel files clean and organised are incredibly helpful. I now feel more confident in using these tools.

  • @NeseHasan-n6y
    @NeseHasan-n6y 9 дней назад

    The method for importing data from folders into Excel is extremely convenient. I will undoubtedly be adopting this technique.

  • @MaryamShahbaz-b5u
    @MaryamShahbaz-b5u 18 дней назад +1

    Nice

  • @ZainAli-o8m1n
    @ZainAli-o8m1n 18 дней назад

    Excellent work !thanks for this it's make my work easy❤

  • @GARRETTYork-v3z
    @GARRETTYork-v3z 9 дней назад

    I value the demonstration of how to handle errors using the IFERROR function-such a helpful and practical inclusion.

  • @ShawnaHanson-c4r
    @ShawnaHanson-c4r 9 дней назад

    The colour-coding of missing data through conditional formatting is a thoughtful approach to maintaining organisation-brilliant idea.

  • @BRETCoy
    @BRETCoy 9 дней назад

    It is clear that this tutorial will save me hours of work on Excel tasks-it is precisely what I needed.

  • @RAYFORDSkidmore
    @RAYFORDSkidmore 9 дней назад

    I particularly appreciate how effortlessly data can be imported into Excel from folders. This functionality will undoubtedly save a great deal of time.

  • @AGUSTINMontiel-x6y
    @AGUSTINMontiel-x6y 9 дней назад

    This video is a remarkable resource for improving Excel skills, and I will certainly be sharing it with my colleagues.

  • @DianeEverson-p5q
    @DianeEverson-p5q 9 дней назад

    The process for setting up data import from a folder is remarkably easy to follow-thank you for explaining it so clearly.

  • @OLLIEOxendine
    @OLLIEOxendine 9 дней назад

    The utilisation of exact matches within the VLOOKUP function ensures remarkable precision-ideal for maintaining data integrity.

  • @TawanaShipley
    @TawanaShipley 9 дней назад

    I am most certainly subscribing for more Excel tutorials-this channel is a treasure trove of valuable tips and insights.

  • @MarielSantiago-m3y
    @MarielSantiago-m3y 9 дней назад

    I will definitely make greater use of the folder path feature after watching this tutorial. The demonstration was excellent.

  • @TERENCEMayo-u9r
    @TERENCEMayo-u9r 9 дней назад

    The use of conditional formatting to highlight “Not Available in the List” is a clever strategy for visually organising data.

  • @JULIUSSebastian-z7b
    @JULIUSSebastian-z7b 9 дней назад

    I had never considered the efficiency with which VLOOKUP could be employed for file and folder data retrieval-this is an invaluable tip.