Welcome back!
3 things we’re covering today:
In my latest video, I cover three ways you can use Microsoft Forms to gain insights about your company.
After all - to be successful in business, you need an efficient way of collecting data about your customers, employees, and products.
Here are three key features:
Do you want to read more books? In that case, I highly recommend Shortform! 👇
Shortform offers high-quality guides to the world’s best non-fiction books. Each guide includes a concise 1-page summary, a longer chapter-by-chapter breakdown, and exercises to help you retain information.
This unique approach helps you grasp the key concepts of a 15-hour book in just 2 hours. It’s like having a knowledgeable friend giving you the inside scoop!
Ready to give Shortform a try? Sign up here for a free trial at http://shortform.com/leila. XelPlus Weekly readers also get 25% off the annual subscription - that’s equivalent to 3 free months!
Thank you to Shortform for sponsoring today’s newsletter. 😊
📊 Google Sheets - Enhanced Tool Finder
Google Docs, Sheets, and Slides have a new Enhanced Tool Finder feature! It helps you find features using your own words (eg “who last viewed this document”). It suggests common actions when you create a new file, and you can access previous features through it. This replaces the old Help > Search in the menus workflow, and will be permanently in the toolbar. I wonder if a similar tool will come to Excel?
🏞️ Windows 11 - Photos’ Slideshow Feature Returns
After a whole year, Microsoft is bringing back the much-loved ‘Slideshow’ feature that lets you automatically create slideshows from your photos and videos. This feature disappeared with the introduction of the all-new Photos app, in the Windows 11 2022 update. Hopefully it’s back to stay!
👥 PowerBI - Now Easier to Share in Teams
It’s now easier to share and embed Power BI reports in Teams. Just paste a link, instead of browsing through workspaces!
This also lets you share a custom view of the report (“include my changes”) and take care of permissions (“share with everyone in my organization”). So you don’t have to handle individual access requests any more. 😌
🔓 Chrome - Google Replaces the Misleading Lock Icon
A 2021 Google survey found that “only 11 percent of participants actually understood the intended purpose of the lock icon” in their browser. It shows whether or not a website is secured with an SSL certificate (HTTPS). 😉
To avoid misleading users about how ‘trustworthy’ websites are while browsing, Google are replacing the lock this year with a new ‘controls’ icon.
You can apply the same concept to your corporate reports! Do people really understand the symbols and icons you use?
Maybe it’s time to send out a survey…. this week’s video will help you set one up 😄
🥕 How Often Do You Finish Online Courses?
One of our XelPlus clients is motivating their team to upskill in a novel way… By giving monetary rewards to any employee who completes an XelPlus course within 30-60 days.
$300 if you complete a course within 30 days, and $150 within 60 days. Great idea - we all need a bit of encouragement every now and then!
I’m sure they’ll have lots of Excel experts before long.
Thank you Paul for this amazing review of our Power Query - Beginner to Pro course.
Finishing a course can be such a fulfilling experience 💚
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
▶️ Subscribe on YouTube
🖇️ Follow me on LinkedIn
🥇 Join 300,000+ people 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.
Pie charts get a bad rep. And honestly? Fair. I'm not a total hater. Two or three slices and a pie chart can tell a perfectly good story. But here's what actually happens in that meeting room when you've got 8+ slices on screen. People glance at the legend, look back at the chart... and have absolutely no idea what they're looking at. They won't say that, of course. Instead, the room either moves on a little too quickly or starts asking questions the chart should have already answered. Either...
Uh-oh. Embarrassing typo in the file name. And there's 50 of them. 🫨 Individual contracts about to go out to clients. You could rename them one by one. Or you could fix the whole mess in five seconds using something already built into Windows. No downloads.No complicated setup. Just PowerShell. 👉 I show you exactly how here. (BTW, if PowerShell doesn't pop up after typing the name in Explorer, try powershell.exe.) And if typing commands makes you nervous, there’s a drag-and-drop option built...
Shared Excel files are great until your whole team needs to work on it at once. You filter for your tasks. Your colleague filters for theirs. Now your filter's gone. You filter again. They filter again. 😤 It's like fighting over the TV remote, except it's a spreadsheet so more annoying. The fix: Sheet View. Go to View tab > Sheet View > New. You'll notice the column and row headers change to black. Give it a name. This way you can reuse it later. Just type over the "Temporary View". Now...