|
I’ve built a lot of Excel dashboards over the years. They had slicers, dropdowns, checkboxes - the works. Not once did I think I’d put a play button on one. Last week I did. I described the report I wanted, and Copilot built it with the new interactive canvas in Excel, straight from the data in my workbook. The speed wasn’t what surprised me. It was what I could add. Sliders that update the whole report as you drag them, a Gantt chart with dependency lines between the tasks, even a bar chart race. It also pulled together data from different sheets without any setup on my side. You can see each of them in action in my latest video. Oh and a lot of you asked if this is VBA. It isn’t. The canvas is built like a little web page (HTML and JavaScript) sitting on its own sheet. That’s why it can do things a normal Excel sheet never could. 🤓 Geeky News📧 Classic Outlook needs an update todayIf you use classic Outlook on Windows, update Office today. Attackers are using a bug where opening one booby-trapped attachment makes Outlook quietly send a scrambled copy of your Windows password to their server. Microsoft rates it only “Moderate.” But out of 1,000+ bugs fixed this month, it’s the one that’s actually being exploited. To update, go to File > Office Account > Update Options > Update Now. Still on Office 2016 or 2019? No fix is coming for those, since support has ended. And while you’re in Outlook, a heads-up. Classic Outlook is also getting a new look from mid-November, with new icons and tweaked spacing. So if Outlook looks a little different next week, that part isn’t the bug. It's probably also not the reason behind Friday's global Outlook outage. 👀 📝 Word now spots fake headingsMaking text bold and bigger makes it look like a heading. But to Word, it’s still just regular text. That matters more than you’d think. Screen readers use real headings to jump between sections, so without them, people have to read the whole document top to bottom to find anything. Fake headings also won’t show up in your Table of Contents or the Navigation Pane. And Copilot leans on proper headings too, when it summarizes or works with your document. Now Word’s Accessibility Assistant can catch this for you. It flags text that’s styled to look like a heading but isn’t, long stretches of text with no heading at all, and headings that got split across several lines by accident. To try it, go to Review > Check Accessibility and look under Document Structure. It’s rolling out to Microsoft 365 Insiders on Windows first. 📽️ And if you want to know how to easily create a table of contents in Word, here's a quick demo. 🌈 Google Sheets canvas gets its own linkCopilot isn’t the only one building interactive reports from your data. Google Sheets has its own version, called Sheets canvas. You ask Gemini, and it turns your spreadsheet into a little app, like a dashboard, a task board or a calendar. Now you can share that app with its own link. People can click around and filter, but they can’t see or touch the spreadsheet behind it. The link also has its own sharing setting. So you can show the canvas to the whole company, while only your team can open the actual file. You can pick how it updates, too. Either it refreshes whenever the data changes, or it stays a snapshot of how things look today. To publish, click the icon in the canvas toolbar and choose Publish canvas. It’s rolling out over the next few weeks for paid Workspace plans and Google AI Pro and Ultra. 👏 Just one click of the buttonOlga didn’t wait long to put what she learned in Master Excel Power Query to work. Here’s what she shared: Congrats, Olga. If you’re the person who pulls everyone's data together every month, this is what it can look like: one click, and it’s done. See you next week, Leila |
XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlus’ bestselling courses are popular among financial analysts, CFO’s, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.
Here’s a little behind the scenes on the new Copilot course. There’s so much you can do with Copilot these days, so before planning what goes into the course, I sent out a survey with one main question: "What’s one task that takes you too long every week that you’d love to hand to Copilot?" 1,773 people answered. We went through the answers, grouped them by the task people wanted help with, and (in Excel) counted. Most of it wasn’t about using AI better, like writing better prompts. It was...
Every company has at least one Excel file that nobody fully understands. It usually belongs to someone who left. In my corporate past, I had to make sense of quite a few of those. Many sheets, lots of formulas and reports in every sheet. Once a file like that becomes yours, you’re the one who has to answer for its numbers, even if you didn’t build any of them. So how do you figure out where everything comes from? Excel has a few tools that help a lot here, and in this video, I go through 8 of...
Something that surprises a lot of people: Your Windows login doesn't have to be a Microsoft account. I get this question from time to time: "Can I switch to a local Windows account, and still use Excel and the rest of Microsoft 365 like before?" Yes. You can. Microsoft might show you a blue screen first before you continue (hmm the dreaded blue screen, although this time it's actually being helpful. Still, I wonder if they picked that color on purpose 😉) If you want to understand your options...