🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
@slminc
Жыл бұрын
This one is massive, great one for a developer to flex their muscle!!!!!
@ExcelForFreelancers
Жыл бұрын
OH yes for sure its got so much inside it
@alexrosen8762
Жыл бұрын
Your tutorials are at another level
@ExcelForFreelancers
Жыл бұрын
Thanks so very much Alex. I really do appreciate that and work hard to bring something new each and every week
@Jojosmith342
Жыл бұрын
All Thumbs up as always for Randy - the GREATEST teacher of all time
@ExcelForFreelancers
Жыл бұрын
Thank you so very much, I really appreciate that Tammy. Your support, comments, likes and shares motivate me to do even better :)
@blxcklab
22 күн бұрын
Thank you for imparting your knowledge in all your tutorials.
@ExcelForFreelancers
22 күн бұрын
For sure, you are very welcome and I am glad you enjoyed it
@hislordisaacniiarmah5829
10 ай бұрын
You are a great intelligent guy. What amazes me is how much passion you have for your subscribers. Not only that, you also try your very best to read and reply to almost all comments made from viewers of videos you post. Keep It Up big man. Can you please create an Excel that covers the processes involved in manufacturing and management of sachet and bottle water all combined?
@ExcelForFreelancers
10 ай бұрын
Thank you so very much, I really appreciate that and always try my best. I will add your suggestion to my list and if i get enough suggestions then i will do my best to create that in the future. Thanks again
@Frank-es6oc
10 ай бұрын
The creators of excel themselves never knew it had this power
@ExcelForFreelancers
10 ай бұрын
Haha yes I do believe that. I wonder what they would think if they saw some of my templates
@didinos
6 ай бұрын
To enhance the functionality and address specific requirements in managing raw materials, it's essential to incorporate features that account for LOT numbers and varying shelf life dates. When purchasing raw materials for production, these materials often come with distinct LOT numbers, each associated with different expiration dates. For instance, consider a scenario where you acquire a total of 30 bottles of milk: 20 of these bottles have a shelf life ending in 10 days, while the remaining 10 bottles expire in 15 days. Incorporating the capability to track and manage these details-referred to as traceability - in a next version of your workbooks would significantly enhance its usefulness and efficiency in production management. This improvement would enable more precise tracking of inventory levels, reduce waste, and ensure the optimal use of raw materials based on their expiration dates.
@ExcelForFreelancers
6 ай бұрын
Thank you so very much for your input. I really appreciate that
@slminc
5 ай бұрын
Interesting thought
@user-dm5zn1hs1i
4 ай бұрын
Hi @didinos, I need a file with exactly what you described for our bred mix factory, to be able to track lot number and expiration date. Could you recommend a file who can do that if you know any? Thanks!
@Mullhead_III
Жыл бұрын
Fantastic news. I tried to do a similar thing using some of your other spreadsheets with no luck. Looking forward to this one. Go Randy.
@ExcelForFreelancers
Жыл бұрын
For sure, you are very welcome Matthew and I am happy to bring this to you
@rnunez047
Жыл бұрын
I GUESS IT WILL AMAZING. I CAN NOT WAIT. I can create a list of materials for different construction activities...like a menu 😊😊... but in Spanish Version..🎉
@ExcelForFreelancers
Жыл бұрын
Yes for sure, This template can be modified and customize to fit your own requirements. I hope this helps and thanks so much.
@ExcelForFreelancers
10 ай бұрын
🤖Speed Up Excel Tasks with AI-Powered Solutions ► bit.ly/AIToolpack_Com
@teejhay1675
9 ай бұрын
OMG. I've been struggling so much trying to organize the numbers for my baking business. Thank you so much for this!
@ExcelForFreelancers
9 ай бұрын
For sure, you are very welcome and so happy to help
@teejhay1675
9 ай бұрын
@@ExcelForFreelancers Hi Randy, is there a more comprehensive video about this Bakery Managing Application?
@ExcelForFreelancers
9 ай бұрын
Hi and thanks. This is the only one I have. What area of focus were you looking for?
@sasifexcelsolutions4509
Жыл бұрын
Yes Sir, now we talking
@ExcelForFreelancers
Жыл бұрын
Great, thanks so much. I am sure you will love this one
@timothyadem8354
Жыл бұрын
Randy I love the passion you put in the training
@ExcelForFreelancers
Жыл бұрын
Thanks so much Timothy. I really appreciate that :)
@SyedMuzammilMahasanShahi
Жыл бұрын
Thank you so much Randy for this amazing tutorial.
@ExcelForFreelancers
Жыл бұрын
For sure, you are very welcome Syed and thanks so much for your continued support.
@AlbertKitamirike
Жыл бұрын
You never disappoint, Randy. Thank you so much!
@ExcelForFreelancers
Жыл бұрын
Thank you so very much, I really appreciate that Albert. Thanks for the many years of continued support.
@channelseven3997
Жыл бұрын
Being a retired bakery owner looking forward to it
@ExcelForFreelancers
Жыл бұрын
Awesome, thanks so much. I am sure you are going to love it
@issahabdulhafiz912
Жыл бұрын
Great can't wait still 12.15pm tomorrow insha'Allah. But plz Randy kindly do a template for loan monitor for savings and loan companies
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. It will be great to have you attend the premiere. I do have a Loan Manager here: kzitem.info/news/bejne/1WhvqnmwmndjeY4 I hope this helps and thanks so much.
@slminc
Жыл бұрын
I am going to take all the great features from this one!!!
@ExcelForFreelancers
Жыл бұрын
Awesome Sammy, I am sure you are going to love it. Lots of new features in this one
@slminc
Жыл бұрын
Thank you Randy
@ExcelForFreelancers
Жыл бұрын
For sure, you are very welcome Sammy
@osamasaid8476
Жыл бұрын
you are professional
@ExcelForFreelancers
Жыл бұрын
Thank you so very much, I really appreciate that Osama :)
@ayushpatel782
10 күн бұрын
Thank you for your video. I have 1 request, Please make videos for import export business process
@ExcelForFreelancers
10 күн бұрын
Hi and thanks very much. I will write that down and if i get enough requests for it then I will certainly turn it into a training and template. I hope this helps and thanks so much.
@ayushpatel782
9 күн бұрын
@@ExcelForFreelancers thank you
@jeandemathablaisebouitypoa6716
Жыл бұрын
Thank you very much randy for your trainings I really learn a lot thanks to you
@ExcelForFreelancers
Жыл бұрын
For sure, you are very welcome and happy to help and share
@rabiuahmad2689
10 ай бұрын
Great job🎉❤ Sir, we will like to make videos on how to make students reaults management application for a complete secondary school with dashboard.❤
@ExcelForFreelancers
10 ай бұрын
HI and thanks, yes for sure. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
@justsimplykath
11 ай бұрын
Dang, this is what I needed! Thank you Randy for providing this tutorial! An absolutely great work! 💖
@ExcelForFreelancers
11 ай бұрын
For sure, you are very welcome Katherine, I am really happy to help and share.
@gschultz2010
3 ай бұрын
I'm impressed and new here... Most interested in Manufacturing software... Have used several different Manufacturing software programs in my long career. My question is how to handle "SEMI-FINISHED ITEMS" using this Excel application. For example, a bracket is stamped but needs a couple of weld nuts added and then the item needs to go out to outside processing for plating, come back for final inspection then put to stock awaiting shipping or storage if qty is more than released and mfg'ed using best cost qty... Remember all items manufactured have guaranteed qty release, and arrival date, raw material authorization, and are constantly updated via EDI (daily for "just in time") .. by now you have figured out this is for a metal stamping company making automotive parts. As I am new here, but have some Excel experience what/where do you suggest I start? Also, some finished assemblies have 20 different operations on different machines. Thanks in advance
@ExcelForFreelancers
3 ай бұрын
Hi and thanks so much for your email. Please make sure to watch the full training and download the template if you have not yet. Concerning the status of the manufactured part, you can add a 'Status' field as well as a '% Complete' field for BOM/Assembly Item, along with any other fields you may want to use and track. If you would like some help with this, please feel free to email me with all of your specifications and I can forward it to a qualified developer www.ExcelForFreelancers.com I hope this helps and thanks so much.
@vikrammali5783
6 ай бұрын
Excellent work
@ExcelForFreelancers
6 ай бұрын
Thank you so very much, I really appreciate that
@slminc
Жыл бұрын
I am already flexing my muscles 🏋🏽
@ExcelForFreelancers
Жыл бұрын
Awesome. this is a great template for sure
@joemanflyer2001
2 ай бұрын
I hope people that own these type of businesses use these spreadsheets.
@ExcelForFreelancers
2 ай бұрын
Thank you so very much, I really appreciate that Joe
@rubylove6102
Жыл бұрын
Hello Teacher. I have a questions for you. How can I create a Task Pane using VBA for Excel?
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. I share this with you in this Task Manager training: kzitem.info/news/bejne/t6itrKacg4l_goI I hope this helps and thanks so much.
@alializadeh8195
Жыл бұрын
Thanks so much ... ;)
@ExcelForFreelancers
Жыл бұрын
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
@Calicap91
7 ай бұрын
Amazing!
@ExcelForFreelancers
7 ай бұрын
Thank you so very much, I really appreciate that
@ManiTechCircle
Жыл бұрын
Very very thanks sir. ❤
@ExcelForFreelancers
Жыл бұрын
For sure, you are very welcome and happy to help and share
@philipreed2758
2 ай бұрын
Sir, this is something i have been trying to recreate for ages but for different things, not bakery. i was able to do an inventory, but this level is what im after which i can create sub assemblies and collect assemblies to compile the finished product. my question is, which im struggling with, which cells can i delete so i can put my own components into the sheets, i sort of got it working but it only calculated for the first 3 rows, and i dont know what and where i deleted the wrong cells. i might have to start a fresh and delete the bakery stuff slowly. keep up the amazing work you do.
@ExcelForFreelancers
2 ай бұрын
HI Phillip, thanks for the information. There is no doubt we can help you with that. It would be difficult to answer without looking at your workbook and issues. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
@jaafarjazaerli1344
Жыл бұрын
Now that's great, does it include some tabs for inventory and/or recipe cost calculator?
@ExcelForFreelancers
Жыл бұрын
HI and thanks. yes it does. You can build your own recipes which include food, labor and other costs, so you can know the exact costs, as well as profit margins per item. You can also purchase raw goods, build and sell finish goods and create work orders to build the finished goods from raw goods. I hope this helps and thanks so much.
@jaafarjazaerli1344
Жыл бұрын
@@ExcelForFreelancers awesome, thank you
@coolaidshot3284
Жыл бұрын
Great videos...can you make an excel sheet that records and keeps track of medical inventory supplies so someonecan keep track for reordering?...thank you for what you do!
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much, you can use this training and template to help you kzitem.info/news/bejne/tWN9raaQsYeapII Thank you for your Likes, Shares & Comments. It really helps.
@foryoutube464
Жыл бұрын
Amazing System for the bakery. If you can share with us photos of the bakery items as your file i much appreciate.
@ExcelForFreelancers
Жыл бұрын
HI and thanks very much. All pictures, resources, icons, and files for this training are available on our Patreon site here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
@khwezzd1573
4 ай бұрын
Wow ❤wow❤wow😊😊😊
@ExcelForFreelancers
4 ай бұрын
Thank you so very much, I really appreciate that
@temyraverdana6421
Жыл бұрын
WOW!
@ExcelForFreelancers
Жыл бұрын
Thanks so much Temyra, I am sure you are going to love it. Thanks again
@BrandCJC
Жыл бұрын
Really great, is going to work so nice for my wife and her little cookie business. I also learned so much. If I may give one (hopefully constructive) criticism Is there a way to make the currency symbol a admin value to make sure it's more international? (I know I should rebuild the complete project to learn, but why mess with near perfection? ;) )
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. I am glad you enjoyed it. There is no need to change much. On the cells with amounts, you can change the currency to any currency you want using the format option. I hope this helps and thanks so much.
@CPfaith
11 ай бұрын
Your videos are amazing. If I follow your instructions would I be able to create a similar workable sheet that I can use for a cottage (home based) business?
@ExcelForFreelancers
11 ай бұрын
Yes for sure you can. You should be able to apply the techniques to any type of business. I hope this helps and thanks so much.
@kokog5690
20 күн бұрын
Thank you so much. Been looking for how to do this. Please how can i reach out to you directly via email? Is it possible also to make these software mobile responsive for users?
@ExcelForFreelancers
20 күн бұрын
Hi and thanks very much. There is a way to create a mobile component that syncs with this using Appsheet. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
@rsiddique1584
Жыл бұрын
Please sir provide the couse basic to advance please sir i requests to you please sir and please use language in hindi and english both please sir
@ExcelForFreelancers
Жыл бұрын
Hi and thanks, each of my videos have Hindi subtitles and many of them are from scratch. I hope this helps and thanks so much.
@CSenPowerBI
11 ай бұрын
Sir Can You update this as per my requirement as 1) Fixed BOM for specific Product Type but some time there will be changed Fixed BOM items as per product type configuration then new raw items added from Inventory receipt Register. 2) As per Sales order of finished placed by customers then automatically inventory of Raw goods automatically updated i.e mean Stock out in corresponding BOM . 3) When Sales order completed i.e mean put a specific date then automatically new BOM generated as per finished goods of sales order
@ExcelForFreelancers
11 ай бұрын
Hi and thank you for your comment. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
@saekokyoyama6087
Жыл бұрын
Hello! What's the difference between the BOM items sheet and the Raw Goods sheet? I haven't seen any new videos pertaining to it, so I'm a little confused. Thanks for your time. Love your videos.
@saekokyoyama6087
Жыл бұрын
Never mind, I watched your POS with inventory video, and it pretty much cleared up my confusion. Thanks!
@ExcelForFreelancers
Жыл бұрын
Hi and thanks, yes I am glad you were able to get it cleared up. The Raw Goods are components that make up the BOM's or completed food items. I have another video on BOM's that you may find helpful here: kzitem.info/news/bejne/xZyDyZyDbKWFoGk I hope this helps and thanks so much.
@ahmedmamdouhlabib4885
Жыл бұрын
I want to learn how to make an accounting program for restaurants or a factory like the application that I made in the video with a warehouse system according to first in first out or weighted average with calculating deviations between the actual and estimated cost. Is this course available to you, Mr. Randy?
@ExcelForFreelancers
Жыл бұрын
Hi and thanks very much. You can learn how to make a full-scale accounting application in my Mentorship program here www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/ I hope this helps and thanks so much.
@Sandeesh_Srikantam
Жыл бұрын
Can you make one for personal finance/investments ?
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. I have lots of videos on personal finance. Feel free to to search my 'Finance Tracker', 'Mini Accounting Application', 'Expense Manager' etc. I hope this helps and thanks so much.
@Sandeesh_Srikantam
Жыл бұрын
@@ExcelForFreelancers I have seen this playlist of yours (kzitem.info/door/PLIBeRriXvKzABwGJExnwbcVusKM44ALC1), but there isn’t one that helps us TRACK personal investments like stocks, bonds, mutual funds etc. it would be great if you can make one for that purpose. Let me stress that the purpose is to TRACK THE PERFORMANCE OF THE INVESTMENTS rather than calculating the latest values.
@ExcelForFreelancers
Жыл бұрын
Hi and thanks. Yes now i understand with the additional details. I will add it to my list of future videos and try to complete that in the near future
@Sandeesh_Srikantam
Жыл бұрын
@@ExcelForFreelancers thats great ! I would be waiting !!
@user-gu4rb1eb2s
9 ай бұрын
How would you integrate barcode/QR Codes into this? I use a large amount of products in my MFG so looking up each item would take a lot of time and I might not pick the correct item if I have to manually search for it.
@ExcelForFreelancers
9 ай бұрын
Hi and thanks very much. A barcode scanner is nothing more than a keyboard interface, so it would act just as if you were entering the numbers yourself. I have a training on that here: kzitem.info/news/bejne/rnptzpZnm5mah3Y I hope this helps and thanks so much.
@slminc
Жыл бұрын
💪🏼
@ExcelForFreelancers
Жыл бұрын
Thanks so much @Slminc, I am sure you will love it
@slminc
Жыл бұрын
Bang🎉🎉🎉🎉🎉🎉🎉🎉
@ExcelForFreelancers
Жыл бұрын
Thanks so much :)
@vikneswarymohan1575
10 ай бұрын
Hi Randy! Thank you so much for coming up with this. I have downloaded the template, but i've encountered an issue. While on the BOM Assemblies tab, I attempted to select an item to add to the finished product. However, I received an error message that reads: "Run-time error '-2147024809 (80070057)': The item with the specified name wasn't found." This problem only occurs when I choose "raw goods" and "finished product" from the "view item type" dropdown menu. The "other costs" option works perfectly fine. May i know how to solve this issue please? Thank you !
@ExcelForFreelancers
10 ай бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@hakim8400
8 ай бұрын
Amazing system, how to add the new raw goods item?
@ExcelForFreelancers
8 ай бұрын
Hi and thanks so much. You can add any items you want to the item sheet database. I hope this helps and thanks so much.
@hakim8400
8 ай бұрын
Are there any links for me to learn about macro and VBA for creating data input? Thank you!@@ExcelForFreelancers
@ExcelForFreelancers
8 ай бұрын
Hi and thanks very much. You can check out this training Hakim: kzitem.info/news/bejne/yaxpr2FqhV-ZiqA I hope this helps and thanks so much.
@user-xi9sj4wc2g
10 ай бұрын
Hello Randy, I keep running into issues with "ItemPic" in the developer saying there's a bug. I'm guessing it's because I don't have the Picture folder you have? How can I atach my own/
@ExcelForFreelancers
10 ай бұрын
HI and thanks, yes that would mean you would want to make sure that the full picture path (in vba) matches the full picture path on your computer. If there is any issue with this path then an error would appear. I do explain this within the video so you may need to watch it again. I hope this helps and thanks so much.
@hakim8400
8 ай бұрын
I want to ask again. I tried to add chocolate cake to the work order and the status of the working order is Completed but it doesn't change the raw material's quantity on hand. How to solve that? Thank You!
@ExcelForFreelancers
8 ай бұрын
Hi Hakim, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@eliastafese3790
Жыл бұрын
I have difficult in remain products when I purchased and sales help me sir from Africa
@ExcelForFreelancers
Жыл бұрын
Hi and thanks make sure you are properly summing all of the purchased products, based on the product ID and then subtracting all of those that are sold. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@SamuelTamiru-fm5ju
Ай бұрын
Link to download the work book not working
@ExcelForFreelancers
Ай бұрын
Hi If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
@noraaplor8366
4 ай бұрын
I do love your templates and skills , If I was a girl and living in your country I will find and marry you 😂
@ExcelForFreelancers
4 ай бұрын
LOL, Thanks so very much. Your comment made me laugh out loud. I am so happy to help and share :) :)
@jonathanandreoni60
7 ай бұрын
Is this particular template for sale?
@ExcelForFreelancers
7 ай бұрын
Hi Jonathan, you can download this file for free using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@alebiosukunle6794
Жыл бұрын
Hi, thanks so much for the video.. have you dropped any more video on the remaining tabs yet also how would the stock reduce when sales order or work orders are made as I do not think the template is handling that yet
@ExcelForFreelancers
Жыл бұрын
Hi and thanks. Yes you can check this training out for that, where I go into more detail kzitem.info/news/bejne/xZyDyZyDbKWFoGk I hope this helps and thanks so much.
@picturetellseverything4051
8 ай бұрын
Can I get its template sir please
@ExcelForFreelancers
8 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@AraRoodbuik
Жыл бұрын
How come you use a comma (,) in your formulas and I have to use a Semicolon (;) instead?
@ExcelForFreelancers
Жыл бұрын
Hi and thanks for your comment. In many countries, including the United States, the comma is used as the decimal separator, whereas the semicolon is used as a list separator. On the other hand, in several European countries, such as Germany and France, the situation is reversed, with the decimal point represented by a period and the semicolon serving as the list separator. When it comes to formula syntax in Excel, the choice of separator depends on the regional settings of the user's computer. Excel adapts to these settings and uses the appropriate separator accordingly. This means that if your Excel version is set to use commas as the list separator, you will likely see semicolons being used to separate arguments within formulas. It's worth noting that regardless of the separator used, Excel's formulas and functions remain the same in terms of their structure and functionality. The choice of separator is mainly a formatting convention that ensures compatibility and consistency within specific language and regional contexts. If you prefer to use a different separator in your Excel version, you can adjust the language and regional settings in your computer's control panel or Excel's options menu to reflect your preference.
@AraRoodbuik
Жыл бұрын
@@ExcelForFreelancers Do these rules also apply when writing a Macro or VBA or is writing a Macro or VBA a Comma the standard no matter what country one lives in? In my case, Dutch-speaking Belgium.
@ExcelForFreelancers
Жыл бұрын
I believe this is something that you can do research on to learn more
@privategun
6 ай бұрын
How to download this free template?
@ExcelForFreelancers
6 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@user-xu1jc8ob7h
Жыл бұрын
من فضلك ساعدني كيف اربط ملف اكسل بجوجل درايف من الهاتف وتتحدث بيانات تلقائيا
@ExcelForFreelancers
Жыл бұрын
HI and thanks very much, you can use this training: kzitem.info/news/bejne/zWuC3XulqYuEoaA I hope this helps and thanks so much.
@idrismzzm1
10 ай бұрын
Hi i want this file please for my businees use
@ExcelForFreelancers
10 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Пікірлер: 140