WEBVTT
Kind: captions
Language: en

00:00:00.000 --> 00:00:03.080 align:start position:0%
 
in<00:00:00.060><c> Excel</c><00:00:00.750><c> details</c><00:00:01.530><c> matter</c><00:00:01.920><c> if</c><00:00:02.220><c> you</c><00:00:02.909><c> have</c>

00:00:03.080 --> 00:00:03.090 align:start position:0%
in Excel details matter if you have
 

00:00:03.090 --> 00:00:05.329 align:start position:0%
in Excel details matter if you have
minor<00:00:03.480><c> inconsistencies</c><00:00:04.259><c> in</c><00:00:04.440><c> your</c><00:00:04.620><c> data</c><00:00:04.920><c> it</c>

00:00:05.329 --> 00:00:05.339 align:start position:0%
minor inconsistencies in your data it
 

00:00:05.339 --> 00:00:07.160 align:start position:0%
minor inconsistencies in your data it
can<00:00:05.460><c> actually</c><00:00:05.640><c> cause</c><00:00:05.970><c> major</c><00:00:06.390><c> problems</c><00:00:06.569><c> later</c>

00:00:07.160 --> 00:00:07.170 align:start position:0%
can actually cause major problems later
 

00:00:07.170 --> 00:00:09.560 align:start position:0%
can actually cause major problems later
on<00:00:07.490><c> for</c><00:00:08.490><c> example</c><00:00:08.580><c> I</c><00:00:09.030><c> have</c><00:00:09.150><c> a</c><00:00:09.179><c> list</c><00:00:09.269><c> of</c>

00:00:09.560 --> 00:00:09.570 align:start position:0%
on for example I have a list of
 

00:00:09.570 --> 00:00:12.680 align:start position:0%
on for example I have a list of
salespeople<00:00:10.019><c> and</c><00:00:10.469><c> each</c><00:00:11.219><c> one</c><00:00:11.490><c> falls</c><00:00:11.820><c> into</c><00:00:12.120><c> one</c>

00:00:12.680 --> 00:00:12.690 align:start position:0%
salespeople and each one falls into one
 

00:00:12.690 --> 00:00:16.900 align:start position:0%
salespeople and each one falls into one
of<00:00:12.719><c> four</c><00:00:13.290><c> regions</c><00:00:13.740><c> north</c><00:00:14.519><c> south</c><00:00:15.179><c> east</c><00:00:15.960><c> or</c><00:00:16.289><c> west</c>

00:00:16.900 --> 00:00:16.910 align:start position:0%
of four regions north south east or west
 

00:00:16.910 --> 00:00:19.340 align:start position:0%
of four regions north south east or west
but<00:00:17.910><c> if</c><00:00:18.090><c> you</c><00:00:18.180><c> look</c><00:00:18.390><c> closely</c><00:00:18.690><c> you</c><00:00:18.960><c> can</c><00:00:19.020><c> see</c><00:00:19.140><c> that</c>

00:00:19.340 --> 00:00:19.350 align:start position:0%
but if you look closely you can see that
 

00:00:19.350 --> 00:00:21.050 align:start position:0%
but if you look closely you can see that
a<00:00:19.529><c> couple</c><00:00:19.710><c> of</c><00:00:19.920><c> the</c><00:00:20.010><c> values</c><00:00:20.369><c> are</c><00:00:20.580><c> a</c><00:00:20.609><c> little</c><00:00:20.939><c> bit</c>

00:00:21.050 --> 00:00:21.060 align:start position:0%
a couple of the values are a little bit
 

00:00:21.060 --> 00:00:22.939 align:start position:0%
a couple of the values are a little bit
different<00:00:21.449><c> it</c><00:00:21.990><c> looks</c><00:00:22.020><c> like</c><00:00:22.320><c> North</c><00:00:22.740><c> is</c>

00:00:22.939 --> 00:00:22.949 align:start position:0%
different it looks like North is
 

00:00:22.949 --> 00:00:26.179 align:start position:0%
different it looks like North is
misspelled<00:00:23.490><c> and</c><00:00:24.019><c> West</c><00:00:25.019><c> is</c><00:00:25.260><c> also</c><00:00:25.500><c> missing</c><00:00:25.710><c> an</c><00:00:25.920><c> E</c>

00:00:26.179 --> 00:00:26.189 align:start position:0%
misspelled and West is also missing an E
 

00:00:26.189 --> 00:00:28.040 align:start position:0%
misspelled and West is also missing an E
and<00:00:26.369><c> believe</c><00:00:27.269><c> it</c><00:00:27.359><c> or</c><00:00:27.420><c> not</c><00:00:27.510><c> these</c><00:00:27.720><c> small</c>

00:00:28.040 --> 00:00:28.050 align:start position:0%
and believe it or not these small
 

00:00:28.050 --> 00:00:29.779 align:start position:0%
and believe it or not these small
differences<00:00:28.289><c> might</c><00:00:28.980><c> actually</c><00:00:29.160><c> cause</c><00:00:29.490><c> us</c><00:00:29.640><c> to</c>

00:00:29.779 --> 00:00:29.789 align:start position:0%
differences might actually cause us to
 

00:00:29.789 --> 00:00:31.070 align:start position:0%
differences might actually cause us to
get<00:00:29.910><c> the</c><00:00:30.000><c> wrong</c><00:00:30.179><c> result</c><00:00:30.570><c> with</c><00:00:30.779><c> certain</c>

00:00:31.070 --> 00:00:31.080 align:start position:0%
get the wrong result with certain
 

00:00:31.080 --> 00:00:34.190 align:start position:0%
get the wrong result with certain
formulas<00:00:31.590><c> or</c><00:00:31.830><c> pivot</c><00:00:32.189><c> tables</c><00:00:32.809><c> now</c><00:00:33.809><c> since</c><00:00:34.079><c> we</c>

00:00:34.190 --> 00:00:34.200 align:start position:0%
formulas or pivot tables now since we
 

00:00:34.200 --> 00:00:36.889 align:start position:0%
formulas or pivot tables now since we
have<00:00:34.230><c> about</c><00:00:34.559><c> 300</c><00:00:35.340><c> salespeople</c><00:00:35.880><c> finding</c><00:00:36.690><c> all</c>

00:00:36.889 --> 00:00:36.899 align:start position:0%
have about 300 salespeople finding all
 

00:00:36.899 --> 00:00:38.450 align:start position:0%
have about 300 salespeople finding all
of<00:00:36.930><c> the</c><00:00:37.140><c> inconsistencies</c><00:00:37.469><c> would</c><00:00:38.190><c> be</c><00:00:38.280><c> like</c>

00:00:38.450 --> 00:00:38.460 align:start position:0%
of the inconsistencies would be like
 

00:00:38.460 --> 00:00:40.490 align:start position:0%
of the inconsistencies would be like
finding<00:00:38.670><c> a</c><00:00:38.820><c> needle</c><00:00:38.850><c> in</c><00:00:39.180><c> a</c><00:00:39.239><c> haystack</c><00:00:39.420><c> but</c><00:00:40.410><c> I'm</c>

00:00:40.490 --> 00:00:40.500 align:start position:0%
finding a needle in a haystack but I'm
 

00:00:40.500 --> 00:00:41.810 align:start position:0%
finding a needle in a haystack but I'm
going<00:00:40.710><c> to</c><00:00:40.739><c> show</c><00:00:40.890><c> you</c><00:00:40.950><c> a</c><00:00:41.040><c> shortcut</c><00:00:41.489><c> that's</c>

00:00:41.810 --> 00:00:41.820 align:start position:0%
going to show you a shortcut that's
 

00:00:41.820 --> 00:00:44.569 align:start position:0%
going to show you a shortcut that's
going<00:00:41.969><c> to</c><00:00:42.030><c> make</c><00:00:42.149><c> it</c><00:00:42.300><c> a</c><00:00:42.420><c> lot</c><00:00:42.719><c> easier</c><00:00:43.579><c> first</c>

00:00:44.569 --> 00:00:44.579 align:start position:0%
going to make it a lot easier first
 

00:00:44.579 --> 00:00:46.400 align:start position:0%
going to make it a lot easier first
we'll<00:00:44.850><c> need</c><00:00:44.879><c> to</c><00:00:45.030><c> apply</c><00:00:45.360><c> a</c><00:00:45.390><c> filter</c><00:00:45.870><c> to</c><00:00:46.110><c> the</c><00:00:46.230><c> data</c>

00:00:46.400 --> 00:00:46.410 align:start position:0%
we'll need to apply a filter to the data
 

00:00:46.410 --> 00:00:48.080 align:start position:0%
we'll need to apply a filter to the data
and<00:00:46.649><c> you</c><00:00:46.770><c> can</c><00:00:46.890><c> get</c><00:00:47.039><c> there</c><00:00:47.190><c> from</c><00:00:47.309><c> the</c><00:00:47.399><c> sort</c><00:00:47.940><c> and</c>

00:00:48.080 --> 00:00:48.090 align:start position:0%
and you can get there from the sort and
 

00:00:48.090 --> 00:00:51.860 align:start position:0%
and you can get there from the sort and
filter<00:00:48.149><c> command</c><00:00:50.420><c> next</c><00:00:51.420><c> we'll</c><00:00:51.539><c> click</c><00:00:51.719><c> the</c>

00:00:51.860 --> 00:00:51.870 align:start position:0%
filter command next we'll click the
 

00:00:51.870 --> 00:00:53.810 align:start position:0%
filter command next we'll click the
filter<00:00:52.260><c> drop-down</c><00:00:52.590><c> arrow</c><00:00:53.039><c> for</c><00:00:53.370><c> the</c><00:00:53.399><c> region</c>

00:00:53.810 --> 00:00:53.820 align:start position:0%
filter drop-down arrow for the region
 

00:00:53.820 --> 00:00:56.840 align:start position:0%
filter drop-down arrow for the region
column<00:00:54.530><c> now</c><00:00:55.530><c> this</c><00:00:55.680><c> is</c><00:00:55.800><c> showing</c><00:00:55.829><c> us</c><00:00:56.250><c> a</c><00:00:56.399><c> list</c><00:00:56.699><c> of</c>

00:00:56.840 --> 00:00:56.850 align:start position:0%
column now this is showing us a list of
 

00:00:56.850 --> 00:00:58.939 align:start position:0%
column now this is showing us a list of
all<00:00:57.059><c> of</c><00:00:57.120><c> the</c><00:00:57.510><c> unique</c><00:00:57.870><c> values</c><00:00:58.410><c> in</c><00:00:58.590><c> this</c><00:00:58.739><c> column</c>

00:00:58.939 --> 00:00:58.949 align:start position:0%
all of the unique values in this column
 

00:00:58.949 --> 00:01:01.160 align:start position:0%
all of the unique values in this column
and<00:00:59.309><c> what</c><00:01:00.239><c> we're</c><00:01:00.359><c> going</c><00:01:00.510><c> to</c><00:01:00.570><c> do</c><00:01:00.719><c> now</c><00:01:00.899><c> is</c>

00:01:01.160 --> 00:01:01.170 align:start position:0%
and what we're going to do now is
 

00:01:01.170 --> 00:01:04.280 align:start position:0%
and what we're going to do now is
deselect<00:01:01.859><c> only</c><00:01:02.579><c> the</c><00:01:02.730><c> correct</c><00:01:03.000><c> values</c><00:01:03.510><c> so</c><00:01:04.170><c> will</c>

00:01:04.280 --> 00:01:04.290 align:start position:0%
deselect only the correct values so will
 

00:01:04.290 --> 00:01:10.219 align:start position:0%
deselect only the correct values so will
deselect<00:01:04.650><c> east</c><00:01:05.630><c> north</c><00:01:06.830><c> south</c><00:01:07.830><c> and</c><00:01:08.220><c> west</c><00:01:09.229><c> so</c>

00:01:10.219 --> 00:01:10.229 align:start position:0%
deselect east north south and west so
 

00:01:10.229 --> 00:01:12.020 align:start position:0%
deselect east north south and west so
we're<00:01:10.350><c> only</c><00:01:10.500><c> leaving</c><00:01:10.860><c> the</c><00:01:11.070><c> incorrect</c><00:01:11.549><c> values</c>

00:01:12.020 --> 00:01:12.030 align:start position:0%
we're only leaving the incorrect values
 

00:01:12.030 --> 00:01:16.219 align:start position:0%
we're only leaving the incorrect values
checked<00:01:12.860><c> then</c><00:01:13.860><c> click</c><00:01:14.159><c> OK</c><00:01:14.460><c> and</c><00:01:15.020><c> this</c><00:01:16.020><c> filter</c>

00:01:16.219 --> 00:01:16.229 align:start position:0%
checked then click OK and this filter
 

00:01:16.229 --> 00:01:17.840 align:start position:0%
checked then click OK and this filter
has<00:01:16.470><c> basically</c><00:01:16.950><c> pulled</c><00:01:17.250><c> all</c><00:01:17.580><c> of</c><00:01:17.729><c> those</c>

00:01:17.840 --> 00:01:17.850 align:start position:0%
has basically pulled all of those
 

00:01:17.850 --> 00:01:19.760 align:start position:0%
has basically pulled all of those
needles<00:01:18.180><c> out</c><00:01:18.390><c> of</c><00:01:18.540><c> the</c><00:01:18.630><c> haystack</c><00:01:19.020><c> for</c><00:01:19.350><c> us</c><00:01:19.530><c> and</c>

00:01:19.760 --> 00:01:19.770 align:start position:0%
needles out of the haystack for us and
 

00:01:19.770 --> 00:01:22.219 align:start position:0%
needles out of the haystack for us and
now<00:01:20.490><c> we'll</c><00:01:20.670><c> just</c><00:01:20.820><c> need</c><00:01:20.909><c> to</c><00:01:21.210><c> manually</c><00:01:21.750><c> fix</c><00:01:21.960><c> each</c>

00:01:22.219 --> 00:01:22.229 align:start position:0%
now we'll just need to manually fix each
 

00:01:22.229 --> 00:01:26.120 align:start position:0%
now we'll just need to manually fix each
one

00:01:26.120 --> 00:01:26.130 align:start position:0%
 
 

00:01:26.130 --> 00:01:28.160 align:start position:0%
 
and<00:01:26.219><c> now</c><00:01:26.850><c> if</c><00:01:27.030><c> you</c><00:01:27.149><c> click</c><00:01:27.299><c> on</c><00:01:27.420><c> the</c><00:01:27.540><c> filter</c><00:01:27.840><c> again</c>

00:01:28.160 --> 00:01:28.170 align:start position:0%
and now if you click on the filter again
 

00:01:28.170 --> 00:01:29.749 align:start position:0%
and now if you click on the filter again
you<00:01:28.350><c> can</c><00:01:28.500><c> see</c><00:01:28.680><c> that</c><00:01:28.860><c> we've</c><00:01:28.979><c> paired</c><00:01:29.340><c> this</c><00:01:29.490><c> down</c>

00:01:29.749 --> 00:01:29.759 align:start position:0%
you can see that we've paired this down
 

00:01:29.759 --> 00:01:31.850 align:start position:0%
you can see that we've paired this down
to<00:01:30.000><c> only</c><00:01:30.240><c> the</c><00:01:30.630><c> four</c><00:01:30.869><c> values</c><00:01:31.289><c> that</c><00:01:31.500><c> we</c><00:01:31.680><c> actually</c>

00:01:31.850 --> 00:01:31.860 align:start position:0%
to only the four values that we actually
 

00:01:31.860 --> 00:01:35.389 align:start position:0%
to only the four values that we actually
want<00:01:32.250><c> so</c><00:01:32.460><c> now</c><00:01:33.360><c> just</c><00:01:33.570><c> select</c><00:01:34.049><c> all</c><00:01:34.259><c> and</c><00:01:34.530><c> click</c><00:01:35.009><c> OK</c>

00:01:35.389 --> 00:01:35.399 align:start position:0%
want so now just select all and click OK
 

00:01:35.399 --> 00:01:38.660 align:start position:0%
want so now just select all and click OK
and<00:01:35.579><c> now</c><00:01:36.229><c> we</c><00:01:37.229><c> know</c><00:01:37.590><c> that</c><00:01:37.619><c> all</c><00:01:37.829><c> the</c><00:01:38.220><c> values</c><00:01:38.520><c> in</c>

00:01:38.660 --> 00:01:38.670 align:start position:0%
and now we know that all the values in
 

00:01:38.670 --> 00:01:44.640 align:start position:0%
and now we know that all the values in
this<00:01:38.759><c> column</c><00:01:38.970><c> are</c><00:01:39.270><c> nice</c><00:01:39.659><c> and</c><00:01:39.869><c> consistent</c>

00:01:44.640 --> 00:01:44.650 align:start position:0%
 
 

00:01:44.650 --> 00:01:47.010 align:start position:0%
 
Goodwill<00:01:45.430><c> Community</c><00:01:45.910><c> Foundation</c><00:01:46.540><c> creating</c>

00:01:47.010 --> 00:01:47.020 align:start position:0%
Goodwill Community Foundation creating
 

00:01:47.020 --> 00:01:50.070 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:01:47.590><c> for</c><00:01:47.620><c> a</c><00:01:47.860><c> better</c><00:01:47.890><c> life</c>