Oz du Soleil, Author at Oz du Soleil

About Oz du Soleil

This author has yet to write their bio.
Meanwhile lets just say that we are proud Oz du Soleil contributed a whooping 335 entries.

Entries by

Oz du Soleil: Risk Taking as a Content Creator | Global Excel Summit

May 7, 2021 in Videos /by Oz du Soleil

If you missed the 2021 Global Excel Summit, full event content now available via the event website 👉 https://globalexcelsummit.com/ This video is my presentation: Risk Taking as a Content Creator #GlobalExcelSummit #ContentCreation #RiskTaking For a list of my Excel courses at Lynda/LinkedIn: https://www.linkedin.com/learning/instructors/oz-du-soleil There are courses on Power Query, Good spreadsheet habits, and a weekly […]

NEW FEATURE! Import Dynamic Arrays into Power Query + 8 Warnings

April 24, 2021 in Videos /by Oz du Soleil

Just 2 days ago it became possible to import Dynamic Arrays into Power Query. 🙏🏼🎉 This is really cool. HOWEVER! There are 8 warnings that I take you through. First. There is no longer “table-slash-range.” The icon has been changed to “From Sheet.” BOOOO! 🤪 Table/range seems more accurate. Check out the video for the […]

NEW FEATURE! Import Dynamic Arrays into Power Query + 8 Warnings

April 24, 2021 in Videos /by Oz du Soleil

Splitting Multiple Columns in Power Query | Battling null values and line-feeds

April 14, 2021 in Videos /by Oz du Soleil

In a previous video I dealt with a common need to split multiple columns of data. However, in that dataset the delimiter was obvious and all cells were filled in. But! What happens when things get weird? In this video, the delimiter is a line-feed and there’s a problem with empty cells. We use Text.Split […]

An Excel Meditation with Tables, XLOOKUP, Dynamic Arrays in a Dynamic Dropdown List Solution

March 15, 2021 in Videos /by Oz du Soleil

During the Azerbaijan Power Bi & Modern Excel Meet-up last week, Faraz Shaikh presented and shared a lot of cool Excel tips. There was one tip that stood out for me: Extracting a table’s headers into a Dynamic Array. 😲 It was amazing! It got me thinking about how this could be applied. In this […]

Saudi Arabia Microsoft Excel & Power Platform Meetup – 16FEB21 – “Data Quality With Dynamic Arrays”

February 22, 2021 in Appearances /by Oz du Soleil

Saudi Arabia Microsoft Excel & Power Platform Meetup – 16FEB21 – “Data Quality With Dynamic Arrays”

Global Excel Summit – 6FEB21 – “Risk Taking as a Content Creator”

February 22, 2021 in Appearances /by Oz du Soleil

Global Excel Summit – 6FEB21 – “Risk Taking as a Content Creator”

ExcelHash 2021 Bill “Mr. Excel” Jelen and Oz du Soleil discuss all 17 solutions

February 11, 2021 in Videos /by Oz du Soleil

ExcelHash was a lot of fun this year. We opened it up to more participants and the solutions were brilliant. In this video, Bill Jelen (Mr. Excel) and Oz du Soleil discuss each solution: the thrills, the chills, the funny moments and cool, clever Excel tips that blew us away! 0:00 Intro 6:13 Fred Le […]

Excel Hash 2021: The Facilitator | LET function | Power Query Custom Data Types | Excel Challenge

February 3, 2021 in Videos /by Oz du Soleil

0:00 Introduction 1:06 My Solution 5:13 Rabbit needs water 7:26 Correction with the EVEN function ExcelHash is back for 2021! This year we added more participants. Check out the full playlist and think about how you would create a solution. The premise: Take 4 random Excel features and bring them together into an integrated solution. […]