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 […]
The TEXTBEFORE functions was recently released in this video I show 3 uses for TEXTBEFORE, it’s strengths and limitations. In this example we have names and professional designations. The problem is some people have more than one designations, some have 1 designation and some folks have no designations. BUT! We have to be careful. We […]
14 new functions were released into Excel recently. In this video I cover two of them: TOCOL: converts a rectangular matrix into a single column DROP: retrieves a rectangular array and drops (eliminates) columns that aren’t needed. One thing to know: you can drop columns starting from the beginning or end of a range. You […]
I was on a couple of Meetup Zoom calls and Victor Momoh was the host. He showed some fascinating stuff by using XLOOKUP to retrieve a range of data. He then used it to make sums and all kinds of other cool things. I share some of that in this video with you. – Victor […]
My very first need for Excel’s VBA was back in 2009. I had a lot of data and the content I needed was the bold font in the cells. Some how, the non-bold font needed to go away. Back then, some kind soul on an online forum wrote me some VBA code that I didn’t […]
Mr. Excel, Bill Jelen, contacted me with a question that he’d been asked: Can you arrange seating such that every person in attendance will sit at a table with every other person, at least once? The parameters: – 100 people – 10 tables – 10 seats t each table – 11 rounds Bill concluded that […]