|
Trying to capture slides from a webinar presentation? Need to show IT an issue? You'll need to take screenshots. And if you've got Windows, you already have the right tool. I'll cover how to use it and explore all the cool screenshot upgrades coming to Windows 11! Plus:
๐ฌ How to Take a ScreenshotWhenever you have to take a screenshot, there's a free tool you can use. Many people don't know about it. Others forget that it's there. Some even take photos of their monitor, which leads to hard-to-read angles and screen glare. Meanwhile, the Snipping Tool is already on your computer. Always at the ready, with a handy shortcut. See how you can get the most out of it. Watch the video to learn:
and more. No worries if you can't find the annotation feature on your version of the Snipping Tool yet โ it's coming soon. What I show in the video was recorded on my PC with Windows Insider installed. ๐ต๏ธ BTW, any idea how I made the values in Excel disappear as I typed them at 09:20? Here's the solution. Power BI Free PreviewIf you're curious about Power BI and you haven't taken our free preview yet, now's your chance. Sign up for Power BI Quick Start. It's completely FREE. In an hour, you'll go through all the key elements of Power BI and create a report. You'll connect to data, prepare it for analysis, and visualize it to gain valuable insights. You can decide if Power BI will be a useful tool in your work without committing to a full course. ๐ข Heads up if you're already enrolled in our full course Fast Track to Power BI: We've recently completed another batch of updates catching you up on the latest features added to Power BI. We showcase the new features using course data, so you can take them for a spin with the files you already have. Power BI is an evolving app, with updates released every month. We don't want to leave you behind. ๐ค Geeky News๐ค Recall getting recalled, Copilot for OneDrive set to landControversy around Microsoft Recall delayed its planned release. Now concerns arise around Copilot for OneDrive, which is expected to drop in the summer. It's part of Copilot for Microsoft 365 for business and education. Copilot will let users ask natural-language questions about OneDrive files. It's going to help locate them and extract information from the files. Microsoft assures its business customers that Copilot follows all the security and privacy requirements of Microsoft 365. All data is kept within the organization and it's not used to train the machine learning models. ๐จ New features in Microsoft DesignerMicrosoft Designer uses DALL-E to generate images. It recently introduced 2 new functionalities: Sticker Creator and Restyle Image. Sticker Creator allows you to make digital stickers from scratch. Simply describe the desired design. Restyle Image transforms photos into various artistic styles. Turn them into pop art or 3D illustrations. You can use Microsoft Designer for free with a personal Microsoft account. ๐ Who said you can't do anything creative in Excel?Here's a cool find from Andrew Moss on LinkedIn. Spotify has launched a music video made entirely in a spreadsheet to promote its B2B media campaign, "Spreadbeats". They used "built-in functions including ASCII, Graphs, Unicode, and conditional formatting". Did you notice the sheet name changing? Commenters on LinkedIn were quick to point out that literature got there first. Check out this quote from Dirk Gently's Holistic Detective Agency by Douglas Adams: What do you think? Do you see a future in combining music, spreadsheets, and accounting? ๐ ๐ Power StoriesCongratulations to Marisa on completing Fast Track to Power BI. That's great that you're already implementing insightful and actionable reports. 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! |
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 import a CSV in Power Query... Dates have errors. Numbers won't calculate. What just happened? Here's what's usually happening. Your computer is reading the file with your regional settings. So if your CSV uses commas as decimal separators (like 1,5) but your system expects dots (like 1.5), Power Query gets confused. Same with dates. Is 04/05/2025 April 5th or May 4th? Depends on where you are. The fix: Change Type Using Locale. But here's the part that trips people up - order matters....
Let's say you're waiting for colleagues to submit the latest data. You need to check if the files came in. And if the data is complete. So you start opening files one by one. It's tedious. And completely avoidable. When Microsoft released the new IMPORTCSV function, I wasn't ready to throw Power Query out the window. It still handles far more sources and does things this new function simply can't. But it got me thinking. What if you could peek at a CSV without fully loading it? Just enough to...
Excel's chart formatting menu is dangerous. Not because it's bad. Because it gives you too many options. And some of them have no place in a professional report. Take this social media trend: pasting images directly into your chart bars. Looks creative. Gets lots of views on YouTube. But would you put that in front of your manager? In just a few extra clicks, the same data can look like this: Same logos. Matching brand colors. Just used with intention. ๐ Watch: How to build this chart in just...