|
There's a person on almost every team that everyone respects technically. And nobody wants to work with. Maybe you've sat in a meeting with them and left feeling a little smaller than when you walked in. Early in my career, I think I was sometimes that person. You see, I went by the advice "work hard and you'll be noticed" for years. Turned out to be the worst advice I ever got. What I missed for a long time: doing my job well was expected. That's why I was hired. But it wasn't what was going to get me promoted. Everyone talks about the importance of skills and network. I was the same. But over the years I noticed there was a third thing that mattered just as much, and I'd been completely ignoring it. Recently I've been thinking about it and made a short on it. ๐ค Geeky Newsโฑ๏ธ Windows Clock is becoming a focus toolMicrosoft is redesigning the Clock app's Focus Sessions feature. Bigger task pane, background music, customizable timers, and a Reflection check-in after each session where you rate how focused you actually were. There are also references to AI features in the code: things like breaking tasks into steps and tracking productivity patterns. Mostly student-focused for now, and requires newer hardware. Still early. A lot of it shows "Coming soon" placeholders. But if you use Focus Sessions already, the upgrade looks promising. ๐ Gemini in Google Docs now remembers your preferencesGood news if you're using AI in Google Workspace. You can now give Gemini standing instructions in Google Docs. Things like "always use bullet points" or "keep it concise and professional." Set it once, and it applies every time. No need to repeat yourself every session. Rolling out now to most paid Workspace plans. ๐ Office LTSC 2021 end of support: six months to goIf your organization is still running the 2021 perpetual Office license, October 13, 2026 is the date to know. After that, no more security patches, bug fixes, or technical support. Microsoft's recommended path is Microsoft 365. If moving to the cloud isn't an option, Office LTSC 2024 is the supported on-premises alternative. Worth flagging to your IT team if you haven't already. ๐ Welcome back, ClippyMicrosoft quietly moved the Copilot button from the Excel ribbon into the grid. It now floats inside your spreadsheet. There's no way to hide it. You can dock it to make it less obtrusive... ...but it resets every time you open a new file. ๐ ๐ Finally finance fluentSome people stay quiet in finance meetings. Not because they don't have anything to say. Because they don't fully understand what's being discussed. The ratios, the statements, the terminology... it all flies past and you find yourself just nodding along. I've been there. So has Michel. After taking Fundamentals of Financial Analysis, here's what he said: If that nod-and-hope feeling is familiar, take a look at how the course can help you. See you next week, Leila P.S. I've been busy working on my keynote for the Global Excel Summit. It's not too late to register. 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! |
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.
You've got a long list like this that needs to go into separate columns. Copy-paste? Nope. From now on copy-paste is officially banned for this type of work ๐ซ There's a single function that does the whole thing in seconds. ๐ Here's how it works Imagine copy-pasting 500 contacts! My wrist cramps up even thinking about it. ๐ค Geeky News Copilot in Outlook now handles your calendar Microsoft just made Copilot in Outlook agentic. Meaning it doesn't wait for you to ask. It sorts through your inbox,...
Quick question. How many working days are left until your project deadline? Not calendar days. Working days. No weekends and no public holidays. And no that-week-everyone-takes-off-in-August. Most people subtract two dates and call it done. Then wonder why the timeline is slightly off. Excel has a function built for exactly this. Custom weekends, holidays, even non-standard working schedules. ๐ Watch how it works and grab the practice file ๐ ๐จ๏ธ Someone asked in the comments: what if you need...
For years, I did something I'm a little embarrassed to admit now. Every time I needed to present pivot table data, I'd copy it out. Paste it as values into a separate sheet. Then format it manually. My pivot table stayed hidden in the background like a rough draft nobody was allowed to see. Why did I do this? Pivot table default styles are just ugly. Nothing to impress management with. It never occurred to me that the pivot table itself could look like this: Yes. That's a pivot table. Fully...