Andrew Ligon Fant
Andrew Ligon Fant
  • 7
  • 461 817
How to Filter Data in Microsoft Excel
Once you've formatted your data as a table, you can sort and filter that data to find what you're looking for. Here's how to do that.
Переглядів: 140

Відео

How to Create and Format Tables in Microsoft Excel
Переглядів 530Рік тому
Get more out of your data set by formatting it as a table. Tables allow you to sort and filter data, making it more useful.
How to Multiply Numbers in Microsoft Excel
Переглядів 289Рік тому
Here's how to multiply two or more numbers in Excel.
How to Subtract Numbers in Microsoft Excel
Переглядів 1,2 тис.Рік тому
Just what the title says how to subtract two or more numbers in MS Excel.
How to Add Numbers in Microsoft Excel
Переглядів 59Рік тому
Unless you like doing math (I don't), this is an MS Excel skill you need to have. Enjoy!
(2/2) Automating Word Documents from Excel - No VBA - Building Forms and Using Formulas
Переглядів 67 тис.5 років тому
How to fill word documents from Excel. This could be useful for mass mailings or for forms that you need to fill out repeatedly - and you won't have to use VBA. This video covers building a data entry form and using a couple basic formulas.
(1/2) Automating Word Documents from Excel - No VBA
Переглядів 393 тис.5 років тому
How to fill word documents from Excel. This could be useful for mass mailings or for forms that you need to fill out repeatedly - and you won't have to use VBA.

КОМЕНТАРІ

  • @SureshHarasgama-v2e
    @SureshHarasgama-v2e Місяць тому

    Thanks

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

    thank you very much

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

    Thank you, you make it look so simple.

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

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

    Thank you so much. This just made my life so much easier

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

    Thank you. I need to fill 50 word documents, so the excel table has 50 lines, how to this just clicking a button, and all the 50 word documents fill automatically each one using one of these lines from the table?

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

    How do you point to a relative path, so if I copy and paste template folders for specific clients (..\client1, \client2), the word will always pull from the right file, and not the absolute path?

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

      So that others won't have to point to the folder every time, i.e., the template folder always points to "contacts", which I suppose is in the the same folder as the letter, or in a subfolder. The point is to make it more user friendly.

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

    Hey Bro I don't know would you read my comment or not. But I really wanna say thanks to you. It helped me so much. I appreciate it bro. Thanks so much. I subscribed your channel and press like button.

  • @Allen.N.Humphries
    @Allen.N.Humphries 4 місяці тому

    I thought I finally had what I needed, but when I clicked preview results, the date Excel displays as Tuesday, December 31, 2024 displays in Word as 2024-12-31. I need the display to be the same format. It appears that all that links is the serial number of the date.

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

    Helped a lot thanks

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

    Finally real automation between Excel and Word. Cell by Cell. Thank you !

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

    Most useful

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

    great presentation exactly what I needed

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

    Thank you so much! I've been searching for this but didn't know how to name it, and this is perfect

  • @time4sanity
    @time4sanity 7 місяців тому

    I KNEW there was a way to do this. Thank you for the simple example. It clarified A LOT for me in designing my documents and merges!! Much appreciated.

  • @thomaticus7507
    @thomaticus7507 7 місяців тому

    Thank you so much for this!!!!! I remember trying to learn this many many years ago. never could do it. Now I needed to use this skill and found your video.

  • @rick-vista1612
    @rick-vista1612 8 місяців тому

    Kudos to you sir!

  • @username-oq1cc
    @username-oq1cc 8 місяців тому

    Thanks a bunch, it took me while to find your video among all the one that are using 3rd party tools, plugins, etc. Much appreciated! I like your to-the-point style of explaining.

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

    FINALLY! THIS SOLVED

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

    Merci !

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

    Great, no-bs explanation. Thanks a bunch!

  • @mh.a4083
    @mh.a4083 10 місяців тому

    That's great, i have a 400 students in my exel and and now i can easily give them their certificates. But isn't there a way to save all of them in individual word files?

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

      I believe you should be able to generate individual word docs once you click on "finish and merge."

  • @EricLiu-SDAT
    @EricLiu-SDAT 10 місяців тому

    this is the best tutorial ever... thank you

  • @dvklaveren
    @dvklaveren 10 місяців тому

    When I try this, it replaces the merge fields with messages about the bookmark not being defined (I work in a Dutch company, so the error is shown in Dutch). Why would that happen?

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

      I'm sorry I don't think I know the answer to this one.

  • @MosquitoBait
    @MosquitoBait 10 місяців тому

    Thanks a million

  • @morarucosmin6776
    @morarucosmin6776 10 місяців тому

    Dude, your volume is allmost zero. But yes, informative :)

  • @JustGwen05
    @JustGwen05 10 місяців тому

    THANKS FOR THIS - 😅

  • @asvyoutube
    @asvyoutube 11 місяців тому

    How do you customise the names of the files created

  • @lawrencekoestler742
    @lawrencekoestler742 11 місяців тому

    Thanks for the video. Just what I needed.

  • @benoit7342
    @benoit7342 11 місяців тому

    Thank you for this vidéo!❤

  • @aaronjudesaldanha5688
    @aaronjudesaldanha5688 11 місяців тому

    this is amazing - thanks for sharing

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

    Amazing! Found the solution thanks to you!

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

    That was truly very helpful

  • @denise.davis-probaterealtor

    Thank you!

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

    4 years after posting and still helping people!! Thank you!

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

    Thanks

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

    Is there a way to automatically add more pages in Word with each page containing the same template, but with each info from the Excel sheet?

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

      I'm sorry I'm not sure I understand the question.

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

      @@andrewligonfant319 Like duplicate the same page with the same contents in the same document

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

    😁 Promo-SM

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

    @Andrew Ligon Fant, many thanks, was indeed very helpful. Quick question: I would like to save each word document for 'John' and then 'Jane' in your case. What do I need to do then ?

  • @ElyonSolutions-n2j
    @ElyonSolutions-n2j Рік тому

    Good

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

    Can you use this same technique for creating standard letters from a selection of pre-written paragraphs?

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

      Of course! In fact, I've used this to do that exact thing.

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

      @@andrewligonfant319 do you have a video on that ?

    • @Crunch630
      @Crunch630 11 місяців тому

      Just use common sense dude. IF formulas and writing long sentences as the cell values.

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

    Great teacher! I have listened to all four videos and would enjoy more.

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

    Thank you for sharing. Best regards from Panama 🇵🇦

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

    i am moving over currency values and it does not format correctly to word. no commas and more than 2 decimal. how do we format the word document

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

    Can you do this in Outlook rather than Word?

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

    I was struggling for days . Thank you so much

  • @GouravSharma-k6s
    @GouravSharma-k6s Рік тому

    Great...but it works not for first 50 entries

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

    I have about 72 different rows of information to fill on a word template. Once I have the final templates filled in is there a way to save individual templates vs all 72 on one document? Thank you.

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

    내가 찾던 자동화 방법 입니다 감사합니다.

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

    This is so excellent. Thank you!!!