Avoid common Excel errors by ditching INDIRECT for better alternatives.
👩‍🏫 Master Power Query with my course: https://bit.ly/indirect25course
⬇️ Download the example file here and follow along: https://bit.ly/indirect25file

Let’s talk about a function that…

Microsoft Excel Tutorial: Easily locate the active cell using shaded crosshairs in the grid - introducing the Focus Cell feature.

Discover a brand-new Excel feature that makes it easier than ever to spot the active cell in your spreadsheet—no matter how…

Microsoft Excel Tutorial: Upload Image from Phone to Copilot and Extract Text to Grid

Tired of the clunky “Data From Picture” tool in Excel? In this quick video, MrExcel shows an exciting new way to extract text from images using Copilot and your mobile…

Microsoft Excel Tutorial: Using the Date Picker in Excel Online.

Discover the hidden Date Picker tool in Excel Online and learn how to quickly enter and adjust dates in your spreadsheets using this built-in calendar. In this video, MrExcel demonstrates the…

Power Query vs Power Pivot vs VBA – which one to use in Excel and when. Learn how to clean data, build dashboards, and automate tasks.
⬇️ Download the cheat sheet here: https://bit.ly/exceltools25file
👩‍🏫 Master Power Query with my course: https://bit.ly/exceltools25pq…

Microsoft Excel Tutorial: Create a Custom Copilot Agent in Excel to Search YouTube Transcripts

Buy the new book on building Copilot Agents or Custom GPT: https://books.by/holymacrobooks/train-your-own-gpt

Discover how to build a custom agent in Copilot…

We always lookup 1.

~

XLOOKUP is one of the most powerful and useful XL functions ever. In this video, learn how to take your XLOOKUP skills to next level and impress everyone with a sneaky little trick, by looking up 1.

Topics covered:
✔️ How to do multi…

Как заставить вашу сводную таблицу в Excel автоматически обновляться при изменении исходных данных.
Скачать пример https://www.planetaexcel.ru/techniques/8/58518/

Мои книги http://planetaexcel.ru/books/
Мои онлайн-курсы https://www.planetaexcel.ru/learning/…

Auto-Refresh for PivotTables is here, and it’s a game-changer! In this short but powerful video, MrExcel shows off a brand-new feature currently in the Insiders Fast build: PivotTables that update themselves automatically as your data changes. Whether you’re…

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/excelisfun/EMT1900-PivotTableAutoUpdate.xlsx
Learn about the unbelievable new PivotTable Auto Refresh feature that makes PivotTables instantly update when source data changes. It makes the…

Tired of copy-pasting the same table 12 times for 12 different teams? Stop. There’s a faster way—and it doesn’t involve scary macros that could blow up your spreadsheet. In this quick Excel tutorial, I’ll show you how to crank out multiple worksheet variations…

By Sam Lowrie

Download files here https://www.wiseowl.co.uk/power-apps/videos/power-apps/create-canvas-app/

This second video in our Power Apps series explains how to set up a basic canvas app from data. You'll learn how to work with app screens, display…

By Sam Lowrie

Part 3 of our Power Apps series shows you how to work with controls. You learn how to create and edit text boxes and images and various techniques for formatting these objects. You'll also see how to add screens and create buttons to navigate…

Stop Excel from quietly breaking your Conditional Formatting rules every time you insert a row.
👩‍🏫 Master Excel & Power BI with my courses: https://bit.ly/condromatting25courses
⬇️ Download the example file here and follow along: https://bit.ly/condromatting25file…

Microsoft Excel Tutorial: Filtering comments in Excel based on Resolved or open.

In this video, MrExcel dives into the latest improvements to Excel's commenting system, showcasing new features that make collaboration and task assignment smoother than ever.…

Microsoft Excel Tutorial: [Description]

Microsoft Excel just made coding with Python significantly easier. In this quick walkthrough, MrExcel highlights the brand-new Python Editor available through Excel Labs. This feature offers a full IDE-like experience…

By Sam Lowrie

Download files here https://www.wiseowl.co.uk/power-apps/videos/power-apps/data-table/

This video explains how to display data in your Power Apps canvas app. You'll learn how to connect to a file stored in OneDrive, how to display this data…