Tired of struggling with PivotTables, charts, and slicers to build dashboards in Excel? Thanks to Excel’s brand-new Agent Mode (aka Excel’s “AI Beast Mode”), creating an interactive dashboard has never been easier. In this step-by-step tutorial, I’ll show you how to use Agent Mode inside Excel Labs to automatically build a dashboard from raw dataContinue reading “Create Interactive Dashboards in Excel with Agent Mode”
Tag Archives: Excel
Excel Just Got Smarter — Meet the NEW =COPILOT() Function
Excel just got a huge AI boost — the brand-new Copilot function lets you type =COPILOT directly into a cell, reference your data, and get instant answers or insights right in your spreadsheet. In this tutorial, I’ll walk you through: Whether you’re organizing feedback, summarizing data, or creating fun, dynamic content, Copilot in Excel canContinue reading “Excel Just Got Smarter — Meet the NEW =COPILOT() Function”
Excel Tutoring for Beginners – Learn Formulas & Functions Step-by-Step
If Excel formulas and functions have ever confused you, you’re not alone. In this step-by-step tutorial, you’ll learn exactly how to use formulas and functions in Excel—even if you’re just getting started. We’ll cover: The difference between formulas and functions, how to perform calculations like sum, average, and max, the powerful IF function for logic,Continue reading “Excel Tutoring for Beginners – Learn Formulas & Functions Step-by-Step”
How to Create Drop Down List in Excel (2025)
Learn how to create dropdown lists in Excel to make data entry faster, more accurate, and user-friendly. This tutorial covers everything from basic dropdown lists to dynamic lists that automatically update when you add or remove items. Whether you’re making an order form, a project tracker, or a data validation system, Excel’s dropdown feature canContinue reading “How to Create Drop Down List in Excel (2025)”
Stop Learning Excel—Meet the AI Spreadsheet
Mastering Excel used to mean memorizing complex formulas like VLOOKUP, creating pivot tables, and manually sorting data. But now, AI spreadsheets are here to change the game! In this video, I showcase 7 ways AI makes spreadsheets effortless, even for beginners. With Bricks, an AI-powered and free spreadsheet tool, I’ll demonstrate how you can: WhetherContinue reading “Stop Learning Excel—Meet the AI Spreadsheet”
How to Write the Perfect Prompts for Microsoft Copilot
Did you know that the quality of your prompts in Microsoft Copilot directly impacts the responses you get? A prompt is essentially a set of instructions you give to Copilot, and the more detail you provide, the better the output. Here’s how you can master the art of prompting to get the most out ofContinue reading “How to Write the Perfect Prompts for Microsoft Copilot”
How to Create Barcode in Excel – FREE & No Install
In this step-by-step tutorial, learn how to make barcodes in Microsoft Excel, and the best part is, it’s completely free and you don’t even need to install anything. Follow along whether you’re using the Excel desktop version or Excel for free on the web. Whether you’re managing inventory or just want to learn something new,Continue reading “How to Create Barcode in Excel – FREE & No Install”
Create Dependent Drop Down Lists in Excel – EASY METHOD
In this step-by-step tutorial, learn how to create dependent dropdown lists in Excel. This feature allows you to select a value in one dropdown list that influences the available options in subsequent dropdown lists. It’s an incredibly useful tool for creating dynamic and interactive forms, and I’ll show you just how easy it is toContinue reading “Create Dependent Drop Down Lists in Excel – EASY METHOD”
Kevin Stratvert 