|
You’re tracking the numbers. But do they mean anything? 📚 More hours studying. 📈 More money on ads. 💤 More steps before bed. Are they actually making a difference, or are you just hoping they are? Most people guess. Smart ones use a simple Excel function to find out. It’s called RSQ, and it tells you how much one thing affects another. Never heard of it? You’re not alone. We ran a quiz last week and only 10% of our community got it right. 👀 When you do get it, everything changes. No more gut feel or eyeballing charts. Just clear, math-backed answer to: “How much of an impact is it making?” We break it down in our blog post:
📁 Free workbook so you can try it right now. The second you use it, you'll stop guessing—and start seeing the truth behind your numbers. 🤓 Geeky News📊 Excel Data Types now more visibleData Types in Excel let you pull extra info about: 💱 Currencies 🏦 Stocks 🗺️ Geography Example: Enter a currency pair like Cells with these data types get a slick little icon, so you know they’re “special.” Click it, and a whole preview panel opens up with hidden info inside. But up till now, the formula bar stayed totally clueless. That’s changing. Microsoft is rolling out value tokens. Now, you’ll see a visual cue in the formula bar and in edit mode when a cell contains a rich data type. (Kinda similar to Google Sheets' smart chips. 🧐) No more wondering if the cell is just text or secretly packed with rich data. Less risk of accidental overwriting and breaking the linked connection. Small change for now, with a promise of more to come. 🤖 AI News RoundupA lot's happening in the AI world. Here's your chance to catch up. 🖼️ ChatGPT gets a new image model Dead giveaways of an AI-generated image? Six fingers and wonky text. It might be a thing of the past, as ChatGPT replaces DALL-E 3 with GPT-4o image generation. It promises cleaner, more photorealistic results and actually readable text. 🧠 Copilot gets “deep reasoning” powers Microsoft rolls out two new AI agents, "Researcher" and "Analyst". They're supposed to pull off multi-step research and complex analysis. Available (for now) to early-access M365 Copilot users. 💬 New Copilot interface Meanwhile, Copilot Chat is getting a facelift. Chat history moves to the left panel, making it look more like ChatGPT. You can also switch between the "Quick" and "Think Deeper" modes for faster or more thoughtful replies. You'll find a similar experience in the new Copilot app that's just now rolling out to all Windows 11 users. 🌈 New Gemini Model from Google Not to be outdone, Google announced that it's latest model, Gemini 2.5, is also a "reasoning" model, capable of handling complex prompts. Plus, it's integrating Gemini into Chrome browser and even the Windows taskbar. 🗺️ Did You Know?If you never used rich data types, you can see them in action here: 🌍 The Fastest Way to Research Country Data in Excel #shorts No more googling, no AI needed. Pull the country details in just a few clicks 👏 Power StoriesStill stuck updating reports manually? You’re not alone. Sepp was in the same boat - juggling spreadsheets and chasing outdated stats across his company. He decided enough was enough. And enrolled in Fast Track to Power BI.
This is what leveling up looks like: faster reports, less manual work, and more time for the stuff that matters. Got a success story of your own using your XelPlus skills? Hit reply to share it, and inspire others to power up too 💥 See you next week, Leila Want more?▶️ Subscribe on YouTube 🖇️ Follow us on LinkedIn 🥇 Join 400,000+ students 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! |
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.
Performance review season is coming up. Your boss wants numbers. Growth numbers. Specifically, year-over-year growth. When you can quickly show revenue grew 17% YOY and EBIT jumped 23%, you're telling a story. You're showing you understand what moved. I put together a step-by-step guide on calculating YOY growth in Excel. It covers: The exact formula to use (simpler than you think) How to format it so it actually looks professional A conditional formatting trick so trends are obvious at a...
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...
You know that chart exists. You made it. It's in this workbook somewhere. Sheet14? 16? Who named these sheets anyway? Excel has a Navigator for this. Most people still don't know it's there. View > Navigation. It opens a pane on the side with a list of all your tabs. You can easily jump between them. Expand any tab, and you'll see an overview of all the contents in the sheet. All your tables, pivot tables, charts, slicers, and any other objects, like shapes and pictures. Use the search box to...