WEBVTT
Kind: captions
Language: en

00:00:00.000 --> 00:00:01.730 align:start position:0%
 
there<00:00:00.630><c> are</c><00:00:00.810><c> a</c><00:00:00.870><c> lot</c><00:00:01.110><c> of</c><00:00:01.140><c> different</c><00:00:01.560><c> ways</c><00:00:01.709><c> to</c>

00:00:01.730 --> 00:00:01.740 align:start position:0%
there are a lot of different ways to
 

00:00:01.740 --> 00:00:04.640 align:start position:0%
there are a lot of different ways to
visualize<00:00:02.159><c> data</c><00:00:02.730><c> in</c><00:00:02.970><c> Excel</c><00:00:03.330><c> but</c><00:00:03.650><c> sometimes</c>

00:00:04.640 --> 00:00:04.650 align:start position:0%
visualize data in Excel but sometimes
 

00:00:04.650 --> 00:00:06.079 align:start position:0%
visualize data in Excel but sometimes
it's<00:00:04.890><c> hard</c><00:00:04.950><c> to</c><00:00:05.160><c> know</c><00:00:05.220><c> where</c><00:00:05.490><c> to</c><00:00:05.580><c> start</c>

00:00:06.079 --> 00:00:06.089 align:start position:0%
it's hard to know where to start
 

00:00:06.089 --> 00:00:08.660 align:start position:0%
it's hard to know where to start
luckily<00:00:06.870><c> the</c><00:00:07.259><c> quick</c><00:00:07.470><c> analysis</c><00:00:08.010><c> tool</c><00:00:08.189><c> offers</c><00:00:08.490><c> a</c>

00:00:08.660 --> 00:00:08.670 align:start position:0%
luckily the quick analysis tool offers a
 

00:00:08.670 --> 00:00:10.730 align:start position:0%
luckily the quick analysis tool offers a
convenient<00:00:09.150><c> way</c><00:00:09.450><c> to</c><00:00:09.480><c> browse</c><00:00:09.960><c> through</c><00:00:09.990><c> many</c><00:00:10.590><c> of</c>

00:00:10.730 --> 00:00:10.740 align:start position:0%
convenient way to browse through many of
 

00:00:10.740 --> 00:00:12.589 align:start position:0%
convenient way to browse through many of
the<00:00:10.860><c> different</c><00:00:11.130><c> options</c><00:00:11.490><c> so</c><00:00:12.030><c> you</c><00:00:12.059><c> can</c><00:00:12.269><c> find</c><00:00:12.509><c> a</c>

00:00:12.589 --> 00:00:12.599 align:start position:0%
the different options so you can find a
 

00:00:12.599 --> 00:00:14.509 align:start position:0%
the different options so you can find a
good<00:00:12.900><c> visualization</c><00:00:13.469><c> even</c><00:00:14.219><c> if</c><00:00:14.309><c> you're</c><00:00:14.460><c> not</c>

00:00:14.509 --> 00:00:14.519 align:start position:0%
good visualization even if you're not
 

00:00:14.519 --> 00:00:17.060 align:start position:0%
good visualization even if you're not
sure<00:00:14.580><c> exactly</c><00:00:15.089><c> what</c><00:00:15.299><c> you</c><00:00:15.509><c> want</c><00:00:15.859><c> this</c><00:00:16.859><c> feature</c>

00:00:17.060 --> 00:00:17.070 align:start position:0%
sure exactly what you want this feature
 

00:00:17.070 --> 00:00:19.939 align:start position:0%
sure exactly what you want this feature
was<00:00:17.310><c> introduced</c><00:00:17.820><c> in</c><00:00:17.970><c> Excel</c><00:00:18.330><c> 2013</c><00:00:18.949><c> so</c>

00:00:19.939 --> 00:00:19.949 align:start position:0%
was introduced in Excel 2013 so
 

00:00:19.949 --> 00:00:22.010 align:start position:0%
was introduced in Excel 2013 so
unfortunately<00:00:20.670><c> it</c><00:00:21.000><c> isn't</c><00:00:21.390><c> available</c><00:00:21.480><c> in</c>

00:00:22.010 --> 00:00:22.020 align:start position:0%
unfortunately it isn't available in
 

00:00:22.020 --> 00:00:24.950 align:start position:0%
unfortunately it isn't available in
older<00:00:22.410><c> versions</c><00:00:23.090><c> to</c><00:00:24.090><c> get</c><00:00:24.240><c> started</c><00:00:24.689><c> select</c>

00:00:24.950 --> 00:00:24.960 align:start position:0%
older versions to get started select
 

00:00:24.960 --> 00:00:26.840 align:start position:0%
older versions to get started select
your<00:00:25.350><c> data</c>

00:00:26.840 --> 00:00:26.850 align:start position:0%
your data
 

00:00:26.850 --> 00:00:28.580 align:start position:0%
your data
and<00:00:26.970><c> you</c><00:00:27.180><c> should</c><00:00:27.390><c> see</c><00:00:27.600><c> this</c><00:00:27.779><c> little</c><00:00:28.020><c> button</c><00:00:28.260><c> in</c>

00:00:28.580 --> 00:00:28.590 align:start position:0%
and you should see this little button in
 

00:00:28.590 --> 00:00:30.850 align:start position:0%
and you should see this little button in
the<00:00:28.740><c> lower</c><00:00:28.980><c> right</c><00:00:29.279><c> corner</c><00:00:29.310><c> of</c><00:00:29.789><c> the</c><00:00:29.939><c> selection</c>

00:00:30.850 --> 00:00:30.860 align:start position:0%
the lower right corner of the selection
 

00:00:30.860 --> 00:00:33.410 align:start position:0%
the lower right corner of the selection
when<00:00:31.860><c> you</c><00:00:31.950><c> click</c><00:00:32.220><c> it</c><00:00:32.369><c> it</c><00:00:32.400><c> will</c><00:00:32.730><c> show</c><00:00:32.759><c> a</c><00:00:32.970><c> menu</c><00:00:33.300><c> of</c>

00:00:33.410 --> 00:00:33.420 align:start position:0%
when you click it it will show a menu of
 

00:00:33.420 --> 00:00:35.660 align:start position:0%
when you click it it will show a menu of
various<00:00:34.110><c> features</c><00:00:34.500><c> to</c><00:00:34.800><c> analyze</c><00:00:35.340><c> and</c>

00:00:35.660 --> 00:00:35.670 align:start position:0%
various features to analyze and
 

00:00:35.670 --> 00:00:37.549 align:start position:0%
various features to analyze and
visualize<00:00:35.700><c> your</c><00:00:36.300><c> data</c><00:00:36.360><c> and</c><00:00:36.809><c> you</c><00:00:37.260><c> can</c><00:00:37.410><c> just</c>

00:00:37.549 --> 00:00:37.559 align:start position:0%
visualize your data and you can just
 

00:00:37.559 --> 00:00:39.110 align:start position:0%
visualize your data and you can just
hover<00:00:37.739><c> over</c><00:00:37.830><c> the</c><00:00:38.160><c> different</c><00:00:38.250><c> options</c><00:00:38.520><c> to</c><00:00:38.970><c> see</c>

00:00:39.110 --> 00:00:39.120 align:start position:0%
hover over the different options to see
 

00:00:39.120 --> 00:00:42.110 align:start position:0%
hover over the different options to see
a<00:00:39.150><c> preview</c><00:00:40.040><c> so</c><00:00:41.040><c> you</c><00:00:41.129><c> can</c><00:00:41.280><c> very</c><00:00:41.520><c> quickly</c><00:00:41.670><c> try</c>

00:00:42.110 --> 00:00:42.120 align:start position:0%
a preview so you can very quickly try
 

00:00:42.120 --> 00:00:43.220 align:start position:0%
a preview so you can very quickly try
out<00:00:42.270><c> a</c><00:00:42.300><c> variety</c><00:00:42.629><c> of</c><00:00:43.019><c> different</c>

00:00:43.220 --> 00:00:43.230 align:start position:0%
out a variety of different
 

00:00:43.230 --> 00:00:45.660 align:start position:0%
out a variety of different
visualizations

00:00:45.660 --> 00:00:45.670 align:start position:0%
visualizations
 

00:00:45.670 --> 00:00:47.759 align:start position:0%
visualizations
if<00:00:45.730><c> you</c><00:00:46.059><c> find</c><00:00:46.329><c> an</c><00:00:46.449><c> option</c><00:00:46.600><c> you</c><00:00:46.809><c> like</c><00:00:46.839><c> you</c><00:00:47.559><c> can</c>

00:00:47.759 --> 00:00:47.769 align:start position:0%
if you find an option you like you can
 

00:00:47.769 --> 00:00:49.069 align:start position:0%
if you find an option you like you can
click<00:00:48.070><c> it</c><00:00:48.219><c> to</c><00:00:48.250><c> make</c><00:00:48.489><c> it</c><00:00:48.609><c> more</c><00:00:48.760><c> permanent</c>

00:00:49.069 --> 00:00:49.079 align:start position:0%
click it to make it more permanent
 

00:00:49.079 --> 00:00:52.939 align:start position:0%
click it to make it more permanent
although<00:00:50.079><c> this</c><00:00:50.260><c> step</c><00:00:50.589><c> is</c><00:00:50.800><c> optional</c>

00:00:52.939 --> 00:00:52.949 align:start position:0%
 
 

00:00:52.949 --> 00:00:54.860 align:start position:0%
 
now<00:00:53.579><c> what</c><00:00:53.760><c> makes</c><00:00:53.940><c> this</c><00:00:54.120><c> feature</c><00:00:54.390><c> really</c>

00:00:54.860 --> 00:00:54.870 align:start position:0%
now what makes this feature really
 

00:00:54.870 --> 00:00:56.990 align:start position:0%
now what makes this feature really
interesting<00:00:55.469><c> is</c><00:00:55.649><c> that</c><00:00:55.710><c> these</c><00:00:56.429><c> options</c><00:00:56.670><c> will</c>

00:00:56.990 --> 00:00:57.000 align:start position:0%
interesting is that these options will
 

00:00:57.000 --> 00:01:00.229 align:start position:0%
interesting is that these options will
vary<00:00:57.420><c> based</c><00:00:57.780><c> on</c><00:00:57.989><c> your</c><00:00:58.170><c> data</c><00:00:58.350><c> in</c><00:00:58.850><c> this</c><00:00:59.850><c> example</c>

00:01:00.229 --> 00:01:00.239 align:start position:0%
vary based on your data in this example
 

00:01:00.239 --> 00:01:02.420 align:start position:0%
vary based on your data in this example
Excel<00:01:00.719><c> noticed</c><00:01:01.109><c> that</c><00:01:01.350><c> we</c><00:01:01.469><c> had</c><00:01:01.649><c> a</c><00:01:01.680><c> column</c><00:01:02.219><c> for</c>

00:01:02.420 --> 00:01:02.430 align:start position:0%
Excel noticed that we had a column for
 

00:01:02.430 --> 00:01:05.690 align:start position:0%
Excel noticed that we had a column for
the<00:01:02.489><c> total</c><00:01:02.969><c> so</c><00:01:03.839><c> it</c><00:01:04.170><c> displayed</c><00:01:04.619><c> that</c><00:01:04.920><c> as</c><00:01:05.129><c> a</c><00:01:05.159><c> line</c>

00:01:05.690 --> 00:01:05.700 align:start position:0%
the total so it displayed that as a line
 

00:01:05.700 --> 00:01:07.550 align:start position:0%
the total so it displayed that as a line
chart<00:01:06.030><c> to</c><00:01:06.450><c> keep</c><00:01:06.600><c> it</c><00:01:06.750><c> separate</c><00:01:07.200><c> from</c><00:01:07.470><c> the</c>

00:01:07.550 --> 00:01:07.560 align:start position:0%
chart to keep it separate from the
 

00:01:07.560 --> 00:01:09.980 align:start position:0%
chart to keep it separate from the
monthly<00:01:07.920><c> data</c><00:01:08.100><c> it's</c><00:01:09.090><c> usually</c><00:01:09.270><c> pretty</c><00:01:09.720><c> smart</c>

00:01:09.980 --> 00:01:09.990 align:start position:0%
monthly data it's usually pretty smart
 

00:01:09.990 --> 00:01:11.870 align:start position:0%
monthly data it's usually pretty smart
about<00:01:10.110><c> this</c><00:01:10.470><c> although</c><00:01:10.799><c> it</c><00:01:11.220><c> will</c><00:01:11.369><c> sometimes</c>

00:01:11.870 --> 00:01:11.880 align:start position:0%
about this although it will sometimes
 

00:01:11.880 --> 00:01:14.180 align:start position:0%
about this although it will sometimes
show<00:01:12.180><c> options</c><00:01:12.659><c> that</c><00:01:12.869><c> don't</c><00:01:13.110><c> work</c><00:01:13.289><c> as</c><00:01:13.470><c> well</c><00:01:13.619><c> so</c>

00:01:14.180 --> 00:01:14.190 align:start position:0%
show options that don't work as well so
 

00:01:14.190 --> 00:01:15.200 align:start position:0%
show options that don't work as well so
you'll<00:01:14.460><c> just</c><00:01:14.520><c> need</c><00:01:14.759><c> to</c><00:01:14.820><c> use</c><00:01:15.030><c> your</c><00:01:15.060><c> own</c>

00:01:15.200 --> 00:01:15.210 align:start position:0%
you'll just need to use your own
 

00:01:15.210 --> 00:01:17.749 align:start position:0%
you'll just need to use your own
judgment<00:01:15.530><c> but</c><00:01:16.530><c> it's</c><00:01:16.740><c> such</c><00:01:16.950><c> a</c><00:01:16.979><c> quick</c><00:01:17.340><c> and</c><00:01:17.580><c> easy</c>

00:01:17.749 --> 00:01:17.759 align:start position:0%
judgment but it's such a quick and easy
 

00:01:17.759 --> 00:01:20.300 align:start position:0%
judgment but it's such a quick and easy
feature<00:01:18.180><c> to</c><00:01:18.390><c> use</c><00:01:18.659><c> I</c><00:01:18.930><c> recommend</c><00:01:19.320><c> just</c><00:01:19.680><c> diving</c>

00:01:20.300 --> 00:01:20.310 align:start position:0%
feature to use I recommend just diving
 

00:01:20.310 --> 00:01:21.920 align:start position:0%
feature to use I recommend just diving
in<00:01:20.460><c> and</c><00:01:20.729><c> seeing</c><00:01:21.030><c> what</c><00:01:21.240><c> it</c><00:01:21.330><c> can</c><00:01:21.450><c> tell</c><00:01:21.630><c> you</c><00:01:21.780><c> about</c>

00:01:21.920 --> 00:01:21.930 align:start position:0%
in and seeing what it can tell you about
 

00:01:21.930 --> 00:01:26.410 align:start position:0%
in and seeing what it can tell you about
your<00:01:22.350><c> data</c>

00:01:26.410 --> 00:01:26.420 align:start position:0%
 
 

00:01:26.420 --> 00:01:28.749 align:start position:0%
 
Goodwill<00:01:27.170><c> Community</c><00:01:27.650><c> Foundation</c><00:01:28.310><c> creating</c>

00:01:28.749 --> 00:01:28.759 align:start position:0%
Goodwill Community Foundation creating
 

00:01:28.759 --> 00:01:31.840 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:01:29.360><c> for</c><00:01:29.570><c> a</c><00:01:29.630><c> better</c><00:01:29.659><c> life</c>