3 things we’re covering today:

• 🧑‍🏫 Become a presentation master!
• 🔍 Searchable dropdown lists in Excel
• 🔐 The most infuriating video game ever

🎬 Export Power BI to Excel Smoothly and Efficiently

​

In my latest video I show how you can effortlessly use Power BI and Excel together.

You can either insert a table or a pivot table in Excel that's linked to a Power BI dataset. OR you can export data from Power BI with Analyze in Excel and live connection.

The first two methods begin in Excel:

1. Create a Table in Excel Linked to Power BI Data

This method is ideal if you start with Excel and want to access data from Power BI. You can customize the data by selecting specific columns and applying filters, and the table remains connected to Power BI, so you can refresh it to get the latest data.

• Here’s how: Data / Get Data / From Power Platform / From Power BI

2. Create a Pivot Table Linked to Power BI Data

Another option when starting with Excel: You can insert a pivot table from a Power BI data set into Excel, providing more advanced data analysis capabilities. Pivot tables retain number formatting and allow you to drill down into data hierarchies.

• Here’s how: Insert / Pivot Table / From Power BI

The other two methods begin in Power BI report:

3. Export Power BI Data With “Analyze in Excel”

You can export data from Power BI to Excel for web, which creates a file in OneDrive. This lets you create pivot tables and utilize measures or implicit measures for analysis.

4. Export Power BI Visual With Live Connection:

Export summarized data from a specific visual in Power BI with a live connection. You can choose to export data in various formats, including XLSX, CSV, or with a live connection.

• Here’s how: Visual / More options / Export data / Live connection. (This creates a file in your desktop and saves it in the download folder.)

For more details, check out my video!

📊 Master the Art of Presentation - 6 Free Webinars by think-cell​

Ready to take your presentation skills to the next level? 🚀

Join these free webinars hosted by Florian Kampfer, who boasts an impressive 25-year career in the consulting industry, and his most recent role was as Global Presentations Lead at EY-Parthenon.

Florian will share his hard-learned advice in this unmissable collection of webinars, unveiling the secrets to transform your presentations from good to world-class:

• 📊 Craft Unforgettable Narratives: Learn Florian’s blueprint for creating compelling stories that will captivate any audience.
• 📈 Master Data-Driven Visualizations: Discover the latest techniques to effectively convey your message through data visualization.

Each webinar covers a different topic, and they are entirely independent – join any that pique your interest, and you'll still gain tremendous value.

Reserve your spot today, and start on a journey towards presentation excellence. 🎙️📊✨

​Register now.​

🤓 Geeky News

📊 Excel - Searchable Dropdown Lists
Microsoft has now added AutoComplete functionality to dropdown lists in Excel. This automatically compares the text typed in a cell to all items in the dropdown list, then shows only items that match. So less time scrolling through lists, or making time-consuming typos!

This feature is finally publicly available in the Current Channel! I made a video about it back in January 2022.

📊 Excel - Paste as Values Shortcut
Another great feature that’s also publicly available now in the Current Channel is the Paste as Values (Ctrl+Shift+V) shortcut. This lets you copy text from a web page, an email, or another document, then paste it into Excel as plain text, so it doesn’t mess up your current formatting. Check out my video for more info!

💻 Microsoft 365 - Add and Explore Office Add-ins Easily with a New Entry Point​
There’s a new ‘Add-ins’ button on the Home tab you can use to easily find, install, and access Office add-ins in Word, Excel, and PowerPoint.

📱iOS - Microsoft 365 Widgets​

With the new Microsoft 365 widgets for iOS, you can perform tasks directly from the Home screen of your iPhone or iPad. Create documents, sign PDFs, and take notes.

💚 My Favorite Things

😡 The Password Game​

​Neal.fun makes simple, miniature video games. The latest one, called ‘The Password Game’ recreates the frustrating experience of creating online passwords! More reasons to use a password manager…

🚀 Power Stories

Thank you Robin for this review of our new Automate with Power Query course! I’m glad it’s inspired you to solve more work problems 💚 🦾

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 400,000+ students 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!