The AI-powered Formula Generator: Revolutionizing Excel Formulas
As we navigate the complexities of business and finance, having the right tools at our disposal can make all the difference. One such tool that has been making waves in the productivity world is an AI-powered formula generator. This innovative technology allows users to transform their text instructions into Excel formulas with ease, saving time and increasing efficiency.
The AI Formula Generator: A Game-Changer for Excel Users
Imagine having the ability to convert even the most complex Excel formulas into a single, intuitive command. The AI Formula Generator makes this possible, utilizing advanced algorithms and machine learning techniques to decipher even the most intricate formulas. This tool is designed to assist users in their daily tasks, from creating simple formulas to more complex ones that require regular expressions and conditional statements.
For those who may not be familiar with Excel or formula creation, this technology is a game-changer. It's like having a personal assistant at your fingertips, capable of understanding your needs and providing solutions. With the AI Formula Generator, users can focus on what matters most – running their businesses successfully.
Example: Transforming Financial Reports into Efficient Formulas
Let's take a look at an example of how this technology is being used in real-world applications. A YouTube creator was struggling to calculate their financial costs, particularly when it came to editing and thumbnail design. They wanted to create a formula that would automatically adjust for the editor's rate and hours worked. With the AI Formula Generator, they were able to input their requirements and generate an efficient formula.
The creator hit "Generate" and specified that the formula should be applied to columns A and B, with the result outputting in column G, row 2. The tool took this information and created a complex if-structure formula that accurately reflected the creator's needs. This formula was then copied down across all rows, ensuring consistency and accuracy.
The Benefits of Using the AI Formula Generator
This technology is not just limited to financial reports; it can be applied to any Excel-based task. By automating tedious calculations, users can free up more time to focus on high-level decision-making. The benefits are numerous:
* Increased efficiency: With the ability to generate complex formulas quickly and accurately, users can save hours of time.
* Improved accuracy: The AI Formula Generator reduces errors, ensuring that calculations are accurate and reliable.
* Enhanced productivity: By automating routine tasks, users can focus on more strategic activities.
Conclusion
The AI-powered formula generator is a powerful tool for Excel users. Its ability to transform text instructions into complex formulas with ease makes it an indispensable resource for businesses and entrepreneurs alike. Whether you're looking to streamline your financial reports or simply need help with a specific calculation, this technology has the potential to revolutionize the way you work.
Best of luck to you as you navigate this AR Gold Rush, and if you have any questions, hit down below and leave them in the comment section. I reply to all comments, so don't hesitate to reach out.
WEBVTTKind: captionsLanguage: enin this video I'm going to be showing you seven artificial intelligence tools that you can be using in 2023 as an entrepreneur to get ahead of the pack and supercharge your productivity me and my team have gone deep to find you guys some tools that we haven't really seen being talked about much that are really going to help you be more productive in your everyday life the tools I'm going to cover in this video are the kind of tweaks that you can make to your schedule and your workflow this year to become more productive and really hit the ground running and beat the competition in every aspect you can so to those who stick around to the end I know that you're going to be the ones to crush this year thank you so much for watching unless you're stuck into it but before we get started my name is Liam Motley I'm a self-made serial entrepreneur from New Zealand and now living in Dubai finally back here after a few weeks away on this channel I create content for aspiring and established entrepreneurs looking to hit it big and strike rich in this AR Gold Rush happening right now I post at least three videos every single week on this topic so if you're an entrepreneur looking to get hit make some money in this huge opportunity we have in front of us make sure you hit down below subscribe to the channel hit the Bell so you're notified when I drop my next video and leave a like if you feel it really really helps my video reach more people thank you so much tool number one compose AI compose AI is a free Chrome plugin that's going to help you write faster in your emails on face Facebook wherever it is and slack we're giving you AI generated suggestions and autocomplete here we are on the compose AI site I can just scroll down and show you what the features are autocomplete is going to like you into Gmail it's going to give you order completion suggestions it's going to enable you to rephrase sentences which is a really cool functionality just like in chat GPT you can ask it to shuffle things around and make it different and then this easy reply compose now all sorts of different features that I'm going to show you in a sec super easy install we're just going to head to the Chrome web store right now add to Chrome and then boom installed just like that they've got a nice tutorial here if you'll never watch but I've actually got it all sorted out so to get started with it I'm just hearing my Gmail what you can do is I click down at the bottom and say open compose now so in here I can ask a light chat GPT it's going to know what I'm asking for and it's going to write it out for me so in this I can write ask Graham if you can buy me a new dog for Christmas and mention that I'll be home on the 12th of August and just like that it's giving me a full email written out I've only had to write one short sentence and then it's given me an entire email all I could say is cheers Liam and then I'm done and there are also order complete features so if I'm like I am not sure what you mean so as you can see as I write along it gives me order for complete suggestions it's really quick really Snappy and I think if you're an entrepreneur who's running a lot of emails who doesn't have time or you haven't can't quite afford an assistant then something like this is such a great tool because you can just write into that prompt or everything you need for the email hit enter and it's going to give you a fully populated email you can just fire that off this is going to save so much messing around I for one is definitely going to be adopting this in my email flow one last great feature about composer.ai is this rephrase option so I've selected it and then I can click rephrase it actually has a couple here shorten expand formal tone or for any touch there's some great examples here of things you can do I'm going to rephrase it and there you go I've got a rephrased example of what I just had so we're going to take this and I'm going to put a friendly and shorten it down give an unfriendly tone when you're writing emails you get all different blocks that you work with you can get it to write stuff for you you can shorten it lengthen it for any tone business own all sorts of great things that are going to be handy for you when you're writing your emails every single day tool number two is the script the script is an insanely powerful video editing software that's online that's powered by artificial intelligence here we are at the scripts website it gives you a few examples of what you can do with a video editing screen recording podcasting and transcription now this doesn't even give you a hint of just how powerful some of these tools are that they have got included in their app I'm actually thinking of getting my YouTube Editor to start using this because I honestly will save them so much time and save me a few hours in Billing as well so really check this out it's a great explainer video on their website right here which will save me a ton of breath but it's got some crazy features like the transcription is going to be able to take all the audio from your video transcribe it all and have it in sort of a text conversation based way where you can look at it like a text document and then edit what you're saying and it will learn using artificial intelligence learn your voice I'm pretty script Ure download a description in the app now I'm in the demo project so I'm going to show you a few of the features of it the main feature of the script is the side panel here which is going to allow you to basically connect the text and the video to the different bits of video that are being shown so the script knows what words are being saying when in your video which allows you to modify how it's being said and modify the words within the actual video itself so they have an insane feature called overdubbing overdubbing allows you in this text editor here to change what they said so here if I head to the overdub editor and I select that all it asks me to assign a voice so if I sign a voice it's Tiff here which is the person in the video what I want to do is create a new voice for it to be able to replicate your voice and your videos and allow you to edit and overdub things you need to give it 10 minutes of training data so in this project you won't let me show you but if you have a say half an hour video or the more the better I assume if I have like half an hour an hour of me talking on a podcast I can give that to the script and it's going to learn my voice and then if I say something in the podcast I don't like I can head to this text editor on the side and I can change what I wrote by overdubbing it not only does the script have this insane side panel here that switches up the flow of editing completely and makes it so much more into it would have end up text base also has tons of stock footage that you can search through and give you a great range of things to choose from and use in your videos it has all the usual text editing things and effects and animations to make them look cool and slide in and stuff and best of all it is shareable it's like figma you can add teammates in here and they can work on the project with you actively so I'm for sure going to be asking my editors to check this out and see if we can start working on here in future so that I can see the projects and the project files aren't all scattered around the globe tool number three browse AI browse AI has done a great job of turning the headache of web scraping and monitoring different web pages into a streamlined system all on their website that just makes it such a breeze to use if you're not familiar with web scraping it's a process of scraping data off different web pages and usually it's a bit of a headache because you've actually got to dig through all of the code of that webpage and pluck out the different elements these guys have done a great job of making it this nice intuitive way of web scraping so here we are on browser ai's website it's going to show you what they can do data extraction monitoring and pre-built robot setup so there's a whole bunch of functionality these guys give no coding required two minute sit-ups so it starts off here are we looking to extract structured data or we're looking to monitor site changes monitor site changes obviously pretty straightforward extract structure data we're going to do one of these as an example so here I've just taken a y combinator site and I can head back over and put it in here start recording task install the extension so now we have it here in the corner and it's going to actually record what I'm doing so browser AR is a scraping tool that's going to allow you set up monitors and different sites you want to be looking at for example you could be scraping a competitor's site and keeping an eye on what new products they put out so here I've selected the table of data that I want to start scraping once I've selected all the things I want to scrape and I hit enter to finish so it's a simple use case for this would be looking at Facebook groups and you want to scrape all the data off the Facebook group and store it in the list you can actually connect this to your Google Sheets so you'll be able to scrape all the data off any website you want to find without having to hire a developer which is usually what you'd have to do with web scraping if you're looking at scraping some data off the web in a systematic way this is like 20 30 a month great tool number four is tone Tome is an artificial intelligence presentation Builder that's going to save you so much time it will create you some fire presentations and just a click of a button so we're going to jump in and have a look as an entrepreneur you might be putting together a pitch deck for some fundraising so we can hop into this one one of the cool things here is Dali is going to allow me to put things into a prompt and then get instant AI generated images to put into my presentation and here I've put in a prompt skyscraper rising up from the payment in New York viewed from the ground there we go just like that we put an image from Valley put into our presentation now look you can drag these around it's really intuitive the way it shuffled things through there's a bunch of easy theme settings you can change it's going to save you a ton of time so you don't have to go through every single slide and change the font click this and it's going to change all of the headline fonts for you and then you can change the paragraph once just as easily so this is kind of stuff to save you so much time coming through changing your font changing your color scheme adding in those AI images this is the exact kind of software that I'm going to be using when I'm making my presentations this year it's just so intuitive Gonna Save Me So Much Time The Styling here is just off the charts and you're going to be able to pull in artificially generated images I mean just look at some of these tables that it's got it looks so fantastic compared to what you'd be able to do on any other presentation maker like PowerPoint so if this year if you've got any really important presentations that you need to drop and you need to save time and then make a splash with how good they look a tool like Tome is going to be excellent for you in that regard tool number five is Synthesia Synthesia allows you to use AI avatars and tell them what to say the only website here you can see this is a great example this guy looks more natural on camera than most YouTubers they have a ton of different actors that you can use and I also have a ton of different languages as well so this is just got everything you need in terms of making a human looking person that speaks whatever you want now you may be asking why do I need this well if you haven't noticed because of tools like chat GPT faceless YouTube automation has become a serious player in the online business space people are making thousands and thousands of dollars a month by making YouTube videos with scripts written by Ai and then putting it into tools like Pick 3 and making artificially generated stock footage that goes on top of the captions and they're posting on YouTube this kind of tool is what you can use in creating your YouTube automation videos that's going to allow you to keep your face off it and put someone up there instead not only is it going to make your content creation schedule faster because doing this like I'm in front of a camera takes hours but you can just type it on it's going to give you all at once but number two you never have to get your face in it anyway so here we're going to create a quick AR video you can tell her what to say Liam has such fire tools to use an entrepreneur in 2023 let's run this up Kim has such fire tools to use as entrepreneurs in 2023 let's run this up using faceless YouTube Automation and combining with tools like this you can start making a ton of money on YouTube as a Creator but never put your face on what's more you could start making these explainer and training videos for companies if you can come to companies and say hey I'll make you some great training videos that are super high quality got a great presentation behind it and then you can use tools like this to create these Bots that speak your script for you you can start creating a ton of money by selling to these corporate companies on excellent training videos that you can make for a fraction of the price of others being able to undercut media companies that require cameraman and actors and lighting and stuff by using these tools is such a huge opportunity for entrepreneurs right now who want to get in ahead of these guys and start making money and stealing their business away tool number six is flyfin flyfin is your accountant powered by artificial intelligence it uses artificial intelligence to find all of the deductions and loopholes that you can possibly get to squeeze the most money out of your income and get the least amount possible to the government here on the site you can see it's the number one AI tax engine for Freelancers AI best product of the year so to use flyfan all you need to do is sign up and link your accounts in the artificial intelligence is going to find every possible tax deduction for you to use a New York filing so you can save as much money as possible it's going to be looking through all of these things and find the deductions that you can save money on and then it's going to ask you to approve them or decline them or send them off to a CPA to have a look at more closely so as a solo entrepreneur for many years myself these kind of tools would have been a lifesaver and save me a ton of money on my my account on bills but I know it can be a massive headache if you're starting online businesses right now if you've been running one for a few months or a few years when it comes down to tax time I know it can be very daunting so something like this for an entrepreneur going into 2023 is going to give you one piece of mind but two save you a bunch of time and three save you a ton of money through these deductions I think this is such an excellent tool I wish I had this when I was getting my start when I didn't have to pay all that money to my accountant here we have a demo on screen it's taking my credit card checking account savings obviously not real data but that's an example now it's analyzing all of my expenses it's finding the deductions based on my tax profile and millions of other rules the ahi's found deductions worth 8 678 now if I connect to my account and I saw that I could save ten thousand dollars on my tax bill for the year that would be an excellent excellent little head of those meme for me there you have a quick run through of the app I think this is an excellent tool I'm assuming this is only available for us customers so if your us viewer definitely take advantage of this if you live outside the US like I have my whole life then I'm sure are used to the feeling of not being able to have fun with a lot of these Financial tools that people create our seventh and final tool is Excel formula bot Excel formula bot is like chat GPT but it's going to help you create all the Excel formulas that you need if you're an entrepreneur and have me for a while I'm sure you're familiar with the nightmare you can have a Google sheet and Excel over time something like this is such an incredible tool because it's going to use that AI sort of conversational style dialogue that you have which at gbt but it's going to help you get formulas for your Excel spreadsheets transform your text instructions into Excel formulas in seconds with the help of AI for free as you can see on the side here you can either give it a prompt and ask for a formula for it or you can take a formula and get an explanation for it so this is just an excellent tool we're going to jump straight in and give you an example of how I'd be using it in my own businesses right now using an example for my YouTube financials report as you can see on screen here this is super powerful it can take the easiest to the hardest XL formulas that you can give it based on Tech so look from this average column of a and then all of this it can convert it into a complex if and statement with regix matching and a whole bunch of other stuff this can definitely handle anything you throw at it here's an example of a drive future Financial spreadsheet that I'm looking at right now I've got a video editor name I've got the editing hours over thumbnail designer and have the thumbnail hours what I want to do is create a function in this total cost column that's going to look at who the editor is and then use a rule if the editor is X then multiply the hours by y so if I have editors that are on different rates then I can quickly multiply across the row and do the same with the thumbnail designer and then for every single time a new video is made a new editor or a thumbnail editor does it it will automatically calculate it based on who the people are and what their rates are so I've hit it over here and I've inputted it into the tool and I've got Google Sheets and I want to generate it not explain so you can have a look at this basically I've been very specific about the columns and rows what it's going to be and what I expect the multiplication to be and then I said at the end add the result of both these and output it to column G row two so you need to make sure you're putting in the rows so that when you expand it down and copy that same down across all the columns it's going to automatically adjust the ones it needs to adjust you need to be specific about it just to get for one row so I've put in the row and the column here then if I take this copy it and put it into the total cost hit enter Then it gives me the 255 and I can drag it down it's going to automatically apply it to the next column and adjust the rows this will just save me a ton of time I was thinking I was gonna have to go on Fiverr and find someone to do this for me but just like that now to give me a really complex if structure function that I can put into the cells here and it work out exactly how much I'm paying my editors and how much I'm paying my YouTube thumbnail creators this is an excellent tool and I'm definitely going to be using this a ton it's going to save me a ton of time looking for people to do this and a ton of money as well because I'm not having to pay people to do it congratulations for making it to the end and I hope you're going to be applying some of these to your life because I certainly will be you need to go out there with the best tools the best weapons to crush the competition and some of these are going to save you the time and the money needed to get to the top of the pyramid so if you've enjoyed the video and got something out of it I made content like this every day for people who are looking to get an edge as an entrepreneur I just did an AI startup in just eight minutes using chat gpta I told it to ride a little for me so I'm going to put it up in the corner here somewhere so that you can watch that it's excellent video if you have any questions and hit down below and leave them in the comment section I reply to all comments so I can help you out as much as I can down there that about wraps it up thank you so much for watching my name is Liam Motley and best of luck to you as you navigate this AR Gold Rush foreignin this video I'm going to be showing you seven artificial intelligence tools that you can be using in 2023 as an entrepreneur to get ahead of the pack and supercharge your productivity me and my team have gone deep to find you guys some tools that we haven't really seen being talked about much that are really going to help you be more productive in your everyday life the tools I'm going to cover in this video are the kind of tweaks that you can make to your schedule and your workflow this year to become more productive and really hit the ground running and beat the competition in every aspect you can so to those who stick around to the end I know that you're going to be the ones to crush this year thank you so much for watching unless you're stuck into it but before we get started my name is Liam Motley I'm a self-made serial entrepreneur from New Zealand and now living in Dubai finally back here after a few weeks away on this channel I create content for aspiring and established entrepreneurs looking to hit it big and strike rich in this AR Gold Rush happening right now I post at least three videos every single week on this topic so if you're an entrepreneur looking to get hit make some money in this huge opportunity we have in front of us make sure you hit down below subscribe to the channel hit the Bell so you're notified when I drop my next video and leave a like if you feel it really really helps my video reach more people thank you so much tool number one compose AI compose AI is a free Chrome plugin that's going to help you write faster in your emails on face Facebook wherever it is and slack we're giving you AI generated suggestions and autocomplete here we are on the compose AI site I can just scroll down and show you what the features are autocomplete is going to like you into Gmail it's going to give you order completion suggestions it's going to enable you to rephrase sentences which is a really cool functionality just like in chat GPT you can ask it to shuffle things around and make it different and then this easy reply compose now all sorts of different features that I'm going to show you in a sec super easy install we're just going to head to the Chrome web store right now add to Chrome and then boom installed just like that they've got a nice tutorial here if you'll never watch but I've actually got it all sorted out so to get started with it I'm just hearing my Gmail what you can do is I click down at the bottom and say open compose now so in here I can ask a light chat GPT it's going to know what I'm asking for and it's going to write it out for me so in this I can write ask Graham if you can buy me a new dog for Christmas and mention that I'll be home on the 12th of August and just like that it's giving me a full email written out I've only had to write one short sentence and then it's given me an entire email all I could say is cheers Liam and then I'm done and there are also order complete features so if I'm like I am not sure what you mean so as you can see as I write along it gives me order for complete suggestions it's really quick really Snappy and I think if you're an entrepreneur who's running a lot of emails who doesn't have time or you haven't can't quite afford an assistant then something like this is such a great tool because you can just write into that prompt or everything you need for the email hit enter and it's going to give you a fully populated email you can just fire that off this is going to save so much messing around I for one is definitely going to be adopting this in my email flow one last great feature about composer.ai is this rephrase option so I've selected it and then I can click rephrase it actually has a couple here shorten expand formal tone or for any touch there's some great examples here of things you can do I'm going to rephrase it and there you go I've got a rephrased example of what I just had so we're going to take this and I'm going to put a friendly and shorten it down give an unfriendly tone when you're writing emails you get all different blocks that you work with you can get it to write stuff for you you can shorten it lengthen it for any tone business own all sorts of great things that are going to be handy for you when you're writing your emails every single day tool number two is the script the script is an insanely powerful video editing software that's online that's powered by artificial intelligence here we are at the scripts website it gives you a few examples of what you can do with a video editing screen recording podcasting and transcription now this doesn't even give you a hint of just how powerful some of these tools are that they have got included in their app I'm actually thinking of getting my YouTube Editor to start using this because I honestly will save them so much time and save me a few hours in Billing as well so really check this out it's a great explainer video on their website right here which will save me a ton of breath but it's got some crazy features like the transcription is going to be able to take all the audio from your video transcribe it all and have it in sort of a text conversation based way where you can look at it like a text document and then edit what you're saying and it will learn using artificial intelligence learn your voice I'm pretty script Ure download a description in the app now I'm in the demo project so I'm going to show you a few of the features of it the main feature of the script is the side panel here which is going to allow you to basically connect the text and the video to the different bits of video that are being shown so the script knows what words are being saying when in your video which allows you to modify how it's being said and modify the words within the actual video itself so they have an insane feature called overdubbing overdubbing allows you in this text editor here to change what they said so here if I head to the overdub editor and I select that all it asks me to assign a voice so if I sign a voice it's Tiff here which is the person in the video what I want to do is create a new voice for it to be able to replicate your voice and your videos and allow you to edit and overdub things you need to give it 10 minutes of training data so in this project you won't let me show you but if you have a say half an hour video or the more the better I assume if I have like half an hour an hour of me talking on a podcast I can give that to the script and it's going to learn my voice and then if I say something in the podcast I don't like I can head to this text editor on the side and I can change what I wrote by overdubbing it not only does the script have this insane side panel here that switches up the flow of editing completely and makes it so much more into it would have end up text base also has tons of stock footage that you can search through and give you a great range of things to choose from and use in your videos it has all the usual text editing things and effects and animations to make them look cool and slide in and stuff and best of all it is shareable it's like figma you can add teammates in here and they can work on the project with you actively so I'm for sure going to be asking my editors to check this out and see if we can start working on here in future so that I can see the projects and the project files aren't all scattered around the globe tool number three browse AI browse AI has done a great job of turning the headache of web scraping and monitoring different web pages into a streamlined system all on their website that just makes it such a breeze to use if you're not familiar with web scraping it's a process of scraping data off different web pages and usually it's a bit of a headache because you've actually got to dig through all of the code of that webpage and pluck out the different elements these guys have done a great job of making it this nice intuitive way of web scraping so here we are on browser ai's website it's going to show you what they can do data extraction monitoring and pre-built robot setup so there's a whole bunch of functionality these guys give no coding required two minute sit-ups so it starts off here are we looking to extract structured data or we're looking to monitor site changes monitor site changes obviously pretty straightforward extract structure data we're going to do one of these as an example so here I've just taken a y combinator site and I can head back over and put it in here start recording task install the extension so now we have it here in the corner and it's going to actually record what I'm doing so browser AR is a scraping tool that's going to allow you set up monitors and different sites you want to be looking at for example you could be scraping a competitor's site and keeping an eye on what new products they put out so here I've selected the table of data that I want to start scraping once I've selected all the things I want to scrape and I hit enter to finish so it's a simple use case for this would be looking at Facebook groups and you want to scrape all the data off the Facebook group and store it in the list you can actually connect this to your Google Sheets so you'll be able to scrape all the data off any website you want to find without having to hire a developer which is usually what you'd have to do with web scraping if you're looking at scraping some data off the web in a systematic way this is like 20 30 a month great tool number four is tone Tome is an artificial intelligence presentation Builder that's going to save you so much time it will create you some fire presentations and just a click of a button so we're going to jump in and have a look as an entrepreneur you might be putting together a pitch deck for some fundraising so we can hop into this one one of the cool things here is Dali is going to allow me to put things into a prompt and then get instant AI generated images to put into my presentation and here I've put in a prompt skyscraper rising up from the payment in New York viewed from the ground there we go just like that we put an image from Valley put into our presentation now look you can drag these around it's really intuitive the way it shuffled things through there's a bunch of easy theme settings you can change it's going to save you a ton of time so you don't have to go through every single slide and change the font click this and it's going to change all of the headline fonts for you and then you can change the paragraph once just as easily so this is kind of stuff to save you so much time coming through changing your font changing your color scheme adding in those AI images this is the exact kind of software that I'm going to be using when I'm making my presentations this year it's just so intuitive Gonna Save Me So Much Time The Styling here is just off the charts and you're going to be able to pull in artificially generated images I mean just look at some of these tables that it's got it looks so fantastic compared to what you'd be able to do on any other presentation maker like PowerPoint so if this year if you've got any really important presentations that you need to drop and you need to save time and then make a splash with how good they look a tool like Tome is going to be excellent for you in that regard tool number five is Synthesia Synthesia allows you to use AI avatars and tell them what to say the only website here you can see this is a great example this guy looks more natural on camera than most YouTubers they have a ton of different actors that you can use and I also have a ton of different languages as well so this is just got everything you need in terms of making a human looking person that speaks whatever you want now you may be asking why do I need this well if you haven't noticed because of tools like chat GPT faceless YouTube automation has become a serious player in the online business space people are making thousands and thousands of dollars a month by making YouTube videos with scripts written by Ai and then putting it into tools like Pick 3 and making artificially generated stock footage that goes on top of the captions and they're posting on YouTube this kind of tool is what you can use in creating your YouTube automation videos that's going to allow you to keep your face off it and put someone up there instead not only is it going to make your content creation schedule faster because doing this like I'm in front of a camera takes hours but you can just type it on it's going to give you all at once but number two you never have to get your face in it anyway so here we're going to create a quick AR video you can tell her what to say Liam has such fire tools to use an entrepreneur in 2023 let's run this up Kim has such fire tools to use as entrepreneurs in 2023 let's run this up using faceless YouTube Automation and combining with tools like this you can start making a ton of money on YouTube as a Creator but never put your face on what's more you could start making these explainer and training videos for companies if you can come to companies and say hey I'll make you some great training videos that are super high quality got a great presentation behind it and then you can use tools like this to create these Bots that speak your script for you you can start creating a ton of money by selling to these corporate companies on excellent training videos that you can make for a fraction of the price of others being able to undercut media companies that require cameraman and actors and lighting and stuff by using these tools is such a huge opportunity for entrepreneurs right now who want to get in ahead of these guys and start making money and stealing their business away tool number six is flyfin flyfin is your accountant powered by artificial intelligence it uses artificial intelligence to find all of the deductions and loopholes that you can possibly get to squeeze the most money out of your income and get the least amount possible to the government here on the site you can see it's the number one AI tax engine for Freelancers AI best product of the year so to use flyfan all you need to do is sign up and link your accounts in the artificial intelligence is going to find every possible tax deduction for you to use a New York filing so you can save as much money as possible it's going to be looking through all of these things and find the deductions that you can save money on and then it's going to ask you to approve them or decline them or send them off to a CPA to have a look at more closely so as a solo entrepreneur for many years myself these kind of tools would have been a lifesaver and save me a ton of money on my my account on bills but I know it can be a massive headache if you're starting online businesses right now if you've been running one for a few months or a few years when it comes down to tax time I know it can be very daunting so something like this for an entrepreneur going into 2023 is going to give you one piece of mind but two save you a bunch of time and three save you a ton of money through these deductions I think this is such an excellent tool I wish I had this when I was getting my start when I didn't have to pay all that money to my accountant here we have a demo on screen it's taking my credit card checking account savings obviously not real data but that's an example now it's analyzing all of my expenses it's finding the deductions based on my tax profile and millions of other rules the ahi's found deductions worth 8 678 now if I connect to my account and I saw that I could save ten thousand dollars on my tax bill for the year that would be an excellent excellent little head of those meme for me there you have a quick run through of the app I think this is an excellent tool I'm assuming this is only available for us customers so if your us viewer definitely take advantage of this if you live outside the US like I have my whole life then I'm sure are used to the feeling of not being able to have fun with a lot of these Financial tools that people create our seventh and final tool is Excel formula bot Excel formula bot is like chat GPT but it's going to help you create all the Excel formulas that you need if you're an entrepreneur and have me for a while I'm sure you're familiar with the nightmare you can have a Google sheet and Excel over time something like this is such an incredible tool because it's going to use that AI sort of conversational style dialogue that you have which at gbt but it's going to help you get formulas for your Excel spreadsheets transform your text instructions into Excel formulas in seconds with the help of AI for free as you can see on the side here you can either give it a prompt and ask for a formula for it or you can take a formula and get an explanation for it so this is just an excellent tool we're going to jump straight in and give you an example of how I'd be using it in my own businesses right now using an example for my YouTube financials report as you can see on screen here this is super powerful it can take the easiest to the hardest XL formulas that you can give it based on Tech so look from this average column of a and then all of this it can convert it into a complex if and statement with regix matching and a whole bunch of other stuff this can definitely handle anything you throw at it here's an example of a drive future Financial spreadsheet that I'm looking at right now I've got a video editor name I've got the editing hours over thumbnail designer and have the thumbnail hours what I want to do is create a function in this total cost column that's going to look at who the editor is and then use a rule if the editor is X then multiply the hours by y so if I have editors that are on different rates then I can quickly multiply across the row and do the same with the thumbnail designer and then for every single time a new video is made a new editor or a thumbnail editor does it it will automatically calculate it based on who the people are and what their rates are so I've hit it over here and I've inputted it into the tool and I've got Google Sheets and I want to generate it not explain so you can have a look at this basically I've been very specific about the columns and rows what it's going to be and what I expect the multiplication to be and then I said at the end add the result of both these and output it to column G row two so you need to make sure you're putting in the rows so that when you expand it down and copy that same down across all the columns it's going to automatically adjust the ones it needs to adjust you need to be specific about it just to get for one row so I've put in the row and the column here then if I take this copy it and put it into the total cost hit enter Then it gives me the 255 and I can drag it down it's going to automatically apply it to the next column and adjust the rows this will just save me a ton of time I was thinking I was gonna have to go on Fiverr and find someone to do this for me but just like that now to give me a really complex if structure function that I can put into the cells here and it work out exactly how much I'm paying my editors and how much I'm paying my YouTube thumbnail creators this is an excellent tool and I'm definitely going to be using this a ton it's going to save me a ton of time looking for people to do this and a ton of money as well because I'm not having to pay people to do it congratulations for making it to the end and I hope you're going to be applying some of these to your life because I certainly will be you need to go out there with the best tools the best weapons to crush the competition and some of these are going to save you the time and the money needed to get to the top of the pyramid so if you've enjoyed the video and got something out of it I made content like this every day for people who are looking to get an edge as an entrepreneur I just did an AI startup in just eight minutes using chat gpta I told it to ride a little for me so I'm going to put it up in the corner here somewhere so that you can watch that it's excellent video if you have any questions and hit down below and leave them in the comment section I reply to all comments so I can help you out as much as I can down there that about wraps it up thank you so much for watching my name is Liam Motley and best of luck to you as you navigate this AR Gold Rush foreign