Your printer isn't the problem


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 BI

Microsoft 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 prompts

Admins 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 time

When 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:

Yerney Bโ€‹
Senior technologist

Before the course, I never really got to use functions, my way of working with Excel was very basic and repetitive. Now I can complete most of my work in 20% of the time prior to taking this course. Got a solid foundation to continue with advanced courses, already learned so many things that I can use every day.

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!

Leila Gharani - XelPlus

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.

Read more from Leila Gharani - XelPlus

Here's what I've noticed. The reports that look the cleanest in a meeting are almost always the hardest to work with. Here's an example of a meeting-friendly table: But wait until you need to create a Pivot Table or do quarterly or half-year analysis. Then it's better to have the data in long format: But how do you quickly turn wide into long? ๐Ÿ‘‰ Here's the 1 minute formula video Power Query is an option for sure. A few clicks and you're done. But if your numbers are already in the sheet,...

The good thing about Excel is formulas update automatically. Change an input, the output adjusts. Ok. You know that. But what if you want the output to be a specific number. What should the input be? Let's say, your boss is standing right by your shoulder, staring at your spreadsheet. "We need to reach $2,500 in revenue this month. How many units do we need to sell?" You could keep tweaking the units cell until you get close. Guess, check, guess again. Pleasant enough if you're alone. Not so...

Most people open ChatGPT, drop in an Excel file, and type two words. Analyze this. What comes back looks good. The numbers, the insights, the tidy summary. But how do you actually know if it's right? Last week I put ChatGPT through a proper test. A messy, multi-sheet sales file with codes, lookups, and calculations it had to figure out on its own. Then I verified the results myself with a data model in Excel. There's a specific workflow that makes the difference between trusting AI blindly...