From the course: Excel: Data Validation in Depth
Join today to access over 24,800 courses taught by industry experts.
Using Column profile and quality to confirm values - Microsoft Excel Tutorial
From the course: Excel: Data Validation in Depth
Using Column profile and quality to confirm values
- [Narrator] It can be incredibly easy to work through a process and all the way through the reporting only to discover bad data way too late. Just to share insight from a data analyst who verifies and validates data all the time, this next command is your next best friend. Okay, so let's go ahead and open this up into Power Query. If you see Queries & Connections on the right-hand side, you can right-click and go to Edit. If queries Queries & Connections is not available on your screen, you can go to the Data tab and choose Queries & Connection. All right, I'll go ahead and right-click and choose Edit. This will take me to Power Query. Now, one of the very first things I want to look at is the green bar that's underneath the column headings. If you hover over these green bars, it will tell you a lot of information about your data. For the tour type, as an example, there's 85 valid entries. Now, if any of your data is not valid,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.