Another Excel Experts Live Challenge. This time the guest is Model-Off Champion and superstar in the Financial Modeling World Cup competitions. This time we’re looking at a challenge I faced with a series of course details that got all jumbled and needed to be de-jumbled. Watch Diarmuid solve this in record time. And we get […]
It’s great when people ask for Excel help. It’s not so great when the request is belligerent. In this video I show how I handled a belligerent request to count the number of seconds in the year 2024. You’ll see Dynamic Arrays, SEQUENCE, date formatting, the DAY function and COUNTA … and insight on how […]
Bill Jelen, Mr. Excel, recently posted a video requesting input on ways to retrieve specific data while hiding sensitive data. The challenge: how can you use a person’s last initial and the last-4 of their social security number to retrieve relevant details. HOWEVER! The full social security number should be available but not easily revealed. […]
You’ve got a grid and you want to input a code and retrieve the value tied to that code; e.g., input 33 and you want the name Trish. This is easy if you have a single column of codes alongside a single column of values. That’s a plain VLOOKUP or XLOOKUP. HOWEVER! that’s not how […]
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 […]