Uploaded September 2024 | Updated November 2026, 3 hours ago
I have been using CoPilot to work faster with Excel. Don't tell my boss though, he thinks I am doing all the hard work π
In this video:
==========
0:00 - What is CoPilot for Excel and how to enable it?
1:30 - How to use CoPilot to clean your data?
3:13 - Using CoPilot to write formulas
4:48 - CoPilot and natural language queries
6:58 - Complex analysis scenario with CoPilot
8:52 - Making Pivots with CoPilot
10:12 - Tips & Tricks of using CoPilot
11:16 - Asking CoPilot to find insights on its own
13:04 - Alternatives to CoPilot in Excel
πΈ CoPilot Requirements:
====================
learn.microsoft.com/en-us/copilot/microsoft-365/microsoft-365-copilot-requirements
π Sample file (to play with CoPilot):
==============================
Download this file and use it to understand how CoPilot works.
chandoo.org/wp/wp-content/uploads/2024/09/copilot-howto.xlsx
π€ More AI videos:
================
10x your productivity with these AI tools in Excel - youtu.be/xGqH__hLVcU
ChatGPT made this Dashboard for me - youtu.be/mp18miYmmJY
How to use ChatGPT to improve your Excel skills - youtu.be/EsT5TNwbBVM
AI + Data Playlist - youtube.com/playlist?list=PLmejDGrsgFyBh9sO5sD_PY9nZblKjfFX5
~
I asked CoPilot "How to fly better?"
It just made a drawing of a butterfly π¦
We are not talking any more π€π₯π€
#copilot #excel
I have been using CoPilot to work faster with Excel. Don't tell my boss though, he thinks I am doing all the hard work π
In this video:
==========
0:00 - What is CoPilot for Excel and how to enable it?
1:30 - How to use CoPilot to clean your data?
3:13 - Using CoPilot to write formulas
4:48 - CoPilot and natural language queries
6:58 - Complex analysis scenario with CoPilot
8:52 - Making Pivots with CoPilot
10:12 - Tips & Tricks of using CoPilot
11:16 - Asking CoPilot to find insights on its own
13:04 - Alternatives to CoPilot in Excel
πΈ CoPilot Requirements:
====================
learn.microsoft.com/en-us/copilot/microsoft-365/microsoft-365-copilot-requirements
π Sample file (to play with CoPilot):
==============================
Download this file and use it to understand how CoPilot works.
chandoo.org/wp/wp-content/uploads/2024/09/copilot-howto.xlsx
π€ More AI videos:
================
10x your productivity with these AI tools in Excel - youtu.be/xGqH__hLVcU
ChatGPT made this Dashboard for me - youtu.be/mp18miYmmJY
How to use ChatGPT to improve your Excel skills - youtu.be/EsT5TNwbBVM
AI + Data Playlist - youtube.com/playlist?list=PLmejDGrsgFyBh9sO5sD_PY9nZblKjfFX5
~
I asked CoPilot "How to fly better?"
It just made a drawing of a butterfly π¦
We are not talking any more π€π₯π€
#copilot #excel

![Excel SCAN Function is Shockingly Powerful! [Step-by-Step]
Every heard of SCAN function in Excel? Today, let me show you why you need this function and how it changes the way you solve your data problems. I think SCAN is Magic β¨
You are going learn:
What is SCAN function in Excel
SCAN syntax and application
How to use SCAN to calculate running total quickly
Using SCAN to get Maximum values
SCAN with LAMBDA
Advanced SCAN usage when your data is dynamic
~WHAT IS SCAN FUNCTION~
Scan function in Excel lets us run an operation on a range and returns all the intermediate results.
For example, you can use SCAN function to calculate running total of a range.
~WHAT IS THE SYNTAX OF SCAN~
SCAN(initial_value, range or array, operation)
For example:
=SCAN(0, A1:A10, SUM)
is going to return the running to of the range A1:A10
You can also use LAMBDA functions with SCAN to create more complex calculations.
=SCAN(0, A1:A10, LAMBDA(a, b, SUM(a,b)))
will return the same values as the first SCAN example above.
β± Video timestamps:
0:00 - What is SCAN function & Why it is important?
1:46 - Understanding how SCAN works
3:46 - Using SCAN to calculate running MAX
4:57 - Using LAMBDA functions with SCAN
6:38 - How I use SCAN to solve tricky problems
πΊ Watch next
How to use LAMBDA function in Excel - https://youtu.be/YrMCkE59ef4
How to use FILTER function in Excel - https://youtu.be/JuTdj2j-9Kg
Top 10 Essential Excel functions - https://youtu.be/HgNCvd8IbSc
π Sample Workbook:
If you need a file with SCAN examples, download the scandoo.xlsx here:
https://chandoo.org/wp/wp-content/uploads/2024/03/scandoo.xlsx
~
What is the favourite Excel function of a German Shepard πΆ?
LAMBda... π
#Excel #functions Excel SCAN Function is Shockingly Powerful! [Step-by-Step]](https://i.ytimg.com/vi/VrQSgI596IQ/mqdefault.jpg)








