If you've watched my videos, you know what happens the moment I insert an Excel table.

That's right. First thing, I'm in Table Design, stripping out that default formatting.

I like it clean. Light borders, no banded rows, no colorful header. We all have our preferences. Cell and number formats. Functions you know work best.

And that's exactly the problem with Copilot. As it gets more capable, building all kinds of things for you, it builds them the way it wants. Unless you're specific.

So you end up writing a prompt that's longer than just doing it yourself. Sometimes.

Well. Copilot in Excel just added Personalization. Tell it once how you like things and it remembers. Across workbooks. Across devices. No more repeating yourself every time.

I tested it, and I'm sharing what happened in the latest video. Plus some personalization ideas you might want to steal.

​

💪 Test Your Power Query Skills

Quick reminder: the Power Query Challenge Pack is still at its launch price through June 30.

What's inside: 15 real-world challenges at different difficulty levels. Messy data. No hand-holding. Work through each yourself, then check your approach against the video solution.

And it's not a static pack. We're adding more challenges over time. The next one lands next month.

🤓 Geeky News

🤖 Google Sheets now helps you fix broken formulas

You know that moment when a formula throws an error and you have no idea why. Google Sheets now has a one-click fix for that. Gemini looks at the formula, checks the surrounding data, explains what went wrong, and suggests a corrected version.

Works for everything from basic arithmetic to the kind of formula that takes up three lines.

Rolling out now on paid Workspace plans.

Oh, and Gemini in Sheets now works in 28 additional languages, including Spanish, French, German, Japanese, Arabic, and more. If English isn't your first language, worth checking if yours is on the list.

🌈 Google Calendar gets more colors

Google Calendar has had the same 11 event colors since forever. Now you get 24 defaults, plus a full RGB color picker if you want to get specific. Up to 200 custom colors per event.

Nobody asked for 200. But it's nice to finally have more than 11. 😉

🖥️ SharePoint is getting a facelift

Speaking of cosmetic changes... Microsoft is rolling out a visual refresh for SharePoint.

Cleaner layouts, better spacing, rounder corners, less visual noise. Your content stays exactly where it is. It just looks a bit less cluttered around it.

Nobody's workflow changes. It's purely cosmetic. But if SharePoint has always felt a bit... busy, this should help.

🌿 You have to make the bad ones first

At the Global Excel Summit last month, someone told me he couldn't make video tutorials because he hates the sound of his own voice. I was thinking about it during my walk and recorded this.

👏 Beyond what Salesforce could show him

Nelson works as a Salesforce Admin. He knows dashboards. He knows reports. He knows what those tools can and can't do. After completing Fast Track to Power BI, he shared this:

Nelson Rioux Salesforce admin specialist

The course gave me a comprehensive understanding of Power BI and made me aware of possibilities I hadn’t expected yet. Leila's course thoroughly prepares you to immediately apply the taught solutions in your daily work and provides insights into how you can bring even more value. This knowledge will allow me to deliver information that Salesforce reports and dashboards couldn't offer.

When your main tool has a ceiling, it's good to know what's on the other side of it.

See you next week,

Leila

When you're ready, here are some ways we can help:

🎓 Join 400,000+ members in our courses​

📺 Get free tutorials on YouTube​

👥 Train your whole team with our courses. Team pricing and progress tracking - reply for details.

This newsletter contains affiliate links, which give us a small commission at no cost to you. Thank you for your support!