profile

Leila Gharani - XelPlus

Build Stunning Dashboards with ‘Place in Cell’ 😮

Published 11 months ago • 3 min read

3 things we’re covering today:

  • Lookup Images - now made easy 💪
  • A special surprise… 🏆
  • The first certificate for my new course! 🥇

🎬 How to Use Excel's NEW Lookup of Images

video preview

I have something exciting for you in this week’s video!

Microsoft is rolling out a new Excel feature called ‘Place in Cell’ that lets you insert pictures inside cells.

This lets you create more advanced and professional looking Excel dashboards without the need for complex solutions.

Inserting images in cells makes it easy to use functions like XLOOKUP or FILTER to return an image.

  • So imagine, you work in HR and you lookup a person. You can now return their image beside their name.
  • Or you work in engineering and you lookup a product part. You can return the image of the part as well.
  • Place in Cell is currently in beta only, and only released to a percentage of people in the beta channel. I was lucky to have it on one of my PCs at home in the cellar!

    Hence the poorer audio quality in my video.

    📢 Unlock the Power of Summaries with Shortform AI

    I really love Shortform’s super-detailed book guides.

    But now they're taking things to another level with the recent release of Shortform AI.

    It’s game-changing browser extension that generates detailed summaries of blogs, articles, emails (and even YouTube videos) in a single click.

    Add the extension to your browser, and you’ll be able to:

    • 🔍 Preview content before diving in
    • 🧠 Review key ideas from your favorite pieces of content
    • 🌎 Learn background context to understand the issues better
    • 📚 Understand counter-arguments to form a well-rounded opinion
    • 📈 Explore related ideas to supercharge your learning

    Shortform AI is included with Shortform's premium service at no extra cost! So subscribing also unlocks Shortform's high-quality nonfiction book guides.

    Ready to join?

    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. 😊

    🤓 Geeky News

    📈Power BI - Cool update to card visuals
    Microsoft have created a new version of the card visual for Power BI! You can now display multiple cards in a single container, and have full control over every component of each card. This should make it easier to access and interact with your data.

    👥 Teams - Collaborative Meeting Notes

    Microsoft Teams Public Preview users can now use collaborative meeting notes. These let meeting attendees work together to create agendas, take notes, and generate action items.

    Any notes you take will be synchronized across all you devices. And if you get assigned a task via Collaborative notes, they’ll auto-sync with To Do and Planner.

    👩‍🏫 PowerPoint - New Auto-Scrolling Teleprompter (Currently in beta)

    Power Point has a new auto-scrolling teleprompter feature that lets you make better eye contact and know exactly where you are as you’re giving a speech or presentation.

    Just press ‘record’, and Power Point will detect when and how fast you’re talking, moving the on-screen text automatically.

    📋Microsoft Forms - Share Live Surveys

    You can now conduct Microsoft Forms surveys live. With a QR scan or short URL, your audience can participate in a live survey, and view real-time responses as feedback comes in.

    Find out more on how to present a live survey here.

    💚 A Huge Thank You

    I was voted the ‘Most Influential Professional in the Excel Industry’ in this year’s Global Excel Awards!

    It was just announced on LinkedIn a few days ago.

    A huge thank you to everyone who voted for me, including many XelPlus Weekly readers - it’s an incredible honor. We have an amazing online Excel community, and over the years I’ve learnt so much from many experts, who I deeply admire.

    Click here to see the winners of other categories.

    🚀 Power Stories

    Super exciting to see one of the first certificates for the course we just released: Automate with Power Query - Recipes to Solve Business Data Challenges.

    Congratulations to Tie Teck Chee for completing the course! I love that the techniques help Tie to streamline the team's current workflow, and reduce time spent on repetitive tasks.

    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 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!

    Leila Gharani - XelPlus

    Helping you easily overcome data challenges with Excel & Power BI

    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.

    Read more from Leila Gharani - XelPlus

    Thinking VLOOKUP is dead now that we have XLOOKUP? Think again. It's still used across thousands of spreadsheets. It has some limitations, but if you're aware of them and use it correctly, you'll get the job done quickly. Also, this edition of Between the Sheets includes: Power tools making a difference Better technical answers from ChatGPT Solution for tab hoarders If you were forwarded this message, you can get the free weekly email here. 🎬 Master VLOOKUP for effortless reporting In my...

    5 days ago • 4 min read

    Today, we're diving deeper into Excel's View tab to show you some lesser-known, yet incredibly handy features that will change the way you manage your workbooks. Also in focus: sharing views in Excel for the web AI writing assist in any online text box OneDrive offline capabilities If you were forwarded this message, you can get the free weekly email here. Master the Window options in Excel's View tab A while ago we covered the magic of Freeze Panes. But there are other buttons in the View...

    12 days ago • 4 min read

    We’re almost done with our New Excel Business Charts Course and it’s looking great! I'm currently reviewing the final videos. Meanwhile, the team is busy finalizing the cheat sheets, lesson notes, and quick guides. This morning, I reviewed the lecture "How to Pick the Right Chart". And wow! It took me right back to my corporate job, staring at the screen, wondering, "How on earth do I make this data tell a story?!". There was SO MUCH to show. Picking the right chart might seem easy, but...

    about 1 month ago • 4 min read
    Share this post