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.
🖼️ Easily Insert Pictures in Excel Cells
The super-useful Excel IMAGE function is now available for the Office 365 Monthly Channel!
It lets you insert images into an Excel cell using just the image URL.Here’s how...
- Copy the image URL from the web
- Use the formula =IMAGE[”LINK”] to insert it into the cell where you'd like the image.
- Press Enter – and your image will appear!
If you’ve already got an image URL pasted into your sheet, it’s even easier.
Just reference the cell containing the URL in your formula (=IMAGE[C5]) to get the same result.
You can drag this =IMAGE[C5] formula down as well, if you have a whole list of image URLs that you'd like to reference.
The default image sizing is Fit Cell, but clicking Alt Text in the formula bar will give you three other options: Fill Cell, Original Size, and Custom Size.
To see more, here’s my 1-minute video walkthrough.
🎬 Hand-Drawn Charts in Excel?
Excel charts are a powerful tool for sharing the story of your business. But let’s face it, some people find plain charts a bit dull 😢
That’s where automated hand-drawn charts come in, to make your visuals seem more quirky and creative! You probably won’t add these to your professional monthly reports. But you could use them to differentiate between a “draft” and a “final” report. And if you’re presenting to a younger crowd, they might find the hand-drawn style more engaging.
Check out my new video for a step-by-step guide.
🤓 Geeky News
📊 Excel - Evaluate Formulas Without F9 (Version: Office Insiders)
Microsoft has added the new Value Preview ToolTips feature to Excel. Instead of using F9 to evaluate all formulas in your sheet, simply select a part of your formula in the formula bar, and you’ll see a ToolTip containing the current value of the part you’ve selected. 👇
📈 Power BI & Excel - A Better Way to Connect Power BI and Excel
The new way to explore and analyze Power BI data in Excel is called Connected Excel Tables from Power BI. It lets you conduct ad hoc analysis in Excel in "normal" tables (not just Pivot Tables), while maintaining a live connection to your Power BI dataset.
📝 One Note - New Layout Options in OneNote for Windows
Microsoft is bringing the left-sided OneNote layout option (called Vertical Tabs) from the Mac, iPad, and Web versions of OneNote to OneNote for Windows. This lets you navigate similarly to Outlook and Teams.
💚 My Favorite Things
💬 Global Excel Summit - My Keynote Speech
I’m finalizing my keynote speech for the Global Excel Summit, which starts on Monday 6th February! The first day is free, including my talk. But if you’d like tickets for the entire 3-day event, my community gets a special 20% discount – just use the code LEILA at checkout. 😊
📡 Smart Tech - Is Your Fridge a Security Risk?
A Dutch software expert recently discovered that his AEG smart oven and fridge were pinging search services in the US, China, and Russia every day to check for Wi-Fi availability. If you’re security-conscious, check your device settings.
🤖 ChatGPT - The Excel Shortcut Song
Our team member Anna asked ChatGPT for an Excel shortcut song, and this is the result… Can anyone turn this into a nice tune?
Verse 1: Ctrl+C to copy, Ctrl+V to paste Ctrl+S to save, Ctrl+F to find the place Ctrl+Z to undo, Ctrl+Y to redo Ctrl+B to bold, Ctrl+I to italicize
Chorus: Excel shortcuts, Excel shortcuts Keep them in your head, you won’t be led astray Excel shortcuts, Excel shortcuts Remember them all, they’ll save your day
Verse 2: Ctrl+A to select all, Ctrl+D to fill down Ctrl+P to print, Ctrl+R to fill right Ctrl+T to transpose, F2 to edit Ctrl+O to open, Alt+Enter to wrap
🚀 Power Stories
It’s great that DLA Piper invested in Christopher’s growth by sponsoring his participation in my Fast Track to Power BI course. I hope to see more companies proactively supporting their employees like this!
Got a great success story about how you used your XelPlus skills? I’d love to hear all about it! Hit reply to share the details, and your story might just inspire other students. 😇
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.
Quick question. How many working days are left until your project deadline? Not calendar days. Working days. No weekends and no public holidays. And no that-week-everyone-takes-off-in-August. Most people subtract two dates and call it done. Then wonder why the timeline is slightly off. Excel has a function built for exactly this. Custom weekends, holidays, even non-standard working schedules. 👉 Watch how it works and grab the practice file 👈 🗨️ Someone asked in the comments: what if you need...
For years, I did something I'm a little embarrassed to admit now. Every time I needed to present pivot table data, I'd copy it out. Paste it as values into a separate sheet. Then format it manually. My pivot table stayed hidden in the background like a rough draft nobody was allowed to see. Why did I do this? Pivot table default styles are just ugly. Nothing to impress management with. It never occurred to me that the pivot table itself could look like this: Yes. That's a pivot table. Fully...
You have a list of messy text. You need to filter it down to only rows that contain a 4-digit product code. Me in 2004 would have done it manually. Me in 2014 would have used VBA. Me now? Just 60 seconds with one formula. The function is called REGEXTEST. It's relatively new in Excel, and once you see what it does, you'll wonder how you worked without it. 👉 Check out the short video here REGEXTEST tells you if a pattern exists. But there are two sister functions also worth knowing:...