I kept closing Copilot Chat the second it popped up.

Every time I logged into Microsoft 365, there it was:

I just wanted to get to my apps. This new interface felt like one more thing in the way.

Well, finally I gave in. Started experimenting to see which prompts could actually reduce friction.

For example, I don't look forward to going through unread emails on Monday morning. Especially when I see 47 emails waiting for me. That's friction.

I also waste a lot of time looking for files. I don't remember the name. I don't remember where I saved it, but I know it's there somewhere. And search in Explorer is useless for me 90% of the time.

So I wanted to see if Copilot could help with this. Turns out, there are more things it can do than I expected.

I put together a video walking through all 10 prompts:

​

You can copy all 10 prompts and adjust to your needs:

One thing to note: Microsoft says Copilot Chat is free, but most of these prompts need the paid license to actually work. Here's what's included in free vs. paid.

🤓 Geeky News

🕸️ Excel for the Web gets full Power Query experience

Microsoft has released something major without a big fanfare.

Excel for the Web finally has full Power Query. Yes, that includes data import and transformation.

Until now, all you could do on the web was refresh existing queries.

Now, you can connect to databases, web sources, and files - as long as they're stored in OneDrive for Business.

But what's neat is that you can browse for the file and the correct OneDrive link will be populated for you.

You get the modern Get Data interface, as well as a modern Power Query Editor.

All the PQ features you know and love are there, just with a fresher design.

Except... you can load the data as a table or connection only.

No pivot table. And no data model either (Power Pivot is not supported on the web).

Don't worry if you don't see the updated interface yet. It's likely rolling out in stages. It's already included in the official support docs, so you can be sure it's coming

👥 Teams finally lets you multi-task

Another long-overdue update: Teams finally lets you pop out apps into separate windows.

Let's be honest: Teams as an all-in-one app never really worked. Because every time you switched between a team, chat, or calendar, you broke your flow.

They added pop-out conversations a while back, but that didn't fix it. If you needed to chat with someone new, you still had to leave the channel.

Finally, you can open each thing in its own window. Just right-click and "open in new window".

Arrange the windows the way you need and switch tasks without closing everything.

Works for channel tabs too. Pop out the planner while keeping your project file and chats open.

You're the master of your workspace.

📝 OneNote adds proofing language control

OneNote on Windows now lets you set a proofing language for an entire page or as a default.

Before this, it just followed your keyboard language at the paragraph level.

Useful if you work across multiple languages. Go to Review > Language > Set Proofing Language.

Rolling out now to Version 2512 or later. Should hit everyone by end of January.

🙌 Days to minutes. That's what we love to see

Kayleigh, a Financial Controller, just told us what Power Query did for her team.

Cleaning messy data still tops every survey as the number one Excel struggle.

The solution is sitting in the Data tab (now even on the web 😉)

See you next week,

Leila

Want more?

▶️ Subscribe on YouTube​

🖇️ Follow us on LinkedIn​

🥇 Join 400,000+ members in our courses​

📣 Want to sponsor Between the Sheets? Get in touch here.

📨 If you were forwarded this message, you can get the free weekly email here.

This newsletter contains affiliate links, which give us a small commission on any purchase made at no cost to you. This helps us run Between the Sheets and bring you updates like this. Thank you for your support!