Stop Learning Excel—Meet the AI Spreadsheet

About this video

Kevin demonstrates Bricks, described as a free AI-powered spreadsheet, by importing a sample Excel workbook and using natural-language prompts instead of formulas for seven tasks at the fictional Kevin Cookie Company. First, prompting ‘pull in the price into cookie orders’ from the Products table joins the tables like a VLOOKUP/XLOOKUP — verified in the video with chocolate chip at $3.25, Snickerdoodle at $2.50, and Double Chocolate Chunk at $3.75 — and a follow-up prompt calculates order revenue as price times quantity. The other tasks are: sorting by product alphabetically and then by revenue largest to smallest; conditional formatting via ‘highlight all rows where order revenue exceeds 50,’ which updates live when a value drops to 48; advanced filtering to a new table showing only three cookie types from a filters table; grouping/summarizing with ‘show me revenue by location,’ which generates a pivot table of summed revenue by location; chart creation, where asking for a suggestion produces a bar chart of revenue by location that can then be edited manually; and removing duplicates based on first name, last name, and email, illustrated by a duplicate John Doe newsletter signup. Bonus tips cover data validation in Bricks tables: setting a date data type with a date picker, using tags as a dropdown limited to listed cookie types such as chocolate chip and sugar, and using a checkbox for fulfilled status. The result can be exported back to Excel format from the menu.

Key takeaways

• In Bricks, a plain-language prompt can join tables and pull in a price, replacing VLOOKUP/XLOOKUP/INDEX-MATCH for beginners.
• Multi-column sorting, conditional formatting, filtering, and grouping into a pivot-style summary can each be done with a single prompt.
• Conditional formatting created by AI is live: changing a revenue value to 48 removes highlighting that required it to exceed 50.
• Asking the AI to suggest a chart both recommends and generates a bar chart, which can then be edited manually for full control.
• Use data types to enforce valid entry — date pickers, tag dropdowns with fixed options, and checkboxes — and export the finished work back to Excel format.

Episode details: published December 13, 2024 · 12:29 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: How to Add Booking Form to Your Website | Calendly · Next: Semrush: 5 AI SEO Hacks to Rise Above Your competition 🌅 →

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