The AI Spreadsheet We've All Been Waiting For

About this video

Kevin Stratvert demonstrates Bricks, a free AI-powered spreadsheet app presented as an alternative to Excel and Google Sheets that does analysis with natural-language prompts instead of formulas. After signing in, he pastes Kevin Cookie Company sales data, which Bricks auto-converts to a table he renames Sales Data. Using the ‘Ask the AI to do anything’ prompt box, he splits a conflated product/location column into separate product and location columns, adds a state column for each city, and pulls in unit cost from a second table — a task he says would normally require VLOOKUP or XLOOKUP — verifying oatmeal raisin at $2.25. He then prompts for total revenue (units sold multiplied by unit cost), a best-selling products table (chocolate chip on top, Snickerdoodle worst), a pivot table for revenue patterns, and a forecast for next month that Bricks says uses simple linear regression. Finally he prompts for a dashboard with tables and charts, shows its components remain editable with live updates from the grid, uses AI writing help to rewrite dashboard text, and shares via Present mode, link, email, or publishing.

Key takeaways

• Bricks is free to sign up for and its Grid works like a standard spreadsheet with functions such as SUM, but pasted data is automatically converted to a table to help the AI analyze it
• Natural-language prompts can clean data without formulas: split a combined product/location column, extract location, and add the state for each city
• The AI can join tables by matching product names to pull in unit cost — e.g., oatmeal raisin at $2.25 — replacing a manual VLOOKUP/XLOOKUP workflow
• Further prompts generate total revenue, a best-selling products table, a pivot table of revenue by product and location, and a forecast the tool says is based on simple linear regression
• A single dashboard prompt creates an editable dashboard of charts and tables that updates when source data is edited, and can be presented, shared by link/email, or published

Episode details: published November 11, 2024 · 10:45 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Kevin Stratvert’s own claims, shared for education — they are not typical or guaranteed.

← Previous: DaVinci Resolve Tutorial for Beginners · Next: How to Remove Background in Photoshop →

All Kevin Stratvert videos · Kevin Stratvert profile · Kevin Stratvert on YouTube