Entries by

Wyn Ticket Challenge

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 […]

Excel’s New IMAGE Function: the how-to and the gotchas

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 […]

Creativity and Video Editing in Camtasia

I’ve received a lot of questions about – Editing techniques in Camtasia – Where my creative ideas come from In this video I take you on a tour of a recent video. Specifically, this one on TEXTBEFORE: Let me know if you have any questions about anything in this video. #Camtasia #Camtasia2022 #videoeditingtricks For a […]

DataRails and The Functionary: Excel Top 5 Wall of Shame

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

Excel Campus License Plate Challenge: The Down & Dirty Edition

Jon Acampora of Excel Campus issued a challenge to designate if a license plate is odd or even. In a previous video I showed a Power Query challenge. In this video I show a quick solution that will work, BUT, you have to be wary. This solution isn’t so sophisticated but it’s worth showing you […]

Excel Campus License Plate Challenge: Odd vs. Even Days & License Plates

Jon Acampora of Excel Campus has an interesting challenge: https://youtu.be/-ByG6ULWOtA Yellowstone National Park has a system where cars with even number license plates can come into the park on even numbered days. Odd number plates can enter on odd dates. But what if a license plate doesn’t end with a number? (4CE-3DQ) What if it […]