Mr.SpreadSheet

Mr.SpreadSheet

Creating Spreadsheet applications for small businesses and for education.

A ‘Step by Step’ approach to designing useful business spreadsheet applications and helping you develop your spreadsheet skills.

Work at your own pace and follow the videos to design your spreadsheets from scratch.

All accompanying spreadsheet downloads are available for download from our website - go to

www.MrSpreadSheet.com

If you would like to learn more and enhance your spreadsheet skills then please Subscribe to out KZread Channel.

You can also visit our various channels at:

USA, Canada and World - www.MrSpreadSheet.com
UK & Europe - www.MrSpreadSheet.co.uk
FaceBook - facebook.com/MrSpreadSheets
Instagram - instagram.com/mrspreadsheet
Twitter - twitter.com/Mr_SpreadSheet

Пікірлер

  • @chisybaby__
    @chisybaby__2 күн бұрын

    This was great! Thank you so much. God bless you

  • @MrSpreadSheet
    @MrSpreadSheet2 күн бұрын

    Glad it was helpful!

  • @everythingefyatchoko2042
    @everythingefyatchoko20426 күн бұрын

    Please i need a copy

  • @MrSpreadSheet
    @MrSpreadSheet6 күн бұрын

    Hi, downloads are available at www.MrSpreadSheet.com :-)

  • @Youjin52508
    @Youjin525089 күн бұрын

    define name is block so I can't make it

  • @MrSpreadSheet
    @MrSpreadSheet8 күн бұрын

    Hi, You may be using the cloud/mobile version of Excel which has a number of similar limitations :-)

  • @daniellejohnson8621
    @daniellejohnson862113 күн бұрын

    What if my tracking is every other day for business? How do I calculate start mileage?

  • @MrSpreadSheet
    @MrSpreadSheet12 күн бұрын

    Hi, Enter your starting mileage where indicated and expand the table to suit :-)

  • @richhopkins3516
    @richhopkins351613 күн бұрын

    I really like this approach.

  • @MrSpreadSheet
    @MrSpreadSheet13 күн бұрын

    Glad you liked it :-)

  • @bobstephenson3582
    @bobstephenson358214 күн бұрын

    Very helpful. Looking forward to receiving a copy to get started. Thank you.

  • @MrSpreadSheet
    @MrSpreadSheet13 күн бұрын

    Hope you enjoy it!

  • @teredmartin
    @teredmartin15 күн бұрын

    Hi, Great Video, Looking for download link?

  • @MrSpreadSheet
    @MrSpreadSheet14 күн бұрын

    Hi, Downloads are available at www.MrSpreadSheet.com :-)

  • @lukejones52
    @lukejones5216 күн бұрын

    Loved this tutorial! I begin working as a stock controller on Monday, and I believe this spreadsheet will aid me greatly. A quick one: how do I go about entering stock that's on hand?

  • @MrSpreadSheet
    @MrSpreadSheet15 күн бұрын

    Hi, Glad you found it useful. Enter Open Stock with Qty and Average Unit Value :-)

  • @richhopkins3516
    @richhopkins351617 күн бұрын

    please send the inventory spreadsheet

  • @MrSpreadSheet
    @MrSpreadSheet16 күн бұрын

    Hi, Downloads are available at www.MrSpreadSheet.com :-)

  • @murliwale9454
    @murliwale945419 күн бұрын

    ❤❤

  • @MrSpreadSheet
    @MrSpreadSheet18 күн бұрын

    Thanks :-)

  • @ZachDominguez99
    @ZachDominguez9919 күн бұрын

    Great tutorial, is it possible to still have this run correctly if I want the Inventory In and Out section on a different tab?

  • @MrSpreadSheet
    @MrSpreadSheet19 күн бұрын

    Hi, Yes, that should be OK :-)

  • @simonlameck5568
    @simonlameck556820 күн бұрын

    Hi Granddad😀😀😀

  • @MrSpreadSheet
    @MrSpreadSheet19 күн бұрын

    :-)

  • @amandamiller8208
    @amandamiller820823 күн бұрын

    My sales arent coming up red? Any tips?

  • @MrSpreadSheet
    @MrSpreadSheet23 күн бұрын

    Hi, this is a Microsoft anomaly. In some regions like the UK, it works fine. In the USA it does not !

  • @lylig5104
    @lylig510425 күн бұрын

    Thank you so much.

  • @MrSpreadSheet
    @MrSpreadSheet24 күн бұрын

    You're welcome!

  • @Bumface925
    @Bumface92527 күн бұрын

    COULD i HAVE A COPY OF THE FILE SO I CAN USTILISE

  • @MrSpreadSheet
    @MrSpreadSheet26 күн бұрын

    Hi, This is a 'Paid For' product. See mrspreadsheet.com/collections/accounting-spreadsheets for further details :-)

  • @sabrinaw4433
    @sabrinaw443327 күн бұрын

    This has been very helpful. I cannot figure out how to get my "sales" to calculate as a negative. How much is your spreadsheet?

  • @MrSpreadSheet
    @MrSpreadSheet27 күн бұрын

    Hi, Apparently in some regions the Red Minus is not available. It works fine in the UK, but not the States - Microsoft will know why :-)

  • @charlenescholtz3997
    @charlenescholtz399729 күн бұрын

    Please help, I tried it over and over...formula error with D5 payments & receipts column. I have done it exactly as instructions?

  • @MrSpreadSheet
    @MrSpreadSheet28 күн бұрын

    Hi, you can check your work against the original. A download is available at www.MrSpreadSheet.com :-)

  • @27Lawlor
    @27LawlorАй бұрын

    Well paced, clearly explained with an appropriate level of detail. This is a very professional tutorial, thank you

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Glad it was helpful!

  • @marvinchidi851
    @marvinchidi851Ай бұрын

    I want a copy of the spreadsheet please.

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Pls see my previous replies :-)

  • @philipaiston2436
    @philipaiston2436Ай бұрын

    Not sure where I'm going wrong but my C19 keeps giving me the value of 217.34. Great video all the same though!

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Hi, Why not download the finished spreadsheet, then you can check your work against the original. Downloads are available at www.MrSpreadSheet.com :-)

  • @philipaiston2436
    @philipaiston2436Ай бұрын

    Done, thank you!

  • @roberthourie8452
    @roberthourie8452Ай бұрын

    is it possible to add a formula for reaccuring revenue, so the value would be weighted across all months. Thanks a million

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Hi, You could just add another income row for this :-)

  • @KellieRaymond
    @KellieRaymondАй бұрын

    HELP! First, I have to say that your spreadsheet tutorial videos are exactly what I needed. I was handed the books for a "very small" town historical society and was able to watch all 8 videos to create a professional Bookkeeping Spreadsheet. But...I noticed I have an issue with a line or two of expenses not transfering to my report. Should I go back to the COA video and reapply setup from there forward, or should I scrap the spreadsheet and start completely over again? Any help would be greatly appreciated! Thank you!

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Hi, You can download a copy and check your work, follow the instructions on one of the video series :-)

  • @KellieRaymond
    @KellieRaymondАй бұрын

    Thank you!​@@MrSpreadSheet

  • @financial1221
    @financial1221Ай бұрын

    thanks wawwwwwwwwwwwwww

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Thanks to you too ... :-)

  • @tammyadkins3253
    @tammyadkins3253Ай бұрын

    I want to use this month but the formula doesn’t work. I changed the 3 to a 7 but something isn’t working

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Hi, You can check your work against the original, a download is available at www.MrSpreadSheet.com :-)

  • @jey7351
    @jey7351Ай бұрын

    Using for a new job. Thank you

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    That's great - Good Luck with the new job :-)

  • @fhozouri
    @fhozouriАй бұрын

    docs.google.com/spreadsheets/d/1xKkLyEZgau7OGIlYU_xb-gXjQPHwE3QIdRvf_0u_hX4/edit?usp=drivesdk

  • @PaulaNikki
    @PaulaNikkiАй бұрын

    I'm interested in receiving a copy of the spreadsheet, thank you!

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Hi, Downloads are available at www.MrSpreadSheet.com :-)

  • @MunthaSrinivas
    @MunthaSrinivasАй бұрын

    Great Video👌

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Thank you 👍

  • @rexmendoza5751
    @rexmendoza5751Ай бұрын

    Pls send me this spread sheets thanks😂

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Hi, Downloads are available at www.MrSpreadSheet.com :-)

  • @sunxissedone2156
    @sunxissedone2156Ай бұрын

    Excellent step by step instructions. Thank you so much for sharing your knowledge and experience.

  • @MrSpreadSheet
    @MrSpreadSheetАй бұрын

    Glad it was helpful!

  • @rameshacharya6941
    @rameshacharya69412 ай бұрын

    Please make a video with an Alternative unit of measurement for importing Excel to Tally prime 4.0.

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    Thanks, I'll put the request in :-)

  • @wiafeosei4935
    @wiafeosei49352 ай бұрын

    Hello please I need more details about cash book excels

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    Hi, Why not view and follow along the whole series. :-)

  • @tamizimmerman7344
    @tamizimmerman73442 ай бұрын

    Awesome Video!!

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    Glad you enjoyed it :-)

  • @futbolyou4129
    @futbolyou41292 ай бұрын

    I would love a spreadsheet. I love the way you did it

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    You can download a copy at www.MrSpreadSheet.com :-)

  • @MissBlanks19
    @MissBlanks192 ай бұрын

    I would like a copy

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    You can download a copy at www.MrSpreadSheet.com :-)

  • @dionnechandler7836
    @dionnechandler78362 ай бұрын

    All of my total of leave types are working except for 1. My countif formula is correct, however it is not capturing that specific leave type. How can this be fixed!

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    You can download a copy at www.MrSpreadSheet.com and check your work against this :-)

  • @sarahloveri5912
    @sarahloveri59122 ай бұрын

    I'm having problems with the VLOOKUP function? @ 8:50. #N/A is showing in AA6 when tyring to complete the function, any suggestions on how to resolve this please.

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    Hi, You can download a copy of the original. Go to www.MrSpreadSheet.com :-)

  • @sarahloveri5912
    @sarahloveri59122 ай бұрын

    @@MrSpreadSheet Do yo have a resolution to this that i can input myself please.

  • @ambervievescott9936
    @ambervievescott99362 ай бұрын

    Hi, Is this template available, i need this urgently please. Thank you, I have subscribed

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    Hi, Unfortunately this template is not free. Alternatives are available at www.MrSpreadSheet.com. :-)

  • @lauretijani7134
    @lauretijani71342 ай бұрын

    Hey, Thank you so much for the video. The formula didn't work for me at 9:12, but it was the others'. Please, what can be the problem?

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    Hi, You can check your work against the original. A download is available at www.MrSpreadSheet.com :-)

  • @francishubertovasquez2139
    @francishubertovasquez21392 ай бұрын

    Now upon receipt of relevant real time onsite information from AI spaceships into your system modules my space force, as long range communication, while the AI space ships havent arrived yet from Keppler 44 planet, you in connection with the scientists and tech experts of the Caesar King shall simultaneously manufacture and produce several medium sized but larger space ships with human crew as space flotillas tailored to those real time information received, with weaponries and supplies and storages. Prepared and ready to use. Energy to money conversion and from space mining products money of the Caesar King space group fund be channeled to that project with extra fundings for extra unexpected expenses now. Let it be, be sure every space flight tech capability including time speed warp shortcuts be installed into those human crew space ships group. Be sure those space ships to be produced can be covered with energy shields around for protection and for traversing time warp inner content ship time and structured unaltered to prevent quick ageing or receeding of ageing protection if ever or body structure affectation protection like layers of celophane like energy cover from very speedy time warp travel. Clear. Let it be. Be sure to carry with the space ships flotilla as manufactured with them, space ships with space colony creation storage materials and equipments. Because even if the atmosphere in Keppler 44 is identical with planet Earth, we shall blanket the space colonies if ever with breathing compatible enclosed environment while noting for any environmental changes in there if ever. After the space colony in planet Keppler 44 was established if ever, we shall create our modern civilizations in there the next time around. Understood, always improve and be better in knowledge, discoveries and skills. Let it be. Sinira daw. Bugok'! I'm just making into fruition the New Heavens and New Earth. If ever there's a being to remain after things established, that's me, because remember I have an agreement with the Creator to submit for Him for assignments and tasks only if I will have a chicks with me as my reason for agreement because I think the Creator has an open minded mind God. You know after the Omega there's an Alpha or after the end there's a new beginning and a new Adam and Eve without the forbidden fruits this time. Clear. Let it be

  • @accountmb3011
    @accountmb30112 ай бұрын

    Hello! Good day! This can help in our warehouse inventory. Can I ask for a copy? Thank you in advance

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    Hi, Downloads are available from www.MrSpreadSheet.com :-)

  • @zarreen5467
    @zarreen54672 ай бұрын

    Thankyou for this. Its so easy to follow!!! I'm going to watch your other videos too!!

  • @MrSpreadSheet
    @MrSpreadSheet2 ай бұрын

    Enjoy :-)

  • @shuradotsenko3948
    @shuradotsenko39483 ай бұрын

    That is so well explained! I cannot automatically enter positive and negative numbers into the same column... Do you know what is the issue?

  • @MrSpreadSheet
    @MrSpreadSheet3 ай бұрын

    Hi, You can check your work against the original. A download is available at www.MrSpreadSheet.com :-)

  • @saliuazeez4001
    @saliuazeez40013 ай бұрын

    Bravo

  • @MrSpreadSheet
    @MrSpreadSheet3 ай бұрын

    Glad you like it :-)

  • @santutamba1556
    @santutamba15563 ай бұрын

    Thanks well done ✅

  • @MrSpreadSheet
    @MrSpreadSheet3 ай бұрын

    Welcome 👍

  • @kaneezfatimaghanjani722
    @kaneezfatimaghanjani7223 ай бұрын

    Great, informational video.

  • @MrSpreadSheet
    @MrSpreadSheet3 ай бұрын

    Glad it was helpful!

  • @ClarePreston1
    @ClarePreston13 ай бұрын

    Really helpful video! Are there written instructions for the same steps available?

  • @MrSpreadSheet
    @MrSpreadSheet3 ай бұрын

    Hi, Glad you found it useful, there are no written notes, but a free download is available at www.MrSpreadSheet.com :-)

  • @Theyusuf101
    @Theyusuf1013 ай бұрын

    I’m having a problem with the VLOOKUP formula at 8:27, for some reason once I’ve formatted the correct cells the DETAILS selection isn’t being picked up by excel.

  • @MrSpreadSheet
    @MrSpreadSheet3 ай бұрын

    Hi, why not download a copy direct from www.MrSpreadSheet.com, then you can check your work against the original :-)

  • @user-qe1zs1gz3j
    @user-qe1zs1gz3j3 ай бұрын

    I was just getting ready to beg my boss to buy inventory software . . . THANK YOU!!!

  • @MrSpreadSheet
    @MrSpreadSheet3 ай бұрын

    Glad I could help! :-)

  • @nganduchinene247
    @nganduchinene2473 ай бұрын

    great tool.. really helps keep track my products. easy to use and learn. thank you

  • @MrSpreadSheet
    @MrSpreadSheet3 ай бұрын

    Glad you found it useful :-)