Creating Your Own Excel Templates

แชร์
ฝัง
  • เผยแพร่เมื่อ 13 ก.ค. 2024
  • Here's my entire playlist of Excel tutorials: bit.ly/tech4excel
    Learn how to easily create your own Excel templates so that you can easily and quickly begin filling out an Excel spreadsheet that you use on a regular basis, but one that you need a new copy of each time you use it. This is a time-saving feature of Excel. #excel #exceltutorial #exceltips #exceltemplates ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
  • แนวปฏิบัติและการใช้ชีวิต

ความคิดเห็น • 106

  • @mrsirman2177
    @mrsirman2177 4 ปีที่แล้ว +189

    You know you're old when you binge watch Excel tutorials

    • @unnaturalatrophy5377
      @unnaturalatrophy5377 4 ปีที่แล้ว +28

      I'm 17. This is what happens when you have no friends haha

    • @charlesrummel2692
      @charlesrummel2692 4 ปีที่แล้ว +2

      Guilty.

    • @dave26262
      @dave26262 4 ปีที่แล้ว +1

      @@unnaturalatrophy5377 jajjaajajaha

    • @92417
      @92417 4 ปีที่แล้ว +2

      Thanks for that old man 🤣

    • @blackawana
      @blackawana 4 ปีที่แล้ว +3

      ...because other old people are asking you so many questions!

  • @danab172
    @danab172 5 ปีที่แล้ว +63

    Hi. I just want you to know that all of your tutorial videos are quick and clear. Thank you!

  • @MsGillian31
    @MsGillian31 4 ปีที่แล้ว +7

    Thank you so much for these excellent videos. They are substantively great, and your instructing manner is super--well-paced, clear, and really pleasant to watch.

  • @laurielagrone6989
    @laurielagrone6989 4 ปีที่แล้ว +3

    Very useful for brushing up on Excel. I have Numbers (a Mac program) at home, not Excel, but I was still able to recreate everything here. Thank you!

  • @centpushups
    @centpushups 4 ปีที่แล้ว +17

    Slowly grinding my way through these tutorials.

  • @jackmwamba7663
    @jackmwamba7663 5 ปีที่แล้ว +6

    i never know anything about excel but thanks to your tutorials i able to do all alot of stuff and that just in 2 days..so thanks you're the best...I'll keep on working to improve

    • @techteachersandstudents
      @techteachersandstudents  5 ปีที่แล้ว +3

      Thanks for your kind comments. I hope you'll watch my whole Excel playlist here: bit.ly/tech4excel

  • @thomasedwardking7286
    @thomasedwardking7286 3 ปีที่แล้ว

    Really clear and well delivered video. Thank you so much 👍

  • @RPC5O8
    @RPC5O8 5 ปีที่แล้ว +4

    You sound like falcon from Gameranx. He's my favorite. Great tutorials, by the way. So very helpful!

  • @craigtomlinson5593
    @craigtomlinson5593 3 ปีที่แล้ว

    Love your videos. So easy to follow.

  • @madrinsx8770
    @madrinsx8770 6 ปีที่แล้ว +2

    Thank you so much😘It helped!

  • @vinayazzie4409
    @vinayazzie4409 3 ปีที่แล้ว

    Very well done. I like them simple and useful. Thank you.

  • @shathaismaelhussein9550
    @shathaismaelhussein9550 4 ปีที่แล้ว

    Thank you so much simple and clear lesson god bless you

  • @etm1966
    @etm1966 3 ปีที่แล้ว

    So helpful!! Thank you!

  • @bez81anderson5
    @bez81anderson5 ปีที่แล้ว

    So easy to follow, thanks so much for sharing 😊

  • @Mamomamosalemvsaehiojf123
    @Mamomamosalemvsaehiojf123 2 ปีที่แล้ว

    Thank you, this was very helpful

  • @zoecalifornia80
    @zoecalifornia80 9 หลายเดือนก่อน

    This was sooooooo helpful! Thank you so much!

  • @ibethminaya6316
    @ibethminaya6316 2 ปีที่แล้ว

    Hey! I have to say, that you make me binge watch your videos, i find to learn excel so interesting! My sister walked next to me and said: “that show must be very interesting!” 🤣😅🤣🤣 anyways, i am leaving a like on each of your videos, you are doing an amazing job!!! 🙌🏼🙌🏼🙌🏼 thank you!!!

  • @TheGeorgeDmax
    @TheGeorgeDmax 2 ปีที่แล้ว

    Awesome Clear, Concise and Direct to the Point Tutorial
    For that Reason will Subscribe 😍

  • @bensonmoima6872
    @bensonmoima6872 5 ปีที่แล้ว

    Sie sind großartig, vielen Dank für die Vorträge. Please do for us some examples on how to answer college exams on vlookup-advance, if-advance and pivot table-advance. Already watched the basics and they are fantastic.

  • @Elitev101
    @Elitev101 ปีที่แล้ว

    Simple and great video👍🏽

  • @zoecalifornia80
    @zoecalifornia80 9 หลายเดือนก่อน

    BOOM! I DID IT! Thank you so much!!😀

  • @mummy_gen
    @mummy_gen 2 หลายเดือนก่อน

    Thank you for making it easier 💯🙏

  • @choosetoshine2610
    @choosetoshine2610 3 ปีที่แล้ว

    Excellent demo! New subscriber

  • @richjones96
    @richjones96 6 ปีที่แล้ว +6

    Is it possible for you to publish the monthly family budget template? I would love to use it!

  • @onurkansimsek2741
    @onurkansimsek2741 3 ปีที่แล้ว

    You are perfect!

  • @umer_munawar
    @umer_munawar 3 ปีที่แล้ว

    thank you!

  • @nsmmathsolutions976
    @nsmmathsolutions976 ปีที่แล้ว

    I love your lesson

  • @SaiGuy_
    @SaiGuy_ ปีที่แล้ว

    Thank you very much

  • @armandoibarra4497
    @armandoibarra4497 3 หลายเดือนก่อน

    Great video! 👍

  • @shoppersdream
    @shoppersdream 4 หลายเดือนก่อน

    Nice, thanks!

  • @canernm
    @canernm 5 ปีที่แล้ว

    Thanks

  • @shaludubey2325
    @shaludubey2325 3 ปีที่แล้ว +1

    बहुत बढ़िया 🙏

  • @teresaherold9578
    @teresaherold9578 ปีที่แล้ว

    So helpful

  • @chinabono8995
    @chinabono8995 3 ปีที่แล้ว

    Thank You!!!1

  • @charmainedelacruz2121
    @charmainedelacruz2121 6 ปีที่แล้ว

    Thank you. :^)

  • @hazemali382
    @hazemali382 4 ปีที่แล้ว

    more than great

  • @uraaxeecaqligaaga4890
    @uraaxeecaqligaaga4890 5 ปีที่แล้ว +1

    Thank but I would like to see you generating that monthly family budget. Plzzzzz

  • @g-s6459
    @g-s6459 21 วันที่ผ่านมา

    Hey Mike, I would love to have that Excel template, if you would be willing to share. Great video and best of luck on your journey!

  • @kamalkumarpatel4073
    @kamalkumarpatel4073 2 ปีที่แล้ว

    Good Info

  • @fauziyabafagih6625
    @fauziyabafagih6625 3 ปีที่แล้ว

    Will it appear in Personal templates if I need to save it to a shared network or cloud drive for others to use too?

  • @futuresuperstar4life
    @futuresuperstar4life 2 ปีที่แล้ว

    is there a way you can do something similar but open another sheet within a work book as a template with the values refreshed??

  • @rebeccaharvey6385
    @rebeccaharvey6385 4 หลายเดือนก่อน

    Thank you for your tutorial. using templates still relies on the user remembering to save the file as a worksheet again, though right?? IE the template was edited with Novembers numbers, you'd have to 'save as' and revert back to the xlsx file format?

  • @angelicacarrion4063
    @angelicacarrion4063 2 ปีที่แล้ว

    I have a question. I pull reports from an online system that exports it to excel. Instead of formatting it every time, would a template help with that? Like can i apply template formatting to an exported worksheet?

  • @greatlakeschorus6887
    @greatlakeschorus6887 4 ปีที่แล้ว

    Could you share the budget template?

  •  4 ปีที่แล้ว

    i use Macbook. can i do same manual?

  • @fanymelo7424
    @fanymelo7424 2 ปีที่แล้ว

    Hello thank you for the video. I followed all the steps but the Personal option does not appear on mine. Any idea why that could be? Thank you !

  • @davidschwartz4536
    @davidschwartz4536 3 ปีที่แล้ว

    I used this video to help with learning how to work with excel. I’m having trouble though. I tried to save my custom template like this, but now when i open it all my drop down lists are gone, what did i do wrong?

  • @einyv
    @einyv 2 ปีที่แล้ว

    Have you come across an issue with templates not opening into a new document? I have office 365. If you do, do you know how to resolve?

  • @AnifuddinAfg
    @AnifuddinAfg 19 วันที่ผ่านมา

    how to showing again google sheet template?, because in my google sheet i don't find option turn on.

  • @zeeshansaifi9208
    @zeeshansaifi9208 4 ปีที่แล้ว

    Sir I have downloaded Excel template from WPS office so can I sell the template on fiver using your method?

  • @mohindamaher1341
    @mohindamaher1341 ปีที่แล้ว

    how do I edit a readymade template. How change pictures that are already in the template and add my own images??

  • @harleydavidsondf
    @harleydavidsondf 2 ปีที่แล้ว

    Can I use a template and save it as a tab in an already working workbook?

  • @ingee8
    @ingee8 3 ปีที่แล้ว

    I like to ask you a question. My question is. Can I make a template, with only the printed text I type on the template and not have the back ground print out? Let me explain more what I am asking. When you open word the default page is a white page, you can start typing text. What I am trying to create, if at all possible is a template of a scroll paper as a template with the color background, and where you can see the top and bottom of the page rolled up like scroll paper. I want to see the picture of the scroll paper as I type on the template, but when I send the document to the printer, I do not what the background of the template to print out, only the text. The reason I do not want the color background of the template to print out is, when I print the document I have the actual scroll paper and I will load that in the printer to print out on the scroll paper I load in the printer. Is such a template possible or am I asking to much?

  • @Yajairad
    @Yajairad 5 ปีที่แล้ว

    How can I delete one of these personal templates?

  • @glisten_skin
    @glisten_skin 2 หลายเดือนก่อน

    Mine isn't showing up in the "personal" place like that. There's just a bunch of other templates from online showing up on my "personal" place. Help?

  • @zeeshansaifi9208
    @zeeshansaifi9208 4 ปีที่แล้ว

    after using this method can I sell the template??

  • @guomei5988
    @guomei5988 3 ปีที่แล้ว

    hey, I used your method and created a template show negative numbers in brackets( so sick of changing them every time), but can't do the zero showing dash / "-" in the same template, help ~ thx

    • @guomei5988
      @guomei5988 3 ปีที่แล้ว

      I figured how, still, thanks!

  • @boredkid444
    @boredkid444 4 ปีที่แล้ว

    Internal database memory disk file access system.

  • @sakatherinejohnson
    @sakatherinejohnson 2 ปีที่แล้ว

    But how can we get the same template to copy on a new sheet at the bottom? 🤔✍🏽

  • @arugarg8084
    @arugarg8084 ปีที่แล้ว

    How u made this sheet like boxes

  • @lunks10
    @lunks10 5 ปีที่แล้ว

    the button is not showing up

  • @katherineh9814
    @katherineh9814 7 หลายเดือนก่อน

    How do you get to the info with a mac please anyone?

  • @Crimsonvalleystables
    @Crimsonvalleystables 3 ปีที่แล้ว

    But you’re working in a pre-existing template. Who created the template in which you are working? I need to create a reusable template.

  • @sathyanarayanansatagopan9069
    @sathyanarayanansatagopan9069 3 ปีที่แล้ว

    Excel to tally template?

  • @mithelmayuela4241
    @mithelmayuela4241 3 ปีที่แล้ว

    Hi what is the name of apps?

  • @rosac8168
    @rosac8168 ปีที่แล้ว

    Si what if the template is made by your employer for weekly productivity? I find my self deleting every week and starting all over again

  • @julietegbule5532
    @julietegbule5532 3 ปีที่แล้ว

    Please how can i Unhide my sheet

  • @AbdullahSaleem1
    @AbdullahSaleem1 3 ปีที่แล้ว

    wished watched it 2 years ago

  • @anamta7753
    @anamta7753 2 ปีที่แล้ว

    Can you share this excel file?

  • @jackwilloughby871
    @jackwilloughby871 2 ปีที่แล้ว

    this doesnt work for excel online only the desktop app.

  • @JTMC97
    @JTMC97 3 ปีที่แล้ว

    0:54 Well i hate to say it but we can see it too...

  • @rebeccalankford2652
    @rebeccalankford2652 4 ปีที่แล้ว +1

    This is saving a template. What about creating your own?

    • @abiolaoyewole1863
      @abiolaoyewole1863 4 ปีที่แล้ว

      Exactly my thought

    • @hafsaryuzaki3295
      @hafsaryuzaki3295 4 ปีที่แล้ว +1

      That’s what he just did....u create an excel then later save it as a template....then u can use it repeatedly as a template!

  • @stuartclitheroe113
    @stuartclitheroe113 5 ปีที่แล้ว

    How is this more useful than copying and pasting last months spreadsheet?

    • @fauziyabafagih6625
      @fauziyabafagih6625 3 ปีที่แล้ว

      If you're working with a big spreadsheet with a lot of variables that change every month, it helps to make things clearer to have a blank canvas.

  • @MusicHPWorld
    @MusicHPWorld 2 หลายเดือนก่อน

    Hi guys 😁

  • @linepro9808
    @linepro9808 2 ปีที่แล้ว

    This doesn't teach how to create a new template you are just editing the one you created before

  • @AsmaaPurity
    @AsmaaPurity 5 ปีที่แล้ว

    I can't see anything in the video why is it black?

  • @jedidjachs5280
    @jedidjachs5280 ปีที่แล้ว

    Lol

  • @lechienchaud3904
    @lechienchaud3904 2 ปีที่แล้ว

    when you get a chance can you send me a photo of your freshly waxed biceps

  • @dutube99
    @dutube99 5 ปีที่แล้ว +1

    "templit"? temPLATE!

    • @isobel64
      @isobel64 4 ปีที่แล้ว +2

      stfu