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 […]
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 […]
In this 2nd of a 3 part training series on Excel Power Query & Data Cleansing you will learn the different ways to clean and extract data using Excel formulas and Excel’s built in analytical tools. This training is for beginners & intermediate Excel users and can be applied to Microsoft Excel 2003, 2007, 2010, […]
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 […]
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 […]
(Download the workbook here: http://datascopic.net/leading-zeros) Here’s another video with warning about some things that native Excel handles easier than Get & Transform (Power Query) does, but if we have to do this in Get & Transform, here’s how. Challenge: handling leading zeros. Excel is known for clipping off leading zeroes. If you need a the […]
Here’s another video that offers warnings about Excel’s Get and Transform (Power Query). Get and Transform does a lot of exciting things, but there are some things that are still better done in native Excel, and there unexpected ways you can be stung. So, rather than how-to, this video warns about ways to get stung […]
Problem: a tall column of data that needs to be unstacked and converted into neat columns and rows. Twist: the distinction where the list needs to be divided is by bold font. (Download the workbook: http://datascopic.net/unstackingboldfont ) Parents’ names are bold. Childrens’ names are regular font. How does this list get unstacked with the children […]
Excel’s Get & Transform is a fantastic tool, but there are some warnings that you should be aware of before you get stung. (Watch out for the scorpion) This video shows 3 ways you can get stung: 3:20 – 6:24 Column headers are hard-coded. If you need a column header to be variable, it’s a […]