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're not tied to the defaults
|
When you open a new workbook in Excel, what’s the first thing you adjust? Maybe the font? or you add 5 more sheets because who uses Excel with just one sheet?! Here’s the thing - Excel doesn’t have to stick to its defaults. You can make it work the way YOU want. This week in Between the Sheets we're looking at small but useful enhancements you can make to your future workbooks. As well as:
⚙️ Change the DefaultSo let's say every time you open a blank file in Excel, you want 6 sheets. Here's what you need to do:
But maybe it's not the sheets that bother you - maybe it's something else. Perhaps you're not a fan of the new default Aptos font. Or you'd love to have a larger font in the formula bar. (Some things get better with age - your eyesight isn’t one of them.) Luckily, the solution is just as simple. Back in Options:
Note: "Body Font" is the current Microsoft default (in the past Arial, then Calibri, and now Aptos). Pro tip when picking a font: mind your letters O and zeros 0, as well as your Is, ls, and 1s). The changes you make here apply to both the grid and the formula bar. But the changes to the grid (which font is used inside the cells) will only apply to newly created files. The new font settings in the formula bar will be reflected in all files. Increasing the font size in the formula bar is also useful for Excel trainers - it helps your trainees better see what you're showing. Monospaced FontIf you're writing complex, multi-line, indented formulas, you may benefit from a monospaced font (e.g. Consolas, Courier New). In a monospaced font, each character has the same width. This offers consistent alignment and makes it easier to spot errors. In Microsoft 365, the formula bar now uses a monospaced font by default. If you don't find it useful, you can disable it in Options > Formulas.
Note: A change to the workbook's default font type also overrides the monospace font in the formula bar. If this opened your mind to the possibilities, check out some other Excel settings worth exploring. Join Me at the Global Excel Summit 2025!The trailer for GES 2025 just dropped 😉 You get to peek at some of the backstage footage and take in the vibes from the last summit. This time, it's an even better venue. And I'm sure we can top the atmosphere as well. When & Where@sohoplace theatre, London, UK, 4-6 February, 2024. It's a great opportunity to chat Excel, compare notes, and learn from amazing experts. I hope you can come 😊 If you can - book your ticket now and use the offer code LEILA at checkout for a 20% discount! 🤓 Geeky News📊 Power BI Core Visuals Vision BoardPower BI's Core Visuals Team has launched a Vision Board (using Power BI, of course). The revamp of Power BI visuals is an ongoing process, with new visuals and visual enhancements introduced every month. And there's more still to come. Now there's one place where you can track the product team's progress. See what’s completed, under development, and pending. You can even vote for the features you're most eager to see implemented. Soon, it will also include a roadmap for future updates. 🤖 ChatGPT becomes more interactive with CanvasChatGPT introduced a Canvas feature that lets you interact with the AI-generated results. It can be useful for long-form texts or generating code. You can edit the result directly on the canvas. Or you can use the built-in tools to tweak the results - either the entire draft, or the sections you highlight. It's more hands-on than a back-and-forth with a chatbot. For text, you can suggest edits or adjust the length and reading level. For code, you can review, fix bugs, or add comments. GPT-4o with canvas is currently in beta for ChatGPT Plus subscribers. 🤖 Other AI News Roundup
👏 Power StoriesCongrats Zulkarnain on earning the Excel Pivot Tables badge! It's great to hear the new techniques picked up in the course are improving your data projects. Got a success story about using your XelPlus skills? I’d love to hear it! Hit reply to share the details, and inspire other students 😇 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! |
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.
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...