Andrew Ligon Fant
Andrew Ligon Fant
  • 7
  • 431 833
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.
Переглядів: 92

Відео

How to Create and Format Tables in Microsoft Excel
Переглядів 35510 місяців тому
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
Переглядів 14210 місяців тому
Here's how to multiply two or more numbers in Excel.
How to Subtract Numbers in Microsoft Excel
Переглядів 18010 місяців тому
Just what the title says how to subtract two or more numbers in MS Excel.
How to Add Numbers in Microsoft Excel
Переглядів 3010 місяців тому
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
Переглядів 62 тис.4 роки тому
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
Переглядів 370 тис.4 роки тому
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.

КОМЕНТАРІ

  • @estudos6491
    @estudos6491 6 днів тому

    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 14 днів тому

    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 14 днів тому

      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 20 днів тому

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

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

    Helped a lot thanks

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

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

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

    Most useful

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

    great presentation exactly what I needed

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

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

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

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

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

    Kudos to you sir!

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

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

    FINALLY! THIS SOLVED

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

    Merci !

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

    Great, no-bs explanation. Thanks a bunch!

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

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

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

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

    this is the best tutorial ever... thank you

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

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

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

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

    Thanks a million

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

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

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

    THANKS FOR THIS - 😅

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

    How do you customise the names of the files created

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

    Thanks for the video. Just what I needed.

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

    Thank you for this vidéo!❤

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

    this is amazing - thanks for sharing

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

    Amazing! Found the solution thanks to you!

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

    That was truly very helpful

  • @denise.davis-probaterealtor
    @denise.davis-probaterealtor 8 місяців тому

    Thank you!

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

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

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

    Thanks

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

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

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

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

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

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

    😁 Promo-SM

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

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

    Good

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

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

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

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

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

      @@andrewligonfant319 do you have a video on that ?

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

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

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

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

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

    Thank you for sharing. Best regards from Panama 🇵🇦

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

    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

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

      I'm not sure I have the answer, but I bet someone does!

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

    Can you do this in Outlook rather than Word?

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

    I was struggling for days . Thank you so much

  • @GouravSharma-k6s
    @GouravSharma-k6s 11 місяців тому

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

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

    nice, simple and straight to direction

  • @BABA-is8kv
    @BABA-is8kv Рік тому

    Your awesome! Thank you!

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

    I know this is an older video. Is there a way that I can fill down instead of per sheet? As I am trying to use it to send need dates to a vendor. Thanks in advance.

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

    What if I need to add multiple entries from the same list in one excel document. What I mean is if I insert a merge field twice for eg. "Name" and I need two different names to show up under one word document.. is it possible?

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

    Straight to the point and easy to follow. Thank you.