Creating Professional Invoice in Excel | Receipt Making Tutorial | Free Template

Поділитися
Вставка
  • Опубліковано 26 вер 2018
  • Was it helpful to you? You can buy me a drink if you want
    paypal.me/samx360
    Lets create a Receipt [Invoice] in excel in few minutes. Include free excel xlsx template for download.
    Download This Excel Invoice:
    drive.google.com/uc?export=do...
    She how to create cover page, cv, resume etc in Microsoft word in my other videos.
    ~-~~-~~~-~~-~
    Please watch: "Invoice Creating Tutorial in Excel | Create Receipt in Excel [With Music]"
    • Invoice Creating Tutor...
    ~-~~-~~~-~~-~

КОМЕНТАРІ • 364

  • @accountsmanager2187
    @accountsmanager2187 3 роки тому +49

    So nice, no talking and to the point. Why can't most tutorials be like this one

    • @frogget76
      @frogget76 2 роки тому +1

      I agree

    • @llovescake15
      @llovescake15 Рік тому +1

      Because it takes a lot more time while talking, you can instantly do it while doing the task

    • @sethlilau8218
      @sethlilau8218 Рік тому +1

      they think its the fastest way to get views and be heard

  • @chynadoll4576
    @chynadoll4576 Рік тому +20

    This was straight forward, clean and easy! Absolutely love it!! No talking, instructions written to the side of the screen was so convenient and easy to understand!! 10/10

    • @ESonPi
      @ESonPi 4 місяці тому +1

      Indeed

  • @Tunogkalyeah
    @Tunogkalyeah 4 роки тому +5

    excel was a big rule to any businesses i am dealing with it everyday for couple of years now so i am sharing my skills to help others

  • @aurangzaibm5963
    @aurangzaibm5963 3 роки тому +4

    Excellent video. I normally hate the silent demo style, but your clear descriptions on the right make this clear and easy. Thank you.

  • @paulc8778
    @paulc8778 3 роки тому +14

    Just starting new business, followed process to make first master invoice, very impressive. Easy to print or attach electronically to an email. Thank you very much for sharing, great job.

  • @emeraldtobias9927
    @emeraldtobias9927 2 роки тому +4

    Thank you so much for sharing this. I'm a business start-up and this kind of information saves me a lot of time. God bless you!

  • @prophecy0731
    @prophecy0731 4 роки тому +5

    Very helpful. I really appreciate it. Now my business looks more professional.

  • @NinjaTweetsS
    @NinjaTweetsS 4 роки тому +12

    Flippin THANK YOU SO MUCH. This was such a help!

  • @MOHAMEDHASSAN-gp1nt
    @MOHAMEDHASSAN-gp1nt 5 років тому +1

    كما نقول في بلادنا "السهل الممتنع" انت شخص رائع

  • @jameseshelman4289
    @jameseshelman4289 Рік тому +1

    Thank You so much. I have been paying for quick books for my business and I am no accountant. Because of there system my books are all messed up. my CPA accountant said to ditch quick books all together he heats the program. Excel will do exactly what I wanted from quick books with out costing me money. Thanks to for your video now I have a perfacinal looking invoice with out paying for one. as you have read in the past it was easy to fallow. I have no understanding of excel and due to my unxcperance it did take me a while had to watch the video a few times but it worked. Thank you again.

  • @JM-qn7ci
    @JM-qn7ci 5 років тому +4

    Thanks to your tutorial it helps me for my online shop :)

  • @lombongo3347
    @lombongo3347 4 роки тому +7

    Perfect, such a great tutorial. Really helped.

  • @akberbasha6156
    @akberbasha6156 3 роки тому +3

    That was Good and easy to access for every one who is starting new mini business. Thanks and i hope you will teach us more in advance.

  • @itumelengjoseph3470
    @itumelengjoseph3470 5 років тому +30

    Thanks, this is my whole assignment

    • @jassn6957
      @jassn6957 3 роки тому +5

      Did you graduate ? Congratulations if so !

  • @makeupbyife
    @makeupbyife 4 роки тому +3

    Lord I'm so happy I found you 😊🙏🏾

  • @spankytony
    @spankytony 4 роки тому

    Hello, I tried to use the IF statement to eliminate the dash in my result column but always had an error, I am using office 2016, can you help please?

  • @gunrangergaming
    @gunrangergaming 3 роки тому +1

    Thank you so much, was worth my time and saved me alot with my business

  • @bill13gats
    @bill13gats 4 роки тому +35

    You just saved my life !

  • @katrinayap5934
    @katrinayap5934 3 роки тому

    hi, may i use to print the billing format on A6 thermal printer?

  • @roy2939
    @roy2939 4 роки тому +1

    Your method is easy to understand. Thank you for your videos

  • @cleretfernandes5972
    @cleretfernandes5972 Рік тому +1

    Your guidance was by far the best..we could understand it step by step.
    Thank you Sir

  • @Ciopi92
    @Ciopi92 3 роки тому +4

    Ctrl+y repeat the last action.
    So merging cells don't have to be boring 😁
    Thanks for the idea of an invoice 👍🏻

  • @kamrankhan-zb7vr
    @kamrankhan-zb7vr 4 роки тому +3

    Its owsome I learn lots of things from you but one thing i don't understand that why its necessary to merge and center content when you have better option available in the form of "merge across selection"..

  • @silverstrandgardens62
    @silverstrandgardens62 3 роки тому +1

    Thank you so much! Almost in tears! You saved me!

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

    Amazing video presentation without the voice. Very clear to the point. Good job!

  • @intruder25ful
    @intruder25ful 4 роки тому +7

    you just made my life easier thank you!!!! my dad and i just open a mechanic shop and this is going to help us a lot!! just one question how can i add LABOR with out adding taxes?

    • @maryagyemang9870
      @maryagyemang9870 4 роки тому

      you just have to edit that out with the spreadsheet

  • @jackywan6829
    @jackywan6829 4 роки тому

    Can this combine with the barcode device to avoid manually inputting one by one?

  • @aswathymindmasters104
    @aswathymindmasters104 3 роки тому +1

    Helpful video. Thank you so much.. Expecting more videos of advance Excel features..

  • @BGD.2980
    @BGD.2980 3 роки тому

    You're the man Technomaniac!

  • @bumpyfreddy2629
    @bumpyfreddy2629 3 роки тому

    Question I have a chrome book laptop and how do you get like those extra options at the top

  • @ayocoraedu9652
    @ayocoraedu9652 Рік тому +1

    Informative and easy to follow through. Great job

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

    I wish I could double tap this video!!! I had my phone And laptop going Step by step! Excellent video👏🏾👏🏾

  • @sumanthkulkarni8285
    @sumanthkulkarni8285 2 роки тому +3

    Sir for merging more sells like that you can do like this
    Select all the cell you want to merge
    Click 🔽 symbol shown in right corner of the option merge and center
    Choose merge across

  • @signaturemaster
    @signaturemaster 3 роки тому +1

    thank you so much for this amazing tutorial

  • @muhammadqadri3808
    @muhammadqadri3808 2 роки тому

    Thanks for the video. While creating a new invoice, can we make it to change invoice number automatically.

  • @hakeemkhanyousafzai1170
    @hakeemkhanyousafzai1170 3 роки тому

    Thank you so much Sir God make you more successful and Healthy life. Your Vedio make us professional.🥰🥰🥰

  • @noroxxx2349
    @noroxxx2349 2 роки тому +2

    I am about to create my first invoice for my new business, this is good. Thank you x

  • @maruthiudyamshaliyal5572
    @maruthiudyamshaliyal5572 4 роки тому +2

    thank you so much for your suggestion

  • @koseshie6762
    @koseshie6762 5 років тому +15

    (Amount)...."Total Ammount", "Final Ammount"

  • @iankatusiime6878
    @iankatusiime6878 3 роки тому +1

    This was so helpful!

  • @kalyanimkalyanim3290
    @kalyanimkalyanim3290 4 роки тому

    Plz reply this receipt how to insert in pagemaker as it is same

  • @satoshinakamoti3433
    @satoshinakamoti3433 4 роки тому +3

    when we edit there, it splits in two sheets and all settings get disturb.

  • @cuni_stula_g
    @cuni_stula_g 2 роки тому

    This is the best excel video I have ever watched

  • @hassamab1502
    @hassamab1502 3 роки тому

    nice work it's a really professional invoice format

  • @vaneidemartins6394
    @vaneidemartins6394 2 роки тому

    Thank you! Easy to follow instruction.

  • @qudratullahkhan4518
    @qudratullahkhan4518 4 роки тому +28

    Tutorial is great, but you can accelerate your cell merging speed by choosing the option "Merge Across" from cell merge, when you are applying it on moremore than two rows.
    I hope you have got my point?

    • @SheikaSiera
      @SheikaSiera 3 роки тому +2

      Thank you, that was annoying me and i was wondering if there was a better way. You are kind to share your knowledge.

    • @jeromeuriah7235
      @jeromeuriah7235 2 роки тому

      i know Im asking randomly but does any of you know of a method to log back into an Instagram account??
      I was stupid lost the account password. I appreciate any help you can give me.

    • @kamryntony3523
      @kamryntony3523 2 роки тому

      @Jerome Uriah instablaster =)

    • @jeromeuriah7235
      @jeromeuriah7235 2 роки тому

      @Kamryn Tony Thanks so much for your reply. I found the site thru google and I'm waiting for the hacking stuff now.
      Takes quite some time so I will reply here later with my results.

    • @jeromeuriah7235
      @jeromeuriah7235 2 роки тому

      @Kamryn Tony it did the trick and I finally got access to my account again. I'm so happy:D
      Thanks so much, you really help me out!

  • @kgosimatsau6534
    @kgosimatsau6534 4 роки тому +2

    Thank you very much. So helpful, now i need to practise.

    • @Chinchin-cc4he
      @Chinchin-cc4he 4 роки тому +1

      Use professional Invoice maker, such as RapidBooks, easy to start, and it looks very professional.

    • @thatsenam9183
      @thatsenam9183 2 роки тому

      Create Invoice Online Free Unlimited -> invoicepedia.com

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

    thank you so much for this videoo

  • @candyman190
    @candyman190 2 роки тому

    What would "SL No" be when creating the Product Information Table?

  • @ibrahimksesay9955
    @ibrahimksesay9955 3 роки тому

    It's grate I'm proud to call u teacher
    God bless u

  • @thebesttechnical3608
    @thebesttechnical3608 4 роки тому +1

    Thanks for sharing a good and fast way.

    • @ktv3184
      @ktv3184 4 роки тому

      ua-cam.com/video/zVk46m2aSvg/v-deo.html

  • @haroonurrasheed4626
    @haroonurrasheed4626 4 роки тому +9

    Please make invoice with Store- to make invoice and automatic deduct from Stock

  • @rjmethri
    @rjmethri 3 роки тому

    how to get and maintain the same data on sheet2?

  • @MfRipper2007
    @MfRipper2007 3 роки тому +1

    Thank you so much, so useful for my shop..

  • @theonearmwolf4956
    @theonearmwolf4956 2 роки тому

    THank you so much! Really saving money and time.

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

    This has helped me so much. Thank you for this video.

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

    thank you so much for making the invoice downloadable!

  • @wesammoh7330
    @wesammoh7330 4 роки тому +1

    How it will be if we have more than one page?

  • @jackiewin4289
    @jackiewin4289 2 роки тому

    Amazing Tutorial! and thank you!!!

  • @sanabria-designs5343
    @sanabria-designs5343 Рік тому

    Thank you for your time and for sharing!! Blessings

  • @mohamadnur5014
    @mohamadnur5014 5 років тому +1

    was very helpful, thanks.

    • @ktv3184
      @ktv3184 4 роки тому

      ua-cam.com/video/zVk46m2aSvg/v-deo.html

  • @user-hg7yv5fj1f
    @user-hg7yv5fj1f 3 роки тому +1

    Thank you!! Understand so much now

    • @thatsenam9183
      @thatsenam9183 2 роки тому

      Create Invoice Online Free Unlimited -> invoicepedia.com

  • @nyasha8657
    @nyasha8657 4 роки тому

    Good job mate!!

  • @tomjones1502
    @tomjones1502 3 роки тому +1

    For repetitive task, use F4

  • @circle4922
    @circle4922 4 роки тому

    When I go to page layout, my page width or margins are wrong. Columns H and I are on the next page. Also the word INVOICE doesn't go to the end of the "C" cell. I'm on MacOS...
    Selecting narrow margins gets the "H" column on the page, I think. But text word "invoice" still doesn't fit/look like it does in your example.

    • @MsBossii1
      @MsBossii1 4 роки тому

      Go to page layout and shrink the size i do 50% or 55% when you do this you will see a dotted line on the page that shows you where it ends. When you change the page layout percentage

  • @alkeshjadhav5741
    @alkeshjadhav5741 3 роки тому +1

    Awesome help! Thank you so much!

    • @thatsenam9183
      @thatsenam9183 2 роки тому

      Create Invoice Online Free Unlimited -> invoicepedia.com

  • @sarahicarrillo6526
    @sarahicarrillo6526 3 роки тому

    I found some invoice templates on Excel through Microsoft that you can just dowload. How do you save the current invoice you filled out but also a blank copy of the template so that I can always have a fresh one to start a new invoice? I have tried it several times and it saves a copy of my invoice but on the template I have to delete everything and then type new info.

    • @Nitu_S.C.
      @Nitu_S.C. 2 роки тому

      ...too late, but...isn't the option "Save as" exactly for this? And after that you can just modify the data on the initial/original file.

  • @pharmarafi
    @pharmarafi 3 роки тому

    What about invoice number?.there is any option to change automatically

  • @sulaimankhan1028
    @sulaimankhan1028 4 роки тому

    Wow. It's very helping vedio

  • @FratATeenWOLFScoT
    @FratATeenWOLFScoT 4 роки тому

    Thank you so much brother.

  • @s.j.graphicsdesignaccounti5340
    @s.j.graphicsdesignaccounti5340 5 років тому

    BEST VIDEO SIR JI.

  • @jerrymouxe4947
    @jerrymouxe4947 2 роки тому

    9:10 is it fine if I don’t want to modify it still work ?

  • @tytania3545
    @tytania3545 2 роки тому

    Thank you for the tips!

  • @nileshdabhi276
    @nileshdabhi276 4 роки тому

    thanks for the tutorial 🙏

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

    thank you so much, u are the greatest!

  • @iamempressive369
    @iamempressive369 2 роки тому

    Thank You so much for helping.. God Bless!

  • @sabesat321
    @sabesat321 3 роки тому

    Thankyou for the template!

  • @borisapantelic7186
    @borisapantelic7186 2 роки тому

    THANKS JUST DOWNLOADED!

  • @natashafelder2701
    @natashafelder2701 2 роки тому +1

    How do I sign "signature and seal" electronically?

  • @josephestipona2859
    @josephestipona2859 4 роки тому

    hi, this is kevin. very informative video. very nice

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

    thank you for the excellent tutorial bro

  • @saab994
    @saab994 4 роки тому +2

    How to add stock or inventory in the excel sheet help out

    • @thatsenam9183
      @thatsenam9183 2 роки тому

      Create Invoice Online Free Unlimited -> invoicepedia.com

  • @blingmotions6996
    @blingmotions6996 2 роки тому

    And how would you add this template to word after ur finish?

  • @joshuakapuku1035
    @joshuakapuku1035 3 роки тому

    can i get some help my total it's showing with percentages what have a tape wrong

  • @aneeskooloth4396
    @aneeskooloth4396 4 роки тому

    Perfect video Thanks

  • @olmanestinable6866
    @olmanestinable6866 3 роки тому

    I really appreciate you.

  • @chikkaminuteph7013
    @chikkaminuteph7013 4 роки тому

    This tips are helpful 👍👍

  • @sherreerobichaud9999
    @sherreerobichaud9999 3 роки тому +2

    Receipt “I before e except after c”. Check your main slide 🤗

  • @mihirkataria2282
    @mihirkataria2282 3 роки тому +1

    GREAT, GOOD JOB IT WAS VERY VERY HELPFUL KEEP IT UP

    • @thatsenam9183
      @thatsenam9183 2 роки тому

      Create Invoice Online Free Unlimited -> invoicepedia.com

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

    thank you so much liked and subscribed

  • @corynolan3838
    @corynolan3838 3 роки тому

    Thank you soo much!

  • @shamimahmedsultan9357
    @shamimahmedsultan9357 3 роки тому

    so helpful video. Thanks bro😍

  • @user-kq9bz5re1p
    @user-kq9bz5re1p 4 місяці тому

    THANK YOU SO MUCH

  • @mohammadyaqoob3036
    @mohammadyaqoob3036 4 роки тому +2

    Good work, But can you add auto invoice number 1001 to save shown 1002 and continues

    • @hey_rahul07
      @hey_rahul07 3 роки тому

      I was also about to ask this..🙄

  • @naiji7262
    @naiji7262 2 роки тому

    Hi
    How to copy this to other sheets in same work book

  • @charitoskalikatzarakis8510
    @charitoskalikatzarakis8510 4 роки тому

    If i want to make multiple rows (1000 rows) with the products what i have to do?

    • @stephenkelley6958
      @stephenkelley6958 4 роки тому

      You should try professional Invoice Maker, such as RapidBooks

  • @taurustransportllc4824
    @taurustransportllc4824 2 роки тому

    THANK YOU SO VERY HELPFUL

  • @almamunsha
    @almamunsha 5 років тому +1

    how to create page 2

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

    Brilliant thank you so much 😊

  • @mohammadshahidalam5425
    @mohammadshahidalam5425 4 роки тому

    Dear guys can u send link for download video from youtube?