08 Jan 2015

Have you copied data from the internet and pasted it in Excel?

It can be very frustrating when the data is messy!

Sometimes there are data quality issues and you should examine the data before adding formulas and formatting.

In my case, I was copying some calendar related data for a template I’m working on and the date values needed correcting. 

 

Download my Excel file

Download here or via my OneDrive (file 00114)

 

Watch my YouTube video   

See how I caught the issue and several ways to fix it.

 

Subscribe to my YouTube channel and learn more!

 

Me With Fenton & Cali

My name is Kevin Lehrbass. I live in Markham, Ontario, Canada.

I’ve enrolled in Power Query Academy! Why not learn Power Query (Get & Transform) with me?

I’m a Data Analyst at McKinsey & Company.

Check out my YouTube videos and my blog posts.

Save

Post a comment