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 […]
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
Here is an interesting challenge. With a column of names, and a column of musical preferences and each person has multiple music preferences, how can the preferences be split such that you have TRUE if a person has that preference, and FALSE if a person does not? One twist: what if there’s a person added/removed […]
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 […]
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 […]
Excel finally has a built-in feature for extracting data/text from an image. In this video I have 2 demonstrations and compare the results to OneNote’s “Copy Text From Image.” 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 […]
This question comes to me at least weekly: “Oz, how can I master Excel?” In this video I dissect various ways that we can think about ‘mastery.’ And I close with some advice for no matter what you do in Excel. 0:00 Guerrilla Data Analysis 3 is now available as PDF 0:30 Description of Guerrilla […]
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
You have a list of contests and the decisions made by the judges in 3 columns, like this: Contest1: Goblins – Sharks – Sharks Contest2: Penguins – Thunder – Penguins How can use Excel to show that the Sharks won Contest1 and the Penguins won Contest2? That’s the challenge. This video includes a meditation and […]