3 things we’re covering today:
My latest video is on some lesser-known but extremely useful Windows shortcuts. You have to know these if you want to master your PC!
Some of my favorites:
For the other shortcuts, check out my full video ☝️
People often ask - ‘Leila, what software do you use to record your screen for YouTube videos and courses?’
The answer is Camtasia, by Techsmith. It’s a one-time purchase software with great pro features that help you make clear and engaging tutorials or presentations. For example, it lets you zoom in and still maintain crispy image quality, as well as hide your mouse from viewers, or make your mouse movements seem smoother.
I also use SnagIt when I want to capture a static image or create a quick GIF. It lets me add annotations like arrows, text, or shapes to highlight important details, making my instructional manuals more clear and engaging.
📊 Excel (Coming to Excel 365 version, currently beta) - Stale Value Formatting
A great feature for those that have large files and tend to put the calculation mode on manual instead of automatic. With Stale value formatting you get to make sure what you report on is actually the updated, refreshed version and not formulas that haven’t been updated yet, because stale cells will show as struck out.
Once this feature is rolled out, it will be on by default - you have the ability to turn it off if you’d like.
📝 Word (for the web) - View your document across separate pages
You can now view your document across separate pages in Word for the web, just as you can across the other platforms (Windows, Mac, iOS, and Android). Microsoft are also working on adding new formatting capabilities to Word for the web, including paragraph options, columns, and improved headers and footers.
👩🏫 PowerPoint - Create and Assign Tasks
You can now create, assign, and resolve tasks directly inside PowerPoint for Windows, Mac, and the web. In the body of a comment, just @mention the person you want to assign a task to, select Assign to, then send an email notification to the assignee.
Last week, Microsoft Excel Esports Elimination Battle was shown on ESPN8: The Ocho! Hosted by Bill Jelen, Oz du Soleil, and yours truly! This was a lot of fun, and a must-watch if you’re an Excel nerd…
If you missed the live stream on ESPN, watch the Youtube video here.
The most rewarding feeling I get from work is when I see our course members achieve their goals, and grow their careers.
Thank you Ravish for sharing your story. You made my day 😊
It’s true - there aren’t usually any shortcuts in life. But learning Power Query is the ultimate shortcut when dealing with lots of data!
Power Query is so important I have two courses on it:
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 me on LinkedIn
🥇 Join 400,000+ students in our courses
📣 Want to sponsor XelPlus Weekly? Get in touch 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 XelPlus Weekly 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.
This week, I had the pleasure of speaking at the 49th Controller Congress in Munich - one of Europe's top events for finance leaders and controllers. It was an incredible crowd. Smart. Experienced. People who work with data every day. My session was about AI in Excel. In 40 minutes, we walked through a "day in the life" of a modern data analyst - using the AI features in Excel. When we got to Analyze Data, I asked for a quick show of hands. Who here is using it? Out of more than 400 seasoned...
“Why would I use Python in Excel if it can’t handle external data?” That’s the top complaint I hear. And it’s flat-out wrong. You see, Python people try to use Python code to import the data. That doesn't work. Excel people do copy-paste or load via Power Query into a sheet. That works - but it bloats your file. And if your dataset has more rows than Excel can handle, you're stuck. The solution? Don't load your data into Excel at all. Go from a raw CSV... ...to a clean correlation heatmap in...
You open the file. The formula’s broken. The chart’s gone. Cell colors? A rainbow mess. You don’t know who did it. Doesn’t matter. Excel’s Version History has your back. It quietly keeps snapshots of your file, so you can rewind, review, and restore past versions. Find out what changed, when, and roll back if needed. Fix the mess. No drama. No blame. 👉 Here’s how to use it—fast. (BTW, if you want to create a dashboard like the one on the right - before someone took a sledgehammer to it 🔨 -...