Get Bricks AI-First Spreadsheet for free: bit.ly/bricksaispreadsheet 🗃 Sample CSV data to follow along: 1drv.ms/u/s!AmxrofZZlZ-whfQH8_6BNXO-040P2w?e=VsV1BG ✉ Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
Can you do one for roof costs for residential roofs? Profit loss / upgrades/ actual cost / estimate and supplier costs for each part of major manufacturing system? Just curious if it can pull info from data off an insurance claim and apply it with other known costs. Apply other knows such as gutters, fence , labor for each and get the profit margin etc. If so I’d love to see how this works.
Kevin, Thank You for Being an Incredible Teacher! Kevin, I just wanted to take a moment to thank you for all your amazing Excel tutorials! I used to feel like a complete beginner, but after watching your videos, I’ve made so many improvements in my work. You break everything down so clearly, and your teaching style has made complex topics much easier to understand. I'm so much more confident with Excel now, and I can't tell you how much it’s helped me become more efficient. I truly respect you as my teacher, and I’m grateful for everything you've taught me. Keep up the great work - you've made a huge difference for me! Thank you again, Muhammad Abbas Khan Peshawar, KPK, Pakistan
This is online only. One is submitting data to basically an unknown entity, with no way of knowing if they are retransmitting the data somewhere for processing. And there’s no guarantee of data protection other than they state they won’t use the data. This may be fine uploading kids team stats *WITHOUT* personal identifiers, addresses, phone numbers - but corporate data, or personal data that contains family financial information…. Well, PT Barnum said, “There’s a sucker born every minute.”
I suspect that users have autocorrect and spellcheck enabled on their devices. Someone (big tech, Patriot Act, ISPs) is capturing everyone's information. Privacy left the building with the invention of the wire.
@@momodev1135 it’s one thing to do research. It’s another to upload a ton of personal and financial information to a site that says they won’t use your information… today. What about next week?
I uploaded my product based sales data for a few months and did some analysis and it was REALLY awesome. We’re not Walmart or something so I can’t imagine how that info would be of any use to anyone but me. So for me at least the trade off is completely worth it. And I don’t really feel like my info is in any way at risk anyway
Most of this can be achieved in Airtable. With one huge advantage: Airtable is a database. Spreadsheets are not databases, meaning that you can play around with data but no ability to build an scalable system out of it.
Here's their privacy policy: www.thebricks.com/terms-and-privacy-policy TLDR: "Bricks prioritizes data security by implementing industry-standard encryption and limiting data access to authorized personnel only. They collect and use data primarily to enhance services, sharing it with third-party providers only as necessary and compliant with legal standards. However, always exercise caution by reviewing specific data storage and sharing practices to ensure they align with your company's security policies."
Go to pricing and you'll see that is not exactly free for companies and not even close to that: starting from 500$/month for mínimum 10 users so 6000$ per year
This is cool. As an analyst for the last 30 years, I can see how this will change work. I'm curious about the context around Location City and State. Why does the A.I. pick 'Oregon' for Portland assignment instead of Maine? It will be interesting to see if the A.I. picked 'Oregon' because of the presence of other West Coast cities in the data.
I thinks it's almost unfair😂, just imagine all your tutorial videos I have been watching over the years, the need for them has just been vaporized with ai, wow.
Thank you for the video. I’m very interested in this topic, as I am in all things related to data analysis. I’d also like to know if there is an AI tool that can comment on data, meaning a tool that could generate a textual report interpreting the data in tables and charts on my behalf, possibly starting from some contextual inputs to accurately frame the type of scenario being analyzed and commented on. Thank you
hi, can you tell me a liitle bit more on this comment? i work as bi, this 2024 made my data all automated on powerbi having a datasource and ETL procesess, but a couple of files i still have to upload them from excel, so this comment got my attention. Thanks for any help!
Thanks Kevin, this was very interesting! One question. I couldn't tell from the company's website, but I assume any data I enter into this app is stored on the Bricks company cloud. If so, what is the privacy policy and security measures taken to protect our data. I'm not sure businesses and users will be excited about putting financial and other sensitive data into this product depending on the answers to those questions.
Here's their privacy policy: www.thebricks.com/terms-and-privacy-policy TLDR: "Bricks prioritizes data security by implementing industry-standard encryption and limiting data access to authorized personnel only. They collect and use data primarily to enhance services, sharing it with third-party providers only as necessary and compliant with legal standards. However, always exercise caution by reviewing specific data storage and sharing practices to ensure they align with your company's security policies."
Hi Kevin, this is great. I need to use excel to process some data from time to time but don't do it as much, so I easily forgot the formulas I use last time and spent a lot of time trying things out every time. This will save a lot of time.
This is very helpful. I agree with others that data security is a concern, though. I imagine we'll see AI in MS Excel and Google Sheets soon enough. AI really is a game changer.
Thank you for this clear and insightful explanation! 🙏 Your breakdown of these concepts is incredibly helpful for my work. Looking forward to more valuable content from your channel! 👍
This is fascinating!! The old database person in me did ask a couple of questions. Since I used to live in Portland, OR I was wondering what would happen if the data was actually Portland, Maine? Can the interface "learn" the difference or do you need to open up Kevin Cookies 2 on the East Coast to find those cities? I am going to download the data and play with it. Irv in Florida
Does the spreadsheet data that you are working with end up in public domain or is all of the work done on your computer. I can see where many companies would not want to use a program that allowed their data to be available to the world. thanks, glen
Hey Glen! No worries-according to their privacy policy, any spreadsheet data you work with in Bricks is processed on secure servers and isn’t shared publicly. They have strict privacy measures in place to keep your data safe and accessible only to you. You can check their privacy policy here: www.thebricks.com/terms-and-privacy-policy
it changes the value of the digits after i paste it from excel it usually increases the digit by value 1 and also does some other stuff, makes the number blue in colour
Has anyone pointed out that unit cost x units sold usually does not equal revenue (unless you don't make any profit)- it would equal Cost of Goods sold?
Thanks! Copilot does cost significantly more since it requires both a Microsoft 365 license and a separate subscription. Feature-wise, this tool is currently ahead-you can work across multiple tables, while Excel limits you to one table at a time and doesn’t generate dashboards. ChatGPT is more text-based and doesn't offer data manipulation after analysis.
Hey Kevin, Thank you for sharing such great content and new apps. I'm trying the bricks, but unfortunately, I cannot get any results. My file is fairly large (122 MB) and I have uploaded the source data. It's our sales reports information. My prompts are pretty simple and I get good responses but I don't get any reports back. No tables, no charts and etc.
Sounds and looks amazing, but there is no way my company would allow me to save and share something like that online without any guarantee of data security. I noticed that there was an 'Export' function for the pie-chart, IF this allows the user to download the whole spreadsheet + dashboard to Excel that might work better?
Interesting but the goal of KCC is to maximize profits, so more useful to management are the statistically significant inferences to be drawn from available data beyond the spread sheet per se. For instance, AI might suggest that there is a relationship between monthly weather or seasonal climate and the varieties of cookies preferred by buyers. Thus chocolate chip will be favored in the upper planes states in cold months but not in Fla. during spring and summer, when almond cookies sell well. NOAA says that CA will be wet next month and, in the past, that's when lemon creams have sold well but sugar cookies age on the shelves. Shelf space is limited so these data are marketable to grocers.
Is there an export to MS Excel? It would be great to free the Bricks spreadsheets from the Bricks app and leverage these to use, tweek & totally own on Excel.
Cool. Can you export the final file to Excel? We wouldn’t be able to access Bricks at work but if we could crunch it on our home computer than send an Excel file that would be fantastic!
My guess - when ambiguous, AI defaults to the Portland more frequently mentioned or widely known in global datasets, which often turns out to be Portland, Oregon.
Had a little play with the dummy data provided by Bricks and found an issue - I couldn't find a way of changing the date format to ddmmyyyy - there is an option in a menu but that didn't apply to all - I am assuming this must be possible but it wasn't immediately obvious and when I did try the option of changing the cells, it didn't work. I assume I must be doing something wrong with this!
To the left of the column name, you should see an icon to change the data type of the column. In that menu, hover over date and then select DD/MM/YYYY. I just tested and it works on my end. Let me know if you're still running into issues.
Get Bricks AI-First Spreadsheet for free: bit.ly/bricksaispreadsheet
🗃 Sample CSV data to follow along: 1drv.ms/u/s!AmxrofZZlZ-whfQH8_6BNXO-040P2w?e=VsV1BG
✉ Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
Sir Please make a video tutorial on how to use Lark (A tool with rich features used for remote work)
Hi Kevin great work but the website seems to be not working. It says page has been either moved or removed
Thank for the awesome review and demo.
Can you do a video comparison with Microsoft Copilot features in excel.
Thanks in advance
Actually found your other videos on Copilot and ChatGPT for excel. Awesome. New subscriber 😊
Can you do one for roof costs for residential roofs? Profit loss / upgrades/ actual cost / estimate and supplier costs for each part of major manufacturing system? Just curious if it can pull info from data off an insurance claim and apply it with other known costs. Apply other knows such as gutters, fence , labor for each and get the profit margin etc. If so I’d love to see how this works.
Thanks Kevin. You saved me TONS of time! Blessings always and Happy Thanksgiving!
Seriously, Kevin?! You still didnt pin this donate and didnt give it heart?🙄
Kevin, Thank You for Being an Incredible Teacher!
Kevin, I just wanted to take a moment to thank you for all your amazing Excel tutorials! I used to feel like a complete beginner, but after watching your videos, I’ve made so many improvements in my work. You break everything down so clearly, and your teaching style has made complex topics much easier to understand. I'm so much more confident with Excel now, and I can't tell you how much it’s helped me become more efficient. I truly respect you as my teacher, and I’m grateful for everything you've taught me. Keep up the great work - you've made a huge difference for me!
Thank you again,
Muhammad Abbas Khan
Peshawar, KPK, Pakistan
This is online only. One is submitting data to basically an unknown entity, with no way of knowing if they are retransmitting the data somewhere for processing.
And there’s no guarantee of data protection other than they state they won’t use the data.
This may be fine uploading kids team stats *WITHOUT* personal identifiers, addresses, phone numbers - but corporate data, or personal data that contains family financial information…. Well, PT Barnum said, “There’s a sucker born every minute.”
I suspect that users have autocorrect and spellcheck enabled on their devices. Someone (big tech, Patriot Act, ISPs) is capturing everyone's information. Privacy left the building with the invention of the wire.
I guess any AI product nowadays is doing that
Great point
@@momodev1135 it’s one thing to do research. It’s another to upload a ton of personal and financial information to a site that says they won’t use your information… today. What about next week?
I uploaded my product based sales data for a few months and did some analysis and it was REALLY awesome. We’re not Walmart or something so I can’t imagine how that info would be of any use to anyone but me. So for me at least the trade off is completely worth it. And I don’t really feel like my info is in any way at risk anyway
Most of this can be achieved in Airtable. With one huge advantage: Airtable is a database. Spreadsheets are not databases, meaning that you can play around with data but no ability to build an scalable system out of it.
Now I understand why I need AI in spreadsheets-to free up time so I can enjoy all of Kevin Cookie Company’s treats while the AI sorts the data!
😂😂😂😂😂
If only you guys knew how long it took me to study excel before UA-cam. Years later to only be outdone by AI, this is beautiful 😂😂😂😂😂
Great work Kevin … 👏👏
I cannot believe the quality of the work done without a simple formula … 😳
AI in spreadsheet, docs, and PowerPoint is really a blessing. 🎉🎉
Thats just awesome, but at some point of the time I might be worried about my data security. Something to see in near future how it is addressed.
Here's their privacy policy: www.thebricks.com/terms-and-privacy-policy
TLDR: "Bricks prioritizes data security by implementing industry-standard encryption and limiting data access to authorized personnel only. They collect and use data primarily to enhance services, sharing it with third-party providers only as necessary and compliant with legal standards. However, always exercise caution by reviewing specific data storage and sharing practices to ensure they align with your company's security policies."
If the product is free, then you are the product.
Ezy.. make a Fake Product
@ pleabargain : ± AGREE!! and i also HIGHLY NOT SUPPORTING AI
Go to pricing and you'll see that is not exactly free for companies and not even close to that: starting from 500$/month for mínimum 10 users so 6000$ per year
When you buy the product, you become the product
@@estiennetaylor1260 you didn’t even quote it correctly. In fact you quoted the complete opposite. Go look it up.
This is cool. As an analyst for the last 30 years, I can see how this will change work. I'm curious about the context around Location City and State. Why does the A.I. pick 'Oregon' for Portland assignment instead of Maine?
It will be interesting to see if the A.I. picked 'Oregon' because of the presence of other West Coast cities in the data.
I thinks it's almost unfair😂, just imagine all your tutorial videos I have been watching over the years, the need for them has just been vaporized with ai, wow.
Thank you for the video. I’m very interested in this topic, as I am in all things related to data analysis. I’d also like to know if there is an AI tool that can comment on data, meaning a tool that could generate a textual report interpreting the data in tables and charts on my behalf, possibly starting from some contextual inputs to accurately frame the type of scenario being analyzed and commented on. Thank you
Thank you Kevin you're very sweet, I'm going to try it out but I might Still need to get Office for my analyst work...
I have years of experience and right now we're using both options, for Office go to BNH Software, probably Office will get more AI soon
I know right! 😁
New subscriber here and I am amazed with your contents. Thanks for sharing with these very informative tutorials😊
For privacy concerns open source models can be downloaded to your computer, allowing tools to do these analyses.
Thanks dear Kevin for sharing this with us. Appreciate your generosity. Looking forward to receiving your videos. Blessings
I’m convinced this guy is AI. No ones mouth moves that smoothly.
that was my initial thought...
Well not sure whether Kevin used AI image in this video but he is a real person ..
Thank you! Kevin. I've been waiting for something like this for years 🙂
Thank you @Kevin; I anticipate that this will help me focus on more important tasks.
Thank you, Kelvin. This is giving Power BI a run for its money!
hi, can you tell me a liitle bit more on this comment? i work as bi, this 2024 made my data all automated on powerbi having a datasource and ETL procesess, but a couple of files i still have to upload them from excel, so this comment got my attention. Thanks for any help!
Thanks Kevin, this was very interesting!
One question.
I couldn't tell from the company's website, but I assume any data I enter into this app is stored on the Bricks company cloud.
If so, what is the privacy policy and security measures taken to protect our data. I'm not sure businesses and users will be excited about putting financial and other sensitive data into this product depending on the answers to those questions.
Yes, usually you forego all intellectual property when using AI apps, especially if free. Wouldn't use these kinds of apps for any sensitive data.
Here's their privacy policy: www.thebricks.com/terms-and-privacy-policy
TLDR: "Bricks prioritizes data security by implementing industry-standard encryption and limiting data access to authorized personnel only. They collect and use data primarily to enhance services, sharing it with third-party providers only as necessary and compliant with legal standards. However, always exercise caution by reviewing specific data storage and sharing practices to ensure they align with your company's security policies."
Yes, it does. So amazing, Kevin. You help me with my tech-savvy virtual assistant journey. Thanks
Thanks
Bro you rich ??
Suggest always including a note on security on all these apps.
Hi Kevin, this is great. I need to use excel to process some data from time to time but don't do it as much, so I easily forgot the formulas I use last time and spent a lot of time trying things out every time. This will save a lot of time.
This is very helpful. I agree with others that data security is a concern, though. I imagine we'll see AI in MS Excel and Google Sheets soon enough. AI really is a game changer.
AI is already infused in all of MS products, including excel. Its a game changer but we are doomed 😂😂😂
Thank you for this clear and insightful explanation! 🙏 Your breakdown of these concepts is incredibly helpful for my work. Looking forward to more valuable content from your channel! 👍
This is fascinating!! The old database person in me did ask a couple of questions. Since I used to live in Portland, OR I was wondering what would happen if the data was actually Portland, Maine? Can the interface "learn" the difference or do you need to open up Kevin Cookies 2 on the East Coast to find those cities? I am going to download the data and play with it. Irv in Florida
It's definatelly a game changer - thanks for sharing Kevin your content is impressive.
did you use it?
I love it. I was just about to build a dashboard with commands and data. I didn’t know AI could do it for me.
Wow, this is awseeome, kevin. Such a great way to use spreadsheets. Thanks for the tutorial 🙂
the inability to export the final spreadsheet into a local CSV file is just such an obvious oversight :((
Kevin, you are just so helpful. Thank you!
Happy to help!
Does the spreadsheet data that you are working with end up in public domain or is all of the work done on your computer. I can see where many companies would not want to use a program that allowed their data to be available to the world. thanks, glen
Hey Glen! No worries-according to their privacy policy, any spreadsheet data you work with in Bricks is processed on secure servers and isn’t shared publicly. They have strict privacy measures in place to keep your data safe and accessible only to you. You can check their privacy policy here: www.thebricks.com/terms-and-privacy-policy
Great job - have a coffee please :)
This is so helpful for my team!
I've been watching your videos for a while.
I am as excited as you.
A +
it changes the value of the digits after i paste it from excel
it usually increases the digit by value 1 and also does some other stuff, makes the number blue in colour
Has anyone pointed out that unit cost x units sold usually does not equal revenue (unless you don't make any profit)- it would equal Cost of Goods sold?
What does it do with the data you input into the tool? Does it use it to train its models? What if the data is proprietary?
Thanks for spotlighting this cool new productivity tool! RE: your question, tell management, take longer lunch breaks, and ask for a raise. 😊
Thank you Kevin ❤you are the beat leant so much from you and still Learning 🙏
This is incredible. Played around with it last night and was thoroughly impressed!
playing with it since last night. Can't wait to show it to my boss.
Amazing! In fact, you are my favorite teacher in life
Thank you! 😃
i am new to your channel ,and just watched a single video which made the excel easy for me
thanks for this update wow i have explore it and it worked like magic this is a really professional level
just great! thank u Kevin for this and other videos too😃
This is amazing. Thanks for sharing Kevin.
Great vid Kevin and helpful to surface this new tool. How does it stack up against Co-Pilot or GPT?
Thanks! Copilot does cost significantly more since it requires both a Microsoft 365 license and a separate subscription. Feature-wise, this tool is currently ahead-you can work across multiple tables, while Excel limits you to one table at a time and doesn’t generate dashboards. ChatGPT is more text-based and doesn't offer data manipulation after analysis.
i agree, it looks like a geme changer! Thanks for sharing!
Thanks for watching!
Wow . Thank you very much . Waiting more AI videos
Fantastic love it soooo useful ❤
Great content as always! Thanks a lot, I love your work.
The best AI content I've ever watched
This is awesome❤! Thank you Kelvin!
Also I'm wondering if you have a local model of open interpreter on your computer could that do the same thing?..
Amazing what AI can do, thanks Kevin.
Can you export the information in Excel?
Yup! In the grid view, go up to Menu, then Export, and it'll export an Excel .xlsx file.
Love this info Kevin, Thanks for sharing.
Possible to import an existing MS Excel spreadsheet into this?
Yes! In the grid view, click on Import on the top bar and you can bring in an Excel spreadsheet. You can also import directly from the home screen.
Thanks Kevin, just superb
Hey Kevin,
Thank you for sharing such great content and new apps. I'm trying the bricks, but unfortunately, I cannot get any results. My file is fairly large (122 MB) and I have uploaded the source data. It's our sales reports information. My prompts are pretty simple and I get good responses but I don't get any reports back. No tables, no charts and etc.
Thanks for sharing 👍🏻
My pleasure 😊
Sounds and looks amazing, but there is no way my company would allow me to save and share something like that online without any guarantee of data security.
I noticed that there was an 'Export' function for the pie-chart, IF this allows the user to download the whole spreadsheet + dashboard to Excel that might work better?
You can export to Excel. In the grid view, go up to Menu, then Export, and it'll export an Excel .xlsx file.
your videos are outstanding and awesome.
Does the worksheet show the formulae used in generating the new columns?
Thank you for this video Kevin 😊
This is amazing
After all that how to download the actual final data in your computer as a excell document
In the grid view, go up to Menu, then Export, and it'll export an Excel .xlsx file.
This is awesome.
Thank you Kevin
Thanks Kevin, very interesting.
Interesting but the goal of KCC is to maximize profits, so more useful to management are the statistically significant inferences to be drawn from available data beyond the spread sheet per se. For instance, AI might suggest that there is a relationship between monthly weather or seasonal climate and the varieties of cookies preferred by buyers. Thus chocolate chip will be favored in the upper planes states in cold months but not in Fla. during spring and summer, when almond cookies sell well. NOAA says that CA will be wet next month and, in the past, that's when lemon creams have sold well but sugar cookies age on the shelves. Shelf space is limited so these data are marketable to grocers.
Take longer lunch breaks
😂 I agree
Is there an export to MS Excel? It would be great to free the Bricks spreadsheets from the Bricks app and leverage these to use, tweek & totally own on Excel.
This is a game changer, I'm so excited
I wonder if when it's done you can download it for Excel to open
Thanks! Looking for this kind of solution for months..
How is it working out for you?
Once I prepare all this in AI, can I export it in excel and use it as a regular sheet with formulas for new data?
Thank you, your video is very helpful
Keviiiiiiiiiiiiiiiiiiiiiiin... You are amazing! 🎉🎉
Love this ❤
Fantastic!!! 🙂
Great, more like this Kevin.. thanks
Cool. Can you export the final file to Excel? We wouldn’t be able to access Bricks at work but if we could crunch it on our home computer than send an Excel file that would be fantastic!
Yes! You can export to Excel. On the grid, click on Menu and then Export. You’ll get a .xlsx file.
This is comment I was looking for
Kelvin, this is groundbreaking 😊
Cam this Ai tool save or download the data with excel format ?
If you tell management about it they are going to give you more work. That’s a givin!
I think this is a serious competitor for Power BI 😮
Amazing Kevin
How did the AI know to use Oregon and nor Maine for the Portland state?
My guess - when ambiguous, AI defaults to the Portland more frequently mentioned or widely known in global datasets, which often turns out to be Portland, Oregon.
Wow, this is great!
There is a town called Portland in at least two other states. There are probably other Portlands as well.
Thank you for nice tutorial.
Had a little play with the dummy data provided by Bricks and found an issue - I couldn't find a way of changing the date format to ddmmyyyy - there is an option in a menu but that didn't apply to all - I am assuming this must be possible but it wasn't immediately obvious and when I did try the option of changing the cells, it didn't work. I assume I must be doing something wrong with this!
To the left of the column name, you should see an icon to change the data type of the column. In that menu, hover over date and then select DD/MM/YYYY. I just tested and it works on my end. Let me know if you're still running into issues.
@@KevinStratvert Many thanks, I will give it a go later
You've got to be kidding me. Interesting!
Definitely amazing
Does this tool output can be exported to Excel? And does it Excel compatible?
Can you use this tool across multiple related spreadsheets?
Do you have any ideas of how a teacher could use this AI spreadsheet to keep a gradebook?