Excel Copilot 2: Understand

preview_player
Показать описание

This short video shows how to use Copilot (built into Excel) to help understand the data in our worksheets. Specifically, it will help us understand revenue by creating a pivot table and chart, understand our employees with a formula based report, and help us understand sales transactions and margin with a pivot table.

Also, check out these videos with time saving Excel Hacks:

Chapters in this video:
00:00 - Introduction
00:11 - Exercise 1
01:17 - Exercise 2
01:57 - Exercise 3
Рекомендации по теме
Комментарии
Автор

How do I get Copilot in Excel? I'm using Microsoft 365. I may have missed that video. Thank you!

thelitdave
Автор

I am guessing Exercise 2 distinct count didn’t use Power Pivot. What formula(s) did it generate ?
PS: Videos 1 & 2 provide a great overview especially since many of us don't have access to it. Thank you.

alexb