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
Пікірлер
This was great! Thank you so much. God bless you
Glad it was helpful!
Please i need a copy
Hi, downloads are available at www.MrSpreadSheet.com :-)
define name is block so I can't make it
Hi, You may be using the cloud/mobile version of Excel which has a number of similar limitations :-)
What if my tracking is every other day for business? How do I calculate start mileage?
Hi, Enter your starting mileage where indicated and expand the table to suit :-)
I really like this approach.
Glad you liked it :-)
Very helpful. Looking forward to receiving a copy to get started. Thank you.
Hope you enjoy it!
Hi, Great Video, Looking for download link?
Hi, Downloads are available at www.MrSpreadSheet.com :-)
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?
Hi, Glad you found it useful. Enter Open Stock with Qty and Average Unit Value :-)
please send the inventory spreadsheet
Hi, Downloads are available at www.MrSpreadSheet.com :-)
❤❤
Thanks :-)
Great tutorial, is it possible to still have this run correctly if I want the Inventory In and Out section on a different tab?
Hi, Yes, that should be OK :-)
Hi Granddad😀😀😀
:-)
My sales arent coming up red? Any tips?
Hi, this is a Microsoft anomaly. In some regions like the UK, it works fine. In the USA it does not !
Thank you so much.
You're welcome!
COULD i HAVE A COPY OF THE FILE SO I CAN USTILISE
Hi, This is a 'Paid For' product. See mrspreadsheet.com/collections/accounting-spreadsheets for further details :-)
This has been very helpful. I cannot figure out how to get my "sales" to calculate as a negative. How much is your spreadsheet?
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 :-)
Please help, I tried it over and over...formula error with D5 payments & receipts column. I have done it exactly as instructions?
Hi, you can check your work against the original. A download is available at www.MrSpreadSheet.com :-)
Well paced, clearly explained with an appropriate level of detail. This is a very professional tutorial, thank you
Glad it was helpful!
I want a copy of the spreadsheet please.
Pls see my previous replies :-)
Not sure where I'm going wrong but my C19 keeps giving me the value of 217.34. Great video all the same though!
Hi, Why not download the finished spreadsheet, then you can check your work against the original. Downloads are available at www.MrSpreadSheet.com :-)
Done, thank you!
is it possible to add a formula for reaccuring revenue, so the value would be weighted across all months. Thanks a million
Hi, You could just add another income row for this :-)
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!
Hi, You can download a copy and check your work, follow the instructions on one of the video series :-)
Thank you!@@MrSpreadSheet
thanks wawwwwwwwwwwwwww
Thanks to you too ... :-)
I want to use this month but the formula doesn’t work. I changed the 3 to a 7 but something isn’t working
Hi, You can check your work against the original, a download is available at www.MrSpreadSheet.com :-)
Using for a new job. Thank you
That's great - Good Luck with the new job :-)
docs.google.com/spreadsheets/d/1xKkLyEZgau7OGIlYU_xb-gXjQPHwE3QIdRvf_0u_hX4/edit?usp=drivesdk
I'm interested in receiving a copy of the spreadsheet, thank you!
Hi, Downloads are available at www.MrSpreadSheet.com :-)
Great Video👌
Thank you 👍
Pls send me this spread sheets thanks😂
Hi, Downloads are available at www.MrSpreadSheet.com :-)
Excellent step by step instructions. Thank you so much for sharing your knowledge and experience.
Glad it was helpful!
Please make a video with an Alternative unit of measurement for importing Excel to Tally prime 4.0.
Thanks, I'll put the request in :-)
Hello please I need more details about cash book excels
Hi, Why not view and follow along the whole series. :-)
Awesome Video!!
Glad you enjoyed it :-)
I would love a spreadsheet. I love the way you did it
You can download a copy at www.MrSpreadSheet.com :-)
I would like a copy
You can download a copy at www.MrSpreadSheet.com :-)
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!
You can download a copy at www.MrSpreadSheet.com and check your work against this :-)
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.
Hi, You can download a copy of the original. Go to www.MrSpreadSheet.com :-)
@@MrSpreadSheet Do yo have a resolution to this that i can input myself please.
Hi, Is this template available, i need this urgently please. Thank you, I have subscribed
Hi, Unfortunately this template is not free. Alternatives are available at www.MrSpreadSheet.com. :-)
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?
Hi, You can check your work against the original. A download is available at www.MrSpreadSheet.com :-)
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
Hello! Good day! This can help in our warehouse inventory. Can I ask for a copy? Thank you in advance
Hi, Downloads are available from www.MrSpreadSheet.com :-)
Thankyou for this. Its so easy to follow!!! I'm going to watch your other videos too!!
Enjoy :-)
That is so well explained! I cannot automatically enter positive and negative numbers into the same column... Do you know what is the issue?
Hi, You can check your work against the original. A download is available at www.MrSpreadSheet.com :-)
Bravo
Glad you like it :-)
Thanks well done ✅
Welcome 👍
Great, informational video.
Glad it was helpful!
Really helpful video! Are there written instructions for the same steps available?
Hi, Glad you found it useful, there are no written notes, but a free download is available at www.MrSpreadSheet.com :-)
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.
Hi, why not download a copy direct from www.MrSpreadSheet.com, then you can check your work against the original :-)
I was just getting ready to beg my boss to buy inventory software . . . THANK YOU!!!
Glad I could help! :-)
great tool.. really helps keep track my products. easy to use and learn. thank you
Glad you found it useful :-)