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.
😮 Did You Know Excel Has This Feature?
Hi there,
Excel’s new feature Insert Data from Picture lets you extract data from any picture or screenshot, and insert it right into your workbook.
Now, you might be thinking - ‘when will I ever use this?’
Here are 3 great use cases:
- 😡 Get Data from Screenshots
If you’ve ever tried to copy/paste data from a web site, you’ve likely noticed that the formatting looks different after you’ve pasted it than it did on the website. Taking data from a screenshot gets around this problem.
- 🤓 Solving Other People’s Problems
Someone has shared a screenshot of their Excel sheet with you - but you don’t have access to the actual file (maybe for security reasons). This happens to me all the time, when I’m solving a problem for one of my students.
- 📊 When Power Query Doesn’t Work
This is also a great trick for those times when you can’t use Power Query to get data from a website because the table isn’t an html table.
Here’s how Insert Data from Picture works:
1. Go to the Data tab and click on From Picture (from the Get and Transform Data section)
2. Browse for and select your image, then click Insert
3. You’ll get a little preview of your image in the right-hand panel
4. Click Review to check your data is correct
5. Select Insert Data, and everything will appear inside your sheet!
Check out my recent video on this for more info and examples.
📒 Shortform
Do you want to read more books? In that case, I’d like to recommend Shortform.
They produce high-quality summaries of the world’s best non-fiction – each of their one-page summaries takes just 1–2 minutes to read, giving you a book's key ideas in a simple, no-nonsense style.
You also get a full 3-5 page breakdown with commentary, analysis, and a lot more besides. It’s like having a knowledgeable friend giving you the inside scoop on each book.
Shortform have 1000s of titles in their library and cover dozens of topics, including careers advice, finance, and technology. And they’re always adding more - so there’s lots to explore.
Ready to give it a try? Sign up here for a free trial and to get $42 off the annual subscription - over 2 months free!
Thanks to Shortform for sponsoring today’s newsletter 😊.
🤖 Quickly Analyze Data with AI in Excel
Excel’s built-in AI tool Analyze Data can analyze your Excel sheets for trends and insights, then offer you a selection of PivotTables to show the results. You can also ask it questions using Natural Language Processing. For example, “Which region had the least total sales?”
You can ask it to create charts as well. For example, I could just type in ‘average cost by category as column chart’, and Excel would generate the chart option:
🤓 Geeky News
📝 Microsoft Word - Smart Save Reminders
Using machine learning, Word can now detect when you’re working on a local file, and suggest you save your progress. It consider factors like how long you’ve been working on the file, and how much content you’ve added. I tend to set AutoSave off for some documents so this is a great reminder.
🌈 Power BI - New Accessible Color Themes
Microsoft have released five new accessible color themes in Power BI. Now you can create beautiful, accessible reports quicker!
🖼️ Edge - New PDF Experience
Microsoft have partnered with Adobe to bring the Acrobat PDF engine into the Edge PDF reader. Which means you’ll get better graphics, performance, security, and accessibility directly in the browser. This update is planned to go live in March 2023.
💚 My Favorite Things
🪵 Desk Accessory - Grovemade Wood Laptop Stand
Grovemade sent me several of their wooden desk accessories, and I especially liked the wooden laptop stand. It’s non-adjustable but tilted at the perfect angle for my neck, and it’s really easy to type on. It’s also perfect for online meetings. The camera is at the right height.
🤖 Microsoft Bing - A hacker recently tricked Bing into revealing its original prompts, including that its project code name at Microsoft is Sydney. Goes to show these technologies aren’t yet ready, but that’s probably the approach Microsoft, Google and the like are taking. Release then fix. What’s the damage though?
📊 Excel Memes - 40 Hilarious Pics And Memes You Might Appreciate If You’ve Ever Used Microsoft Excel
I wonder who has done #9? I also relate to this one below - it’s just like looking at the financial reporting files at my old corporate job 🙈
🚀 Power Stories
Thank you to Emin from Turkey/Canada for his lovely review of our Fast Track to PowerBI course. “I always remember certain teachers of mine, and you are one of those teachers that I’ll always tell people about.’ 💚
See you next week,
Leila
Want more?
▶️ Subscribe on YouTube
🖇️ Follow me on LinkedIn
🥇 Join 300,000+ people in our courses
📣 Want to advertise on XelPlus Weekly? Get in touch here.
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.
Here’s a little behind the scenes on the new Copilot course. There’s so much you can do with Copilot these days, so before planning what goes into the course, I sent out a survey with one main question: "What’s one task that takes you too long every week that you’d love to hand to Copilot?" 1,773 people answered. We went through the answers, grouped them by the task people wanted help with, and (in Excel) counted. Most of it wasn’t about using AI better, like writing better prompts. It was...
Every company has at least one Excel file that nobody fully understands. It usually belongs to someone who left. In my corporate past, I had to make sense of quite a few of those. Many sheets, lots of formulas and reports in every sheet. Once a file like that becomes yours, you’re the one who has to answer for its numbers, even if you didn’t build any of them. So how do you figure out where everything comes from? Excel has a few tools that help a lot here, and in this video, I go through 8 of...
Something that surprises a lot of people: Your Windows login doesn't have to be a Microsoft account. I get this question from time to time: "Can I switch to a local Windows account, and still use Excel and the rest of Microsoft 365 like before?" Yes. You can. Microsoft might show you a blue screen first before you continue (hmm the dreaded blue screen, although this time it's actually being helpful. Still, I wonder if they picked that color on purpose 😉) If you want to understand your options...