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 3rd Edition https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/ My old blog: http://datascopic.net/blog-2-2
Celia Alves, MVP, Developer and content creator at @CeliaAlvesSolveExcel is the next one to step up for an Excel Experts Live Challenge! Here, we have cupcake orders and flavors, and need to tally how many of each flavor needs to be made. But, it’s not that easy. There are twists. 😉 Check it out! Watch […]
Next in the series of Excel Expert Live Challenges we have world renowned Chandoo! The challenge: Identify the palindromes (ignoring spaces and punctuation) This is a fascinating experience as Chandoo shows some Excel mastery and mixes it with real world decisions about what’s worth chasing down and what’s not. It opens an important discussion about […]
MVP, Dummer and Engineer, Victor Momoh from Lagos Nigeria steps up to take a live challenge. This time: Calculate earnings based on clopens. What is a clopen? It’s when a person works the evening shift and closes a store, then is scheduled to return in the morning to open the store. Get it? Close, then […]
Mr. Excel, Bill Jelen, was gracious enough to be the first in a series that I call: Excel Expert Live Challenge. This is where I present a challenge to a Microsoft Excel expert and ask them to talk us through what they see, and the choices they make as they work toward a solution. In […]
In my previous video I uncovered something odd about VSTACK. Turns out, VSTACK is doing what it’s supposed to do. I show that in the video. And that leads to something fascinating: EXPAND. The EXPAND function on its own seems strange and pointless. However, in this situation EXPAND saves the day in a practical example. […]
This video includes the weaving together of 7 dynamic array functions in the creation of a solution. Wyn Hopkins, fellow Microsoft Excel MVP, presented a challenge recently: If you have a list of people and their ticket numbers: Lisa Tickets: 300-303 KC Tickets 390-390 Aaron Tickets 772-778 How can you get a list of the […]
Power Query does some odd things because it’s so case-sensitive. If you want to sort this list: iPhone Ice Cream USB cable Power Query will return: Ice Cream USB Cable iPhone If you need to do a merge with: De Soto and de Soto Power Query will not get those matched. In this video I […]
There’s a new function in Excel–a function that we’ve been waiting and hoping for for a long time. The IMAGE function. IMAGE makes it easy to bring images into Excel and use them as variables. However, you can count on me to not only show you how Excel features work, but also issue warning. This […]