|
Printing an Excel sheet should be a two-second job. Ctrl+P, hit print, done. You expect 2 pages. You get 20. And you have no clue what you're looking at, because the headers are missing. The chart's cut in half. So you try to shrink it to fit. Now you need a magnifying glass to read anything. And yes, this happens with PDFs too. "Print to PDF" doesn't save you from any of it. It just makes the mess portable. I remember the first time I bothered to actually find the settings (yep, it took a while) and create a printout with page numbers, my boss looked at me and said, "You can add page numbers in Excel?! I thought only Word could do that!" Here's the good news: almost every printing disaster in Excel comes down to the same handful of settings, and once you know where they are, you can fix any of them in under a minute. ๐ I put together a printing walkthroughโ None of this is complicated. It's just scattered across menus nobody opens more than twice a year, which is exactly why it feels harder than it is. ๐ค Geeky News๐ค Your regular Copilot can now talk to Power BIMicrosoft 365 Copilot (the one in Word, Excel, Teams) can now answer questions straight from your published Power BI semantic models. Ask "what was revenue last week?" in Copilot Chat, and it pulls a grounded answer. You don't have to open Power BI and hunt for the right report. Copilot does it for you. Before you get too excited: this doesn't mean that you can now build reports or write DAX with your standard Microsoft 365 Copilot license. Power BI Copilot is still a separate product, gated behind paid Fabric or Premium capacity. What's new is asking questions, not building the model. Good reason to make sure it's actually modeled well. ๐ โ๏ธ Your company can now write its own Copilot promptsAdmins can publish custom prompts into Microsoft 365 Copilot Chat, tuned to your org's own terminology and workflows. Users see them as "Suggested" prompts right under the chat box, or browse the full library in the Prompt Lab, searchable by keyword or filtered by department. Pick one, fill in the blanks, done. Only shows up if your admin actually bothered to set it up, so don't be surprised if your "Suggested" section is empty. ๐ค Did You Know?Are you someone who forgets to rename their tables? It's all Table1, Table13...? Too much hassle to go to Table Design every time? You can pin the Table Name box to your Quick Access Toolbar. Now it's sitting right at the top, visible no matter which tab you're on, so you can rename a table without hunting for it. ๐ See how it's done. ๐ 20% of the timeWhen we think of automations, we tend to think of big things. But they don't have to be complicated. Sometimes it's just one function that saves you from searching by hand. Yerney is a senior technologist. This is what he shared after completing Excel Essentials for the Real World: Congrats, Yerney. That's the way to go. Solid foundation and implementation first, then advanced stuff later. 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! |
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.
When I worked in finance, the reports I had to build almost always came from more than one sheet. A lot of copy-pasting. These days one formula can do that for you. It's called VSTACK. It stacks your sheets into one list. It stays live, works in Excel Online, and anyone who opens the file knows exactly what's happening. Most people who use VSTACK, use it to glue two ranges together, and think that's it. But that's barely scratching the surface. I put together my top 6 VSTACK tips in this new...
The most common way people mess up their own spreadsheets is a button sitting right there on the Home tab. Merge & Center. It's one of the first buttons anyone learns in Excel, and it does exactly what it says: centers a title, makes a header look tidy. The trouble starts the moment someone uses it inside the data instead of just the header row. Try to sort... yep, it doesn't work. Try to sum a column with a merged cell sitting in the middle of it. Column E, for example: Exactly. You'd have...
What do you do when your data goes wide? Picture a sales table with one row per rep, but then Sales_Jan, Units_Jan, Sales_Feb, Units_Feb, and so on, all the way to December. It just keeps growing wider with every month you add. Try to filter by month, or build a pivot table around it, and you're stuck. Month isn't a value in this table. It's baked into the column headers. You need a way to turn the wide into long so that it's ready for analysis. And there's a Python function that does exactly...