Passport Data Preparation - Part 1 | Webinar series with Genesys

Описание: In this part of the Passport Data Preparation webinar series with Genesys, we cover the most common data cleaning shortcuts and functions in Excel.
If you would like to request the data sample used in this demonstration, or the PDF that documents all these steps, please contact [email protected]

0- Introduction of this webinar series, contents and the interface 00:00:00 - 00:08:58

1- Finding hidden data

Unhide columns 00:08:58 - 00:10:03
Adjust row sizes 00:10:03 - 00:12:15
Go to last cell 00:12:15 - 00:14:51
Review data in notes and comments 00:14:51 - 00:18:08
Find invisible data and recolor 00:18:08 - 00:19:57

2- Making data legible

Clearing formats 00:20:15 - 00:21:41
Create an Excel Table 00:21:41 - 00:25:22
Splitting one column into two 00:25:22 - 00:29:28
Change cases for case-sensitive data and Erase leading and trailing spaces 00:29:28 - 00:38:25
Disconnect data from function 00:38:25 - 00:44:25

3- Easing into data standardization to MCPD
Merging two columns into one 00:44:25 - 00:49:30
Intro to the standard of passport data: MCPD v.2.1 00:49:30 - 00:52:51
Creating the lookup table of column headers to MCPD 00:52:51 - 00:58:55
Mapping headers to MCPD using the lookup table 00:58:55 - 1:07:30

Extra: Formatting dates in Excel 1:07:30 - 1:12:35