WEBVTT
Kind: captions
Language: en

00:00:06.109 --> 00:00:08.690 align:start position:0%
 
suppose<00:00:07.109><c> you</c><00:00:07.319><c> need</c><00:00:07.470><c> to</c><00:00:07.649><c> create</c><00:00:07.980><c> in</c><00:00:08.130><c> Microsoft</c>

00:00:08.690 --> 00:00:08.700 align:start position:0%
suppose you need to create in Microsoft
 

00:00:08.700 --> 00:00:10.810 align:start position:0%
suppose you need to create in Microsoft
Office<00:00:08.880><c> Excel</c><00:00:09.210><c> workbook</c><00:00:10.050><c> by</c><00:00:10.410><c> this</c><00:00:10.469><c> afternoon</c>

00:00:10.810 --> 00:00:10.820 align:start position:0%
Office Excel workbook by this afternoon
 

00:00:10.820 --> 00:00:14.270 align:start position:0%
Office Excel workbook by this afternoon
but<00:00:11.820><c> you</c><00:00:11.969><c> don't</c><00:00:12.179><c> know</c><00:00:12.360><c> how</c><00:00:12.660><c> or</c><00:00:13.049><c> you</c><00:00:13.650><c> know</c><00:00:14.009><c> how</c>

00:00:14.270 --> 00:00:14.280 align:start position:0%
but you don't know how or you know how
 

00:00:14.280 --> 00:00:16.760 align:start position:0%
but you don't know how or you know how
but<00:00:14.639><c> you</c><00:00:14.759><c> just</c><00:00:14.969><c> don't</c><00:00:15.150><c> have</c><00:00:15.240><c> time</c><00:00:15.540><c> you</c><00:00:15.900><c> can</c>

00:00:16.760 --> 00:00:16.770 align:start position:0%
but you just don't have time you can
 

00:00:16.770 --> 00:00:19.070 align:start position:0%
but you just don't have time you can
simply<00:00:17.310><c> solve</c><00:00:17.490><c> the</c><00:00:17.730><c> problem</c><00:00:18.240><c> by</c><00:00:18.359><c> using</c><00:00:18.420><c> one</c><00:00:19.050><c> of</c>

00:00:19.070 --> 00:00:19.080 align:start position:0%
simply solve the problem by using one of
 

00:00:19.080 --> 00:00:22.420 align:start position:0%
simply solve the problem by using one of
excels<00:00:19.560><c> dynamic</c><00:00:20.310><c> and</c><00:00:20.520><c> easy</c><00:00:20.880><c> to</c><00:00:21.150><c> use</c><00:00:21.180><c> templates</c>

00:00:22.420 --> 00:00:22.430 align:start position:0%
excels dynamic and easy to use templates
 

00:00:22.430 --> 00:00:24.650 align:start position:0%
excels dynamic and easy to use templates
use<00:00:23.430><c> the</c><00:00:23.609><c> templates</c><00:00:24.090><c> in</c><00:00:24.210><c> their</c><00:00:24.390><c> original</c>

00:00:24.650 --> 00:00:24.660 align:start position:0%
use the templates in their original
 

00:00:24.660 --> 00:00:27.019 align:start position:0%
use the templates in their original
formats<00:00:25.380><c> or</c><00:00:25.680><c> customize</c><00:00:26.460><c> it</c><00:00:26.670><c> to</c><00:00:26.789><c> fit</c><00:00:26.820><c> your</c>

00:00:27.019 --> 00:00:27.029 align:start position:0%
formats or customize it to fit your
 

00:00:27.029 --> 00:00:29.720 align:start position:0%
formats or customize it to fit your
needs<00:00:27.830><c> let's</c><00:00:28.830><c> take</c><00:00:29.130><c> a</c><00:00:29.160><c> look</c><00:00:29.460><c> at</c><00:00:29.580><c> these</c>

00:00:29.720 --> 00:00:29.730 align:start position:0%
needs let's take a look at these
 

00:00:29.730 --> 00:00:33.110 align:start position:0%
needs let's take a look at these
templates<00:00:30.470><c> to</c><00:00:31.470><c> access</c><00:00:32.040><c> the</c><00:00:32.189><c> templates</c><00:00:32.700><c> click</c>

00:00:33.110 --> 00:00:33.120 align:start position:0%
templates to access the templates click
 

00:00:33.120 --> 00:00:36.830 align:start position:0%
templates to access the templates click
on<00:00:33.390><c> the</c><00:00:33.570><c> Microsoft</c><00:00:33.930><c> Office</c><00:00:34.530><c> button</c><00:00:35.329><c> click</c><00:00:36.329><c> new</c>

00:00:36.830 --> 00:00:36.840 align:start position:0%
on the Microsoft Office button click new
 

00:00:36.840 --> 00:00:41.200 align:start position:0%
on the Microsoft Office button click new
and<00:00:37.489><c> the</c><00:00:38.489><c> new</c><00:00:38.790><c> workbook</c><00:00:39.629><c> dialog</c><00:00:40.230><c> box</c><00:00:40.559><c> appears</c>

00:00:41.200 --> 00:00:41.210 align:start position:0%
and the new workbook dialog box appears
 

00:00:41.210 --> 00:00:43.910 align:start position:0%
and the new workbook dialog box appears
you<00:00:42.210><c> now</c><00:00:42.420><c> have</c><00:00:42.690><c> the</c><00:00:42.809><c> option</c><00:00:42.989><c> of</c><00:00:43.440><c> choosing</c><00:00:43.680><c> a</c>

00:00:43.910 --> 00:00:43.920 align:start position:0%
you now have the option of choosing a
 

00:00:43.920 --> 00:00:47.060 align:start position:0%
you now have the option of choosing a
template<00:00:44.520><c> from</c><00:00:44.670><c> your</c><00:00:44.879><c> computer</c><00:00:45.420><c> or</c><00:00:46.070><c> Microsoft</c>

00:00:47.060 --> 00:00:47.070 align:start position:0%
template from your computer or Microsoft
 

00:00:47.070 --> 00:00:49.700 align:start position:0%
template from your computer or Microsoft
Office<00:00:47.460><c> online</c><00:00:47.690><c> which</c><00:00:48.690><c> does</c><00:00:48.989><c> require</c><00:00:49.320><c> an</c>

00:00:49.700 --> 00:00:49.710 align:start position:0%
Office online which does require an
 

00:00:49.710 --> 00:00:52.430 align:start position:0%
Office online which does require an
internet<00:00:50.129><c> connection</c><00:00:51.020><c> we</c><00:00:52.020><c> can</c><00:00:52.260><c> make</c><00:00:52.410><c> a</c>

00:00:52.430 --> 00:00:52.440 align:start position:0%
internet connection we can make a
 

00:00:52.440 --> 00:00:54.319 align:start position:0%
internet connection we can make a
selection<00:00:52.860><c> from</c><00:00:53.100><c> many</c><00:00:53.670><c> different</c><00:00:54.090><c> options</c>

00:00:54.319 --> 00:00:54.329 align:start position:0%
selection from many different options
 

00:00:54.329 --> 00:01:11.500 align:start position:0%
selection from many different options
such<00:00:55.170><c> as</c><00:00:55.199><c> budgets</c><00:00:59.660><c> invoices</c><00:01:01.760><c> receipts</c><00:01:09.380><c> and</c>

00:01:11.500 --> 00:01:11.510 align:start position:0%
such as budgets invoices receipts and
 

00:01:11.510 --> 00:01:15.200 align:start position:0%
such as budgets invoices receipts and
schedules<00:01:12.510><c> just</c><00:01:12.780><c> to</c><00:01:13.290><c> name</c><00:01:13.439><c> a</c><00:01:13.470><c> few</c><00:01:13.939><c> let's</c><00:01:14.939><c> take</c>

00:01:15.200 --> 00:01:15.210 align:start position:0%
schedules just to name a few let's take
 

00:01:15.210 --> 00:01:22.630 align:start position:0%
schedules just to name a few let's take
a<00:01:15.240><c> look</c><00:01:15.600><c> at</c><00:01:15.750><c> invoice</c><00:01:16.140><c> templates</c><00:01:16.740><c> online</c>

00:01:22.630 --> 00:01:22.640 align:start position:0%
 
 

00:01:22.640 --> 00:01:23.859 align:start position:0%
 
pet-sitting

00:01:23.859 --> 00:01:23.869 align:start position:0%
pet-sitting
 

00:01:23.869 --> 00:01:26.719 align:start position:0%
pet-sitting
summer<00:01:24.869><c> time</c><00:01:25.170><c> is</c><00:01:25.350><c> almost</c><00:01:25.590><c> here</c><00:01:25.890><c> and</c><00:01:26.280><c> I</c><00:01:26.490><c> know</c><00:01:26.549><c> a</c>

00:01:26.719 --> 00:01:26.729 align:start position:0%
summer time is almost here and I know a
 

00:01:26.729 --> 00:01:29.350 align:start position:0%
summer time is almost here and I know a
lot<00:01:26.970><c> of</c><00:01:27.030><c> kids</c><00:01:27.330><c> make</c><00:01:27.630><c> extra</c><00:01:27.990><c> money</c><00:01:28.020><c> pet-sitting</c>

00:01:29.350 --> 00:01:29.360 align:start position:0%
lot of kids make extra money pet-sitting
 

00:01:29.360 --> 00:01:31.609 align:start position:0%
lot of kids make extra money pet-sitting
when<00:01:30.360><c> you</c><00:01:30.479><c> find</c><00:01:30.780><c> a</c><00:01:30.930><c> spreadsheet</c><00:01:31.439><c> that</c><00:01:31.470><c> you</c>

00:01:31.609 --> 00:01:31.619 align:start position:0%
when you find a spreadsheet that you
 

00:01:31.619 --> 00:01:34.420 align:start position:0%
when you find a spreadsheet that you
like<00:01:31.950><c> left</c><00:01:32.490><c> click</c><00:01:32.880><c> it</c><00:01:33.030><c> to</c><00:01:33.150><c> select</c><00:01:33.329><c> it</c><00:01:33.750><c> and</c><00:01:33.900><c> then</c>

00:01:34.420 --> 00:01:34.430 align:start position:0%
like left click it to select it and then
 

00:01:34.430 --> 00:01:38.210 align:start position:0%
like left click it to select it and then
click<00:01:35.430><c> download</c><00:01:36.500><c> when</c><00:01:37.500><c> the</c><00:01:37.619><c> spreadsheet</c>

00:01:38.210 --> 00:01:38.220 align:start position:0%
click download when the spreadsheet
 

00:01:38.220 --> 00:01:40.940 align:start position:0%
click download when the spreadsheet
opens<00:01:38.790><c> you'll</c><00:01:39.420><c> notice</c><00:01:39.900><c> these</c><00:01:40.079><c> brackets</c><00:01:40.500><c> with</c>

00:01:40.940 --> 00:01:40.950 align:start position:0%
opens you'll notice these brackets with
 

00:01:40.950 --> 00:01:43.670 align:start position:0%
opens you'll notice these brackets with
prefilled<00:01:41.460><c> text</c><00:01:42.200><c> this</c><00:01:43.200><c> is</c><00:01:43.409><c> called</c>

00:01:43.670 --> 00:01:43.680 align:start position:0%
prefilled text this is called
 

00:01:43.680 --> 00:01:47.030 align:start position:0%
prefilled text this is called
placeholder<00:01:44.549><c> text</c><00:01:44.759><c> if</c><00:01:45.180><c> we</c><00:01:46.170><c> click</c><00:01:46.470><c> on</c><00:01:46.500><c> the</c><00:01:46.799><c> text</c>

00:01:47.030 --> 00:01:47.040 align:start position:0%
placeholder text if we click on the text
 

00:01:47.040 --> 00:01:50.780 align:start position:0%
placeholder text if we click on the text
it<00:01:47.670><c> will</c><00:01:48.060><c> appear</c><00:01:48.420><c> in</c><00:01:48.509><c> the</c><00:01:48.600><c> formula</c><00:01:48.930><c> bar</c><00:01:49.140><c> we</c><00:01:49.790><c> can</c>

00:01:50.780 --> 00:01:50.790 align:start position:0%
it will appear in the formula bar we can
 

00:01:50.790 --> 00:01:52.789 align:start position:0%
it will appear in the formula bar we can
change<00:01:51.000><c> the</c><00:01:51.119><c> text</c><00:01:51.479><c> here</c><00:01:51.540><c> in</c><00:01:51.990><c> the</c><00:01:52.079><c> formula</c><00:01:52.409><c> bar</c>

00:01:52.789 --> 00:01:52.799 align:start position:0%
change the text here in the formula bar
 

00:01:52.799 --> 00:01:57.190 align:start position:0%
change the text here in the formula bar
or<00:01:53.130><c> just</c><00:01:53.180><c> start</c><00:01:54.180><c> typing</c><00:01:54.630><c> in</c><00:01:54.750><c> the</c><00:01:54.840><c> spreadsheet</c>

00:01:57.190 --> 00:01:57.200 align:start position:0%
 
 

00:01:57.200 --> 00:02:00.350 align:start position:0%
 
speaking<00:01:58.200><c> of</c><00:01:58.320><c> formulas</c><00:01:58.950><c> the</c><00:01:59.460><c> biggest</c><00:01:59.939><c> reason</c>

00:02:00.350 --> 00:02:00.360 align:start position:0%
speaking of formulas the biggest reason
 

00:02:00.360 --> 00:02:02.749 align:start position:0%
speaking of formulas the biggest reason
templates<00:02:00.930><c> are</c><00:02:01.049><c> so</c><00:02:01.200><c> amazing</c><00:02:01.860><c> is</c><00:02:02.040><c> because</c><00:02:02.640><c> they</c>

00:02:02.749 --> 00:02:02.759 align:start position:0%
templates are so amazing is because they
 

00:02:02.759 --> 00:02:04.789 align:start position:0%
templates are so amazing is because they
come<00:02:02.969><c> formatted</c><00:02:03.659><c> with</c><00:02:03.689><c> embedded</c><00:02:04.170><c> formulas</c>

00:02:04.789 --> 00:02:04.799 align:start position:0%
come formatted with embedded formulas
 

00:02:04.799 --> 00:02:07.910 align:start position:0%
come formatted with embedded formulas
all<00:02:05.579><c> you</c><00:02:06.270><c> have</c><00:02:06.420><c> to</c><00:02:06.570><c> do</c><00:02:06.750><c> is</c><00:02:07.049><c> fill</c><00:02:07.469><c> in</c><00:02:07.680><c> your</c>

00:02:07.910 --> 00:02:07.920 align:start position:0%
all you have to do is fill in your
 

00:02:07.920 --> 00:02:10.330 align:start position:0%
all you have to do is fill in your
information<00:02:08.280><c> and</c><00:02:08.849><c> Excel</c><00:02:09.239><c> will</c><00:02:09.270><c> do</c><00:02:09.509><c> the</c><00:02:09.629><c> rest</c>

00:02:10.330 --> 00:02:10.340 align:start position:0%
information and Excel will do the rest
 

00:02:10.340 --> 00:02:13.320 align:start position:0%
information and Excel will do the rest
let's<00:02:11.340><c> fill</c><00:02:11.700><c> out</c><00:02:11.849><c> this</c><00:02:12.030><c> invoice</c><00:02:12.270><c> so</c><00:02:12.900><c> you</c><00:02:13.020><c> can</c>

00:02:13.320 --> 00:02:13.330 align:start position:0%
let's fill out this invoice so you can
 

00:02:13.330 --> 00:02:17.010 align:start position:0%
let's fill out this invoice so you can
what<00:02:13.480><c> I'm</c><00:02:13.570><c> talking</c><00:02:13.870><c> about</c><00:02:15.570><c> I'm</c><00:02:16.570><c> going</c><00:02:16.870><c> to</c>

00:02:17.010 --> 00:02:17.020 align:start position:0%
what I'm talking about I'm going to
 

00:02:17.020 --> 00:02:23.370 align:start position:0%
what I'm talking about I'm going to
enter<00:02:17.350><c> the</c><00:02:17.470><c> dates</c><00:02:20.730><c> the</c><00:02:21.730><c> services</c><00:02:22.540><c> provided</c><00:02:23.230><c> on</c>

00:02:23.370 --> 00:02:23.380 align:start position:0%
enter the dates the services provided on
 

00:02:23.380 --> 00:02:30.950 align:start position:0%
enter the dates the services provided on
that<00:02:23.560><c> date</c><00:02:26.640><c> the</c><00:02:27.640><c> time</c><00:02:27.970><c> I</c><00:02:28.000><c> started</c><00:02:28.690><c> working</c><00:02:29.400><c> and</c>

00:02:30.950 --> 00:02:30.960 align:start position:0%
that date the time I started working and
 

00:02:30.960 --> 00:02:37.260 align:start position:0%
that date the time I started working and
the<00:02:31.960><c> time</c><00:02:32.200><c> I</c><00:02:32.230><c> stopped</c><00:02:32.710><c> working</c><00:02:35.400><c> see</c><00:02:36.400><c> Excel</c>

00:02:37.260 --> 00:02:37.270 align:start position:0%
the time I stopped working see Excel
 

00:02:37.270 --> 00:02:41.370 align:start position:0%
the time I stopped working see Excel
calculated<00:02:37.900><c> my</c><00:02:38.020><c> total</c><00:02:38.470><c> time</c><00:02:38.710><c> worked</c><00:02:39.780><c> now</c><00:02:40.780><c> I'm</c>

00:02:41.370 --> 00:02:41.380 align:start position:0%
calculated my total time worked now I'm
 

00:02:41.380 --> 00:02:43.080 align:start position:0%
calculated my total time worked now I'm
going<00:02:41.800><c> to</c><00:02:41.920><c> charge</c><00:02:42.160><c> an</c><00:02:42.400><c> extra</c><00:02:42.550><c> five</c><00:02:43.060><c> dollars</c>

00:02:43.080 --> 00:02:43.090 align:start position:0%
going to charge an extra five dollars
 

00:02:43.090 --> 00:02:45.270 align:start position:0%
going to charge an extra five dollars
because<00:02:44.080><c> this</c><00:02:44.290><c> person</c><00:02:44.710><c> did</c><00:02:44.860><c> not</c><00:02:45.070><c> have</c><00:02:45.250><c> a</c>

00:02:45.270 --> 00:02:45.280 align:start position:0%
because this person did not have a
 

00:02:45.280 --> 00:02:47.970 align:start position:0%
because this person did not have a
scheduled<00:02:45.730><c> appointment</c><00:02:45.790><c> if</c><00:02:46.590><c> we</c><00:02:47.590><c> scroll</c><00:02:47.920><c> down</c>

00:02:47.970 --> 00:02:47.980 align:start position:0%
scheduled appointment if we scroll down
 

00:02:47.980 --> 00:02:51.199 align:start position:0%
scheduled appointment if we scroll down
and<00:02:48.640><c> enter</c><00:02:48.760><c> the</c><00:02:49.060><c> amounts</c><00:02:49.570><c> charged</c><00:02:50.020><c> per</c><00:02:50.320><c> visit</c>

00:02:51.199 --> 00:02:51.209 align:start position:0%
and enter the amounts charged per visit
 

00:02:51.209 --> 00:02:54.240 align:start position:0%
and enter the amounts charged per visit
Excel<00:02:52.209><c> add</c><00:02:52.570><c> the</c><00:02:52.750><c> extra</c><00:02:53.230><c> charges</c><00:02:53.590><c> from</c><00:02:53.920><c> above</c>

00:02:54.240 --> 00:02:54.250 align:start position:0%
Excel add the extra charges from above
 

00:02:54.250 --> 00:02:58.410 align:start position:0%
Excel add the extra charges from above
and<00:02:54.700><c> give</c><00:02:55.420><c> us</c><00:02:55.570><c> the</c><00:02:55.690><c> balance</c><00:02:55.900><c> due</c><00:02:56.350><c> if</c><00:02:57.420><c> you're</c>

00:02:58.410 --> 00:02:58.420 align:start position:0%
and give us the balance due if you're
 

00:02:58.420 --> 00:03:00.510 align:start position:0%
and give us the balance due if you're
ever<00:02:58.630><c> curious</c><00:02:59.110><c> about</c><00:02:59.590><c> which</c><00:02:59.890><c> cells</c><00:03:00.220><c> have</c>

00:03:00.510 --> 00:03:00.520 align:start position:0%
ever curious about which cells have
 

00:03:00.520 --> 00:03:02.730 align:start position:0%
ever curious about which cells have
formulas<00:03:01.090><c> you</c><00:03:01.630><c> can</c><00:03:01.660><c> always</c><00:03:02.230><c> click</c><00:03:02.470><c> on</c><00:03:02.530><c> the</c>

00:03:02.730 --> 00:03:02.740 align:start position:0%
formulas you can always click on the
 

00:03:02.740 --> 00:03:05.610 align:start position:0%
formulas you can always click on the
formulas<00:03:03.250><c> tab</c><00:03:03.520><c> and</c><00:03:03.940><c> then</c><00:03:04.810><c> click</c><00:03:05.110><c> on</c><00:03:05.140><c> show</c>

00:03:05.610 --> 00:03:05.620 align:start position:0%
formulas tab and then click on show
 

00:03:05.620 --> 00:03:08.790 align:start position:0%
formulas tab and then click on show
formulas<00:03:06.959><c> Excel</c><00:03:07.959><c> will</c><00:03:08.140><c> show</c><00:03:08.350><c> you</c><00:03:08.410><c> where</c><00:03:08.770><c> all</c>

00:03:08.790 --> 00:03:08.800 align:start position:0%
formulas Excel will show you where all
 

00:03:08.800 --> 00:03:11.640 align:start position:0%
formulas Excel will show you where all
the<00:03:09.010><c> formulas</c><00:03:09.640><c> are</c><00:03:09.790><c> located</c><00:03:10.360><c> and</c><00:03:10.590><c> show</c><00:03:11.590><c> you</c>

00:03:11.640 --> 00:03:11.650 align:start position:0%
the formulas are located and show you
 

00:03:11.650 --> 00:03:16.140 align:start position:0%
the formulas are located and show you
how<00:03:11.950><c> the</c><00:03:12.010><c> information</c><00:03:12.459><c> was</c><00:03:12.850><c> calculated</c><00:03:15.150><c> to</c>

00:03:16.140 --> 00:03:16.150 align:start position:0%
how the information was calculated to
 

00:03:16.150 --> 00:03:18.870 align:start position:0%
how the information was calculated to
turn<00:03:16.360><c> this</c><00:03:16.570><c> feature</c><00:03:16.630><c> off</c><00:03:17.130><c> just</c><00:03:18.130><c> click</c><00:03:18.400><c> show</c>

00:03:18.870 --> 00:03:18.880 align:start position:0%
turn this feature off just click show
 

00:03:18.880 --> 00:03:23.520 align:start position:0%
turn this feature off just click show
formulas<00:03:19.510><c> again</c><00:03:19.840><c> and</c><00:03:21.390><c> just</c><00:03:22.390><c> minutes</c><00:03:22.750><c> you</c><00:03:23.350><c> can</c>

00:03:23.520 --> 00:03:23.530 align:start position:0%
formulas again and just minutes you can
 

00:03:23.530 --> 00:03:25.979 align:start position:0%
formulas again and just minutes you can
prepare<00:03:23.920><c> an</c><00:03:24.100><c> invoice</c><00:03:24.430><c> for</c><00:03:24.700><c> your</c><00:03:24.730><c> business</c><00:03:25.239><c> go</c>

00:03:25.979 --> 00:03:25.989 align:start position:0%
prepare an invoice for your business go
 

00:03:25.989 --> 00:03:27.509 align:start position:0%
prepare an invoice for your business go
ahead<00:03:26.320><c> and</c><00:03:26.470><c> start</c><00:03:26.650><c> customizing</c><00:03:26.920><c> your</c>

00:03:27.509 --> 00:03:27.519 align:start position:0%
ahead and start customizing your
 

00:03:27.519 --> 00:03:30.360 align:start position:0%
ahead and start customizing your
template<00:03:27.940><c> today</c><00:03:28.269><c> by</c><00:03:28.840><c> changing</c><00:03:29.320><c> the</c><00:03:29.410><c> text</c><00:03:29.860><c> font</c>

00:03:30.360 --> 00:03:30.370 align:start position:0%
template today by changing the text font
 

00:03:30.370 --> 00:03:34.170 align:start position:0%
template today by changing the text font
fill<00:03:31.000><c> color</c><00:03:31.269><c> and</c><00:03:31.510><c> images</c>