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”
Global Excel Summit – 6FEB21 – “Risk Taking as a Content Creator”
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 […]
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. […]
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 Excel challenge that comes out every Friday. Website: https://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition My old blog: http://datascopic.net/blog-2-2
Dependent Dropdown Lists in Excel are pretty handy to know. But there’s an interesting problem when you’ve gotta stack multiple dependent dropdown lists and the source data might add or remove data in the different stages. This video shows how to make this happen using Dynamic Arrays, UNIQUE and the FILTER functions. Also check out […]
The new Wolfram Data Types are pretty interesting, but there are things that you have to watch out for. This video is a sampling of 8 things that are weird about the data types and how they work within Excel. 1:19 Fascinating and Incomplete Entries 2:12 Unexpected Translation 3:29 False Negatives. When looking for a […]
NOTE: this videos shows how I build a solution from scratch. Cristiano Galvão of Excel Turbo posted something fascinating on LinkedIn. He had a main table of data and one column showed each record as Active or Inactive. There were two interesting things about the spreadsheet: 1. If a record was Inactive, the font was […]