Entries by Oz du Soleil

Celebrating 1000 Subscribers to Excel on Fire

Thanks for all of the suggestions on what we could do with this CELEBRATION OF 1000 SUBSCRIBERS! In this video I responded to your suggestions and there’s no Excel here. Surprisingly, more people were interested in “a day in the life.” So, you get a bit of that–including a recipe for cooking alligator. I hope […]

Excel Power Query Data Cleansing Part 3 Consolidate Workbooks Worksheets Using Power Query

In this final video of the 3 part training series on Excel Power Query & Data Cleansing you will learn the different ways to consolidate your various Excel workbooks and worksheets using Power Query. Download the Excel workbooks used in this tutorial to practice: http://myexcelonline.com/blog/wp-content/uploads/2016/06/Data-Cleaning-Power-Query-Training-Video-3.zip This training is for beginners & intermediate Excel users and […]

Excel Power Query Data Cleansing Part 1 Different Ways to Format Data Using Power Query

In this 1st of a 3 part training series on Excel Power Query & Data Cleansing you will learn the different ways to format your messy data using Power Query. Download the Excel workbooks used in this tutorial to practice: http://myexcelonline.com/blog/wp-content/uploads/2016/06/Power-Query-Data-Cleansing-Excel-Workbooks.zip This training is for beginners & intermediate Excel users and can be applied to […]

Let’s Celebrate Clean Data and 1000 Subscribers!

Thanks to everyone who’s subscribed, commented, sent in questions that became videos. Around this time last year I changed my video production style and you’ve responded surprisingly well. This channel is about to cross the 1000-subscriber mark. What should we do about that? I would like your suggestions for a video that I can make […]