|
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.
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...
The files I used to have in my corporate job were pretty large. Like 40+ sheets. Some had more. I used to dread opening one of these during a presentation. Someone would ask me to pull up a specific sheet. And I'd be scrolling... checking... scrolling... It wasn't fun. Then someone showed me a simple click to see all the tabs in one place. I'd been using Excel for 10 years by that time and had NO CLUE this existed. That's just one of 4 methods I cover in this week's video, including one that...
Your Power Query file works perfectly. On your machine. Then someone else tries to use it and suddenly nothing refreshes because the folder path points to your laptop. This is why people move files to SharePoint. Same folder, everyone can access it, no more path issues. Great. You'll just use the SharePoint Folder connector and... ๐ต๐ซ Ok, which path it's supposed to be? Here's the catch: Power Query shows you a giant list of URLs instead of folders. Well, there is a better way. And it takes...