Excel - Generate Excel Formulas Using Artificial Intelligence - Episode 2496
21.6 هزار بار بازدید -
2 سال پیش
-
Microsoft Excel Tutorial: ExcelFormulaBot.com is
Microsoft Excel Tutorial: ExcelFormulaBot.com is a free A.I. bot that generates the Excel formula for any problem. You type a sentence. It suggests a formula. Free from David Bressler.
Welcome to another exciting video from MrExcel! In this video, we will be exploring a new and innovative way to generate Excel formulas using artificial intelligence. This is a great Sunday diversion for all the Excel enthusiasts out there. Our guest, David Bresler, has created a website called excelformulabot.com which allows you to type a sentence and get an Excel formula in return. And the best part? It's all free!
So how does it work? Simply type a sentence and the website will generate a formula for you. For example, you can type a sentence like "get the last word from each cell in A2 to A999" and the website will give you a valid Excel formula. You can even customize the formula by adding commas and replacing them with semicolons for non-US countries. It's that easy!
But that's not all, this website also suggests formulas for more complex tasks. For instance, if you want to know if a number in cell A2 is a prime number, simply type a sentence like "is the number in A2 a prime number?" and the website will suggest a formula using a function that doesn't even exist yet - ISPRIME. This just goes to show the potential of artificial intelligence in Excel.
Now, I know some of you may have tried this website and found some gaps in its suggestions. But let's not forget that this is still a work in progress and it has already generated over 323,000 formulas. So, let's give credit where it's due and appreciate the effort put in by David Bresler. And if you find this website helpful, don't forget to show your support by donating and buying him a coffee.
But here's the real challenge for you - come and try out excelformulabot.com and see how it performs with the complex formulas you use at work. Share your experience in the comments below - which formulas worked, which ones didn't, and how this website can be improved. This is a great opportunity to test the capabilities of artificial intelligence in Excel and see if it can make our lives easier.
And now for some exciting news - Excel On Fire and myself are co-hosting a 30-minute Excel competition on ESPN - "ESPN 8 the Ocho"! Yes, you heard it right, ESPN2 will be rebranded as ESPN8 for this weekend. So, set your DVRs and tune in on Sunday, August 7th at 9:00 AM Eastern and Monday, August 8th at 11:30 PM Eastern to catch all the action. And don't forget to support us by watching the show and spreading the word.
Thank you for watching this video and don't forget to subscribe to our channel for more interesting and informative content. We'll see you next time for another netcast from MrExcel. Happy Excel-ing!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents
(0:00) This is cool
(0:36) Formula for last word
(1:15) Formula for Prime Numbers
(2:23) Excel All Star Battle on ESPN8 The Ocho
(3:01) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Donations for excelformulabot.com
ESPN 8 schedule for Excel All Star Battle
ESPN 8 the Ocho Excel competition
Excel formula for checking if a number is prime
Excel formula for getting last word from each cell
Excel formula using artificial intelligence
Excel formulas that don't work
Excel formulas that work
excelformulabot.com
Formula intelligence in Excel
Function TEXTBEFORE and TEXTAFTER in Excel
Replace commas with semicolons in Excel formula
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Welcome to another exciting video from MrExcel! In this video, we will be exploring a new and innovative way to generate Excel formulas using artificial intelligence. This is a great Sunday diversion for all the Excel enthusiasts out there. Our guest, David Bresler, has created a website called excelformulabot.com which allows you to type a sentence and get an Excel formula in return. And the best part? It's all free!
So how does it work? Simply type a sentence and the website will generate a formula for you. For example, you can type a sentence like "get the last word from each cell in A2 to A999" and the website will give you a valid Excel formula. You can even customize the formula by adding commas and replacing them with semicolons for non-US countries. It's that easy!
But that's not all, this website also suggests formulas for more complex tasks. For instance, if you want to know if a number in cell A2 is a prime number, simply type a sentence like "is the number in A2 a prime number?" and the website will suggest a formula using a function that doesn't even exist yet - ISPRIME. This just goes to show the potential of artificial intelligence in Excel.
Now, I know some of you may have tried this website and found some gaps in its suggestions. But let's not forget that this is still a work in progress and it has already generated over 323,000 formulas. So, let's give credit where it's due and appreciate the effort put in by David Bresler. And if you find this website helpful, don't forget to show your support by donating and buying him a coffee.
But here's the real challenge for you - come and try out excelformulabot.com and see how it performs with the complex formulas you use at work. Share your experience in the comments below - which formulas worked, which ones didn't, and how this website can be improved. This is a great opportunity to test the capabilities of artificial intelligence in Excel and see if it can make our lives easier.
And now for some exciting news - Excel On Fire and myself are co-hosting a 30-minute Excel competition on ESPN - "ESPN 8 the Ocho"! Yes, you heard it right, ESPN2 will be rebranded as ESPN8 for this weekend. So, set your DVRs and tune in on Sunday, August 7th at 9:00 AM Eastern and Monday, August 8th at 11:30 PM Eastern to catch all the action. And don't forget to support us by watching the show and spreading the word.
Thank you for watching this video and don't forget to subscribe to our channel for more interesting and informative content. We'll see you next time for another netcast from MrExcel. Happy Excel-ing!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents
(0:00) This is cool
(0:36) Formula for last word
(1:15) Formula for Prime Numbers
(2:23) Excel All Star Battle on ESPN8 The Ocho
(3:01) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Donations for excelformulabot.com
ESPN 8 schedule for Excel All Star Battle
ESPN 8 the Ocho Excel competition
Excel formula for checking if a number is prime
Excel formula for getting last word from each cell
Excel formula using artificial intelligence
Excel formulas that don't work
Excel formulas that work
excelformulabot.com
Formula intelligence in Excel
Function TEXTBEFORE and TEXTAFTER in Excel
Replace commas with semicolons in Excel formula
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
2 سال پیش
در تاریخ 1401/05/09 منتشر شده
است.
21,672
بـار بازدید شده