Array Formulas in Excel are Awesome!
11:24
Пікірлер
@RMCO9809
@RMCO9809 2 күн бұрын
What happens if the trial Balance gets mixed accounts? Let’s say you have 1.1, 1.2, 1.2, 1.1, 1.2 etc…
@AlexLunnar
@AlexLunnar 2 күн бұрын
Really Good. Thanks buddy!
@JoeySunio
@JoeySunio 7 күн бұрын
This does not work in Work environment when there is policy in place to not use the USB ports due to security
@MintyAnalyst
@MintyAnalyst 7 күн бұрын
Hey Joey, thanks for sharing this important bit of information. Hadn't thought to check it on my company computer, so thanks for sharing!
@Drivenby
@Drivenby 10 күн бұрын
You have big hands bro . That keyboard looks tiny
@MintyAnalyst
@MintyAnalyst 10 күн бұрын
It is definitely tiny, even for my wife's smaller hands. But it still types amazingly!
@Drivenby
@Drivenby 8 күн бұрын
@@MintyAnalyst I just got the keyboard yesterday and I agree . It’s small but the keys are just at the right depth and they are clicky enough to be super satisfying . I am having a great time . I have been typing on it for like. 6 hours so far today. Very happy with my purchase !
@MintyAnalyst
@MintyAnalyst 7 күн бұрын
Glad you like it. Kinda sucks we just got those and now there's a new remarkable with all new accessories, but it is what it is I guess 😅
@Drivenby
@Drivenby 7 күн бұрын
@@MintyAnalyst enjoy what you have! Don’t worry about what you don’t! There’s always something next time!
@MintyAnalyst
@MintyAnalyst 7 күн бұрын
@@Drivenby honestly, I don't care about the larger display or the color screen of the new remarkable, but the backlight is a game-changer, I've dreamt about it since I got the rm2 😅
@kenroberts71
@kenroberts71 11 күн бұрын
Awesome video for a super quick fix. One word of warning. On my kindle white there is a screw under the black sticky strip on the top which is the only one that is not shown being removed in the video. I ended up cracking the bottom case as I worked the screen out because I thought there was just a stuck part that needed more prying but it was the screw. It wasn't a big deal, the kindle sits in a case. The replacement worked perfectly. The kindle works as good as new now.
@MintyAnalyst
@MintyAnalyst 10 күн бұрын
Hey, thanks for the warning! I don't remember having such a screw in this paperwhite... however, I don't know where it is (it ended up breaking again and I replaced it) so I can't check for it.
@savarapu
@savarapu 12 күн бұрын
Incredible video! Thank you. What's the prototyping tool you use at the beginning please?
@MintyAnalyst
@MintyAnalyst 10 күн бұрын
Thanks, means a lot! The tool is called Excalidraw and it's completely free if you store projects locally (excalidraw.com/)
@arslan_TM
@arslan_TM 14 күн бұрын
Dobromir, by any chance do you have anything to share on preparing a feasibility report (i.e for retail business from financial perspective)
@MintyAnalyst
@MintyAnalyst 10 күн бұрын
Unfortunately, I have no experience in retail, so nothing valuable to share, apart from reading online and regurgitating the same content, which makes little sense.
@arslan_TM
@arslan_TM 14 күн бұрын
Thanks for sharing valuable insights 😊
@MintyAnalyst
@MintyAnalyst 10 күн бұрын
Glad it was helpful! 😊
@murarithakur3377
@murarithakur3377 18 күн бұрын
How to make financial statements from trial balance of a really large company say like Amazon
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
I would assume they follow a similar approach. Perhaps, in a more complex scenario (e.g. a large public company), you will have a lot more analytical dimensions within accounts, so you might have to export various breakdowns and additional data to build the FS. However, the largest companies I've worked with (way smaller than Amazon, but in the hundreds of millions in revenue) have had automations in their ERPs where a combination of predefined mappings and strict journal entry controls resulted in the FS being pretty much automatically populated (with the exception of some disclosures and more specialized adjustments). However, the concept of mapping a detailed breakdown to a more aggregated view is always the same. Hope this helps 😊
@Charles-yq8vv
@Charles-yq8vv 24 күн бұрын
spam, you're writing spam.
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
If you copy-paste my scenario, leave the short generic prompts, and publish the first generation with zero editing, then it's exactly that. BUT, if you spend the time to craft the right prompts, and then spend the time to review and edit the generated text, I don't think it's spam, it's just a great time-saving tool.
@Charles-yq8vv
@Charles-yq8vv 16 күн бұрын
@@MintyAnalyst Very much disagree, but that hardly matters.
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
@Charles-yq8vv I get what you mean, but at the end of the day, AI is here to stay, so we either adapt or we get left behind
@Charles-yq8vv
@Charles-yq8vv 16 күн бұрын
@@MintyAnalyst The reality is that AI-generated content simply isn't very useful in at least most B2B marketing programs. You need to be much sharper, better targeted, and informative that AI is capable of. It'll frankly never get there. Not sure about B2C, it may be different.
@vijiind
@vijiind Ай бұрын
good one
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
Thank you! Cheers! 😊
@MaximilianFeichtinger
@MaximilianFeichtinger Ай бұрын
Extremely useful 🤯
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
Glad it was helpful! 😊
@hoangthuaduy4864
@hoangthuaduy4864 Ай бұрын
Awesome!! Excellent explanation.. This is exactly I was looking for. Thank you so much for the video!!
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
Glad it was helpful! 😊
@doggydoggywho
@doggydoggywho Ай бұрын
Please dont add music
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
Quite annoying in this one, I agree... but time has passed, I've gotten better (or at least I hope so!)
@JohnnyMonge
@JohnnyMonge Ай бұрын
Hi! It is any reason why the sales volume present negatives results, I followed the instruccions but it still happens. Thank you.
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
Hi, not sure what is happening, perhaps you mistyped the formula, or forgot/added another - sign? It shouldn't come out negative in this scenario.
@2MRSTARZ
@2MRSTARZ Ай бұрын
Whatsapp wiz😎
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
Heh, thanks! 😊
@delllow1
@delllow1 Ай бұрын
I love this, but what if I already have an outline. How would I start this process from the outline?
@MintyAnalyst
@MintyAnalyst 16 күн бұрын
just start from the step where the outline is being fed to the AI. You can save your outline in Google Docs or Sheets and load it from there, the same way we are adding a topic in the beginning here.
@delllow1
@delllow1 12 күн бұрын
@@MintyAnalyst Sweet, that makes perfect sense now that you have explained it.
@theprodigy4202
@theprodigy4202 Ай бұрын
"...with One Click" my a$s 😄😠😑🤡
@MintyAnalyst
@MintyAnalyst Ай бұрын
Well, it takes a lot of pre-work and prompt fine-tuning, but once you have those, it's literally one click 🧑‍💻
@hammadyounas2688
@hammadyounas2688 Ай бұрын
How can you create (Created Date and Time) and Last modified
@MintyAnalyst
@MintyAnalyst Ай бұрын
You have such fields as pre-defined options in Airtable. Add them there, and they will auto-populate and auto-update.
@hammadyounas2688
@hammadyounas2688 Ай бұрын
@@MintyAnalyst thanks. I have paste my problem i am solving can you please help me with that?
@MintyAnalyst
@MintyAnalyst Ай бұрын
@@hammadyounas2688 not sure what you mean, where have you posted it?
@hammadyounas2688
@hammadyounas2688 Ай бұрын
@@MintyAnalyst you have replied there. My problem of proposal writing.
@hammadyounas2688
@hammadyounas2688 Ай бұрын
Great Video. I am working on same problem of Generating Proposals. I have different prompt in airtable, based on that prompt the ChatGPT generates the Output. One thing is that i want to fallback that if some section is not well written we will write it again. Can we do that?
@MintyAnalyst
@MintyAnalyst Ай бұрын
I've faced similar issues, so I know what you mean... AI is not always good in the generations. For my scenarios, I either review generations manually, or I have another ChatGPT prompt that asks the AI to review and let me know if it looks good. I give it a few examples of good generations and ask it to respond Yes/No if the generation looks okay. You can then save this Yes/No and use it to mark the ones that need further work. I hope this helps 😊
@hammadyounas2688
@hammadyounas2688 Ай бұрын
@@MintyAnalyst great can you help me with that? Basically i have column in airtable in which i write please modify the response of prompt 5. But i am unable to update the results. Can i share my example and blueprint, i am stuck in this problem. if you have any linkedin Id?
@MintyAnalyst
@MintyAnalyst Ай бұрын
If there's a more generic question you have, you can ask it here, where others may benefit from the discussion. Other than that, unfortunately, I won't be able to review your blueprint and provide detailed help.
@hammadyounas2688
@hammadyounas2688 Ай бұрын
@@MintyAnalyst ohh but here i am unable to attached image and other things.
@hammadyounas2688
@hammadyounas2688 Ай бұрын
@@MintyAnalyst let me explain the whole . I have airtable in which i am generating whole sales propsal. I have 10 columns for prompt like prompt 1 prompt 2 ,,,, prompt 10 . In which i am writting instruction for chatGPT to generate specific section like intruction background etc. I have succesfully create whole sales proposal. But one issue i am facing that if user review manually and in Column ' Need revision ' he write generate response of prompt 3 again. Then how can i generate that response and update it with already created sales proposal.
@Harrakirii666
@Harrakirii666 Ай бұрын
So its a autoclicker right
@MintyAnalyst
@MintyAnalyst Ай бұрын
Essentially, yes!
@haroldperry7783
@haroldperry7783 Ай бұрын
Excellent detailed OPS. I am experimenting as well 😌 to develop a shorter string. My errors result in double subject text. I will apply some Op changes, as seen in your string to hopefully eliminate my errors. Awesome mentor 😎!
@MintyAnalyst
@MintyAnalyst Ай бұрын
Hey, thanks, I am happy the video was helpful! Good luck with your experiments! 😊
@Antoaprende
@Antoaprende Ай бұрын
Hi, very interesting and thanks for the explanation. How do you incorporate a seed so that the results can be replicated by another person?
@MintyAnalyst
@MintyAnalyst Ай бұрын
There's no real way to incorporate a seed with random functions in Excel (at least that I know of). What I would do is adjust the script so that all the random values are also saved in separate columns. But even then, recreating it would require more work. For example, the user would have to use another script that runs the simulations using the stored random values instead of generating new ones.
@eubrunomiau
@eubrunomiau 2 ай бұрын
Amazing, the best example I've seen in YT!!
@MintyAnalyst
@MintyAnalyst Ай бұрын
Wow, thanks! 😊
@gowinfinance
@gowinfinance 2 ай бұрын
Thanks for such a complete, detailed and clearly outlined valuble content and tools.
@MintyAnalyst
@MintyAnalyst Ай бұрын
Thanks! Glad it was helpful! 😊
@arslan_TM
@arslan_TM 2 ай бұрын
This is really helpful, thank for sharing valuable things
@MintyAnalyst
@MintyAnalyst Ай бұрын
Thank you, Arslan 😊
@marcosflaviopaim
@marcosflaviopaim 2 ай бұрын
It's hard to find a tutorial so well explained. Congrats! I've learned a lot. Thank you for sharing!
@MintyAnalyst
@MintyAnalyst Ай бұрын
Glad it was helpful!😊
@BrandonJenkins-yy3xq
@BrandonJenkins-yy3xq 2 ай бұрын
Thanks! Subbed!
@MintyAnalyst
@MintyAnalyst Ай бұрын
Thanks for the sub, it means a lot 😊
@arslan_TM
@arslan_TM 2 ай бұрын
Great video, thanks sir for sharing
@MintyAnalyst
@MintyAnalyst Ай бұрын
You are welcome 😊
@johndurran614
@johndurran614 2 ай бұрын
Excellent - is there an example file to download?
@MintyAnalyst
@MintyAnalyst Ай бұрын
No, sorry, I was just messing around in Excel and decided to share some information 😅
@johndurran614
@johndurran614 2 ай бұрын
Excellent - is there a sample file to download?
@MintyAnalyst
@MintyAnalyst Ай бұрын
No, sorry, I was just messing around in Excel and decided to share some information 😅
@Maximus18.6
@Maximus18.6 2 ай бұрын
First of all you are a genius, you explained excellent how to implement Monte Carlo simulation, what statistical simulations are appropriate for every case in an income statement, you explained macros, and you presented the exact application of Monte Carlo simulation. By far this video is the best on the web, you did it better than many 500 pages books with theory. Amasing video and thanks so much. It will be interesting if you could prepare similar video but using Python programming.
@MintyAnalyst
@MintyAnalyst Ай бұрын
Wow! Thanks for the high praises, it means a lot! I am happy you found the video useful. As for a python version, it's not my strong suit, so I need to do some research, but it sounds like a cool video idea! 😊
@JonathanLyon
@JonathanLyon 2 ай бұрын
is it possible to dynamically allocate the user to a frontly user group upon payment? This would allow pages to be designated to specific user groups such as Paid or Trial user groups rather than using dynamic hiding and showing of pages based on custom variables?
@MintyAnalyst
@MintyAnalyst Ай бұрын
I am not sure if you can do it directly with the Frontly User Groups (you should be able to, but haven't tried it). However, you can always link a Users sheet and have the assigned groups there and then use that to show/hide pages.
@amitchauhan562
@amitchauhan562 2 ай бұрын
This was explained in a very simple manner.
@MintyAnalyst
@MintyAnalyst 2 ай бұрын
Thanks, glad it was helpful :)
@mehmetcanarslan134
@mehmetcanarslan134 2 ай бұрын
Thank you sir good content
@MintyAnalyst
@MintyAnalyst 2 ай бұрын
Any time ;)
@2MRSTARZ
@2MRSTARZ 2 ай бұрын
I can't believe I hadn't seen this slipped from my feed haha sup wiz
@MintyAnalyst
@MintyAnalyst 2 ай бұрын
for some reason, not many people saw this one, and for me, it's a really interesting way of combining automation with manual work to speed up a process :) hope you liked it 😅
@2MRSTARZ
@2MRSTARZ 2 ай бұрын
@@MintyAnalyst yeah it's great man great work really !!
@gollumarx
@gollumarx 2 ай бұрын
Very nice video, but the music is actually a bit distracting, it comes just as noise to me
@MintyAnalyst
@MintyAnalyst 2 ай бұрын
Sorry about that, trying to be better at audio design in my newer videos :)
@chrisder1814
@chrisder1814 2 ай бұрын
great
@MintyAnalyst
@MintyAnalyst 2 ай бұрын
Thanks a lot, glad you enjoyed it :)
@chrisder1814
@chrisder1814 Ай бұрын
@@MintyAnalyst Hello, I had some ideas to automate SEO and also for automatic image editing but I don't know if these ideas are good and I would have liked you to tell me what you think, could I send you an email?
@MintyAnalyst
@MintyAnalyst Ай бұрын
I am not really into SEO, so not sure I can be of any help here :)
@chrisder1814
@chrisder1814 Ай бұрын
@MintyAnalyst I had thought about automation ideas, for SEO or even image processing
@adityachauhan9545
@adityachauhan9545 3 ай бұрын
What software did you use to create this addin? VSTO or direct vba XLAM or Yeoman generator?
@MintyAnalyst
@MintyAnalyst 3 ай бұрын
Hey there, I created the add-in with VSTO and VB.net, and the distributable setup is created with the ClickOnce publishing option.
@TerenceKearns
@TerenceKearns 3 ай бұрын
I need it to be free. Tooljet is free.
@arslan_TM
@arslan_TM 3 ай бұрын
So RIP to web/app developers ?
@MintyAnalyst
@MintyAnalyst 3 ай бұрын
Hey Arslan, I don't really think so. I believe devs will just pivot from writing code to interacting with AI to build things faster and better. At the end of the day, if you are building something complex, you still need to be an actual dev and understand how things should work, even if the AI is writing the actual code.
@traitpichardo2046
@traitpichardo2046 3 ай бұрын
Suppp dude 😎
@MintyAnalyst
@MintyAnalyst 3 ай бұрын
Hey, welcome to the channel 👋
@DamienOhTomation
@DamienOhTomation 3 ай бұрын
Hello, I just want to select a single youtube video but not the whole channel, do you know how to do this?
@MintyAnalyst
@MintyAnalyst 3 ай бұрын
I don't think Make supports selecting a specific video. If you use their new KZbin integration instead of the RSS feed, you can limit the selection to 1 video, but I don't think you can point to the exact video.
@emmanuelarinze2251
@emmanuelarinze2251 3 ай бұрын
You are a good man! 3:30 am and I'm happy as a hobbit with a habit! Thanks!
@MintyAnalyst
@MintyAnalyst 3 ай бұрын
Thanks for the comment, I'm glad you like the video 😊
@tonyblack2141
@tonyblack2141 3 ай бұрын
Very well put, Dobromir. I'm a Citizen Developer (by your definition) as I come from a finance background, but my quest to develop web-based calculators for my target audience led me down this path to finally find Frontly. As for professional developers, I believe they would still find benefit in No-code tools as they can use it as a way to test MVP ideas before going full on to build out the viable product.
@MintyAnalyst
@MintyAnalyst 3 ай бұрын
Hey Tony, yep, I fully agree. My background is also in finance, and no-code has given me so much additional freedom to automate and build, but at the same time, AI is getting so good at writing code, I want to see where it goes in the next year 😊 And seeing how fast a tool like Frontly is evolving, it really gets me excited for the future and what non-programmers like us will be able to build 🤖
@elibogdanova
@elibogdanova 3 ай бұрын
This is a super helpful course that explains in so many details how to build your model even if you have no experience in such models. It is extremely useful for both finance professionals and non-professionals.
@MintyAnalyst
@MintyAnalyst 3 ай бұрын
Thanks Eliana, glad you like it! 🤠
@frontlyapp
@frontlyapp 3 ай бұрын
Awesome! 👏
@MintyAnalyst
@MintyAnalyst 3 ай бұрын
Thanks 😊