I just clicked in the video for a glance and got hooked till the end of it. Very very helpful and so simplified! Would love a version of data input and cleaning for law enforcement data analysts!😅
Hi Deb, Your teaching style is undeniably incredible! I’ve learned so much from you, even more than from my paid courses. However, I noticed some odd values in the "Total" column, particularly in the 10th row (before you applied the custom column for the total). It seems like the total in that row should have been 280.00 instead of 200.00, considering the price per unit was 70.00 and the quantity was 4. I found four such discrepancies in the column, but it might have been intentional - not sure, haha. Good thing you fixed those values using the custom column. Thanks again, Deb!
Thank you so much for this tutorial. I followed along and you made it easy because you explain every step thoroughly and slowly for beginners. This is highly appreciated. Thanks again!
Hello, Deb. Thank you so much for this detailed video on cleaning data for pivot table! Your explanations are always clear and concise, and I appreciate the time you took to cover each step thoroughly. The 41 minutes flew by! I am excited to apply these skills to my own projects in future. Thank you for your hard work and dedication to teaching excel skills!
The demo file refuses to download. When email address is entered on the webpage linked above, an automatic email is forwarded with an additional link. Clicking the link in the email leads user to the same page where you're prompted to input email address again. However, this time, no download or second email is sent to user to actually retrieve the demo file.
Sorry about that. Here's the link to the files ssi-member-webinars.s3.amazonaws.com/Cleaning+Data+in+Power+Query+-+October+2023/Cleaning+Data+in+Power+Query+demo+file.zip