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 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 or a music preference is added/removed?

This challenge came from Chandeep Chhabra at the Goodly YouTube channel.
My solution in Power Query includes:
Left Outer Join with 2 criteria
Cross Join
Conditional Column
Pivot Don’t Aggregate

All handy features that can help you create dynamic solutions in Excel and Power Query.

See the challenge as described by Chandeep: https://youtu.be/7Vow1L8Mu9g

0:00 Intro
0:54 Explaining the challenge
2:15 Starting the solution
4:39 Cross Join
6:34 Merge queries with 2 criteria
8:29 Pivot Don’t Aggregate
9:50 Add more data
10:49 Outro

#ExcelChallenge #FirstClass #PowerQuery

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

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 doesn’t have any numbers? (BIG-DAY)

In this video I show a Power Query solution that uses the Information feature and the Text.Remove function.

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

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 Data Analysis 3
1:00 Octopus Spreadsheets
2:17 “I want to master Excel”
2:48 Mastering a Tool
3:23 Knowing EVERYTHING in Excel
4:40 The Superhuman
5:52 Mastery as in: “providing value”
6:30 Value as a freelancer
7:40 Telling the truth & breaking out
9:51 Advice from Uncle Oz
12:32 Bokeh Effect

To purchase Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
#MasteringExcel

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