WEBVTT
Kind: captions
Language: en

00:00:06.800 --> 00:00:12.240
Suppose you need to create a Microsoft Office
Excel workbook by this afternoon but you don't

00:00:12.240 --> 00:00:18.770
know how or you know how but don't have time.
You can simply solve the problem by using

00:00:18.770 --> 00:00:25.660
one of Excel's dynamic and easy to use templates!
Use the templates in their original format

00:00:25.660 --> 00:00:31.460
or customize it to fit your needs.
Let's take a look at these templates.

00:00:31.460 --> 00:00:36.370
To access the templates click on the MS Office
button.

00:00:36.370 --> 00:00:41.500
Click New and the New Workbook dialog box
appears.

00:00:41.500 --> 00:00:48.500
You now have the option of choosing a template
from your computer or MS Office Online which

00:00:49.100 --> 00:00:54.120
requires an internet connection.
We can make a selection from many different

00:00:54.120 --> 00:01:14.830
options such as Budgets, Invoices, Receipts,
and Schedules just to name a few.

00:01:14.830 --> 00:01:21.830
Let's take a look at Invoice template online.

00:01:23.360 --> 00:01:28.720
Pet Sitting! Summertime is almost here and
I know a lot of kids make extra money pet

00:01:28.720 --> 00:01:32.380
sitting.
When you find a spreadsheet that you like,

00:01:32.380 --> 00:01:37.380
left-click it to select it and then click
Download.

00:01:37.380 --> 00:01:43.250
When the spreadsheet opens, you'll notice
these brackets with pre-filled text.

00:01:43.250 --> 00:01:48.530
This is called placeholder text.
If we click on the text, it will appear in

00:01:48.530 --> 00:01:52.540
the formula bar.
We can change the text here in the formula

00:01:52.540 --> 00:01:59.540
bar or just start typing in the spreadsheet.
Speaking of formulas, the biggest reason templates

00:02:00.950 --> 00:02:06.770
are so amazing is because they come formatted
with embedded formulas! All you have to do

00:02:06.770 --> 00:02:12.860
is fill in your information and Excel will
do the rest! Let's fill out this invoice so

00:02:12.860 --> 00:02:22.650
you can see what I'm talking about.
I'm going to enter the date, the services

00:02:22.650 --> 00:02:34.030
provided on that date, the time I started
working, and the time I stopped working.

00:02:35.030 --> 00:02:44.140
See, Excel calculated my total time worked!
Now, I'm going to charge an extra $5.00 because

00:02:44.140 --> 00:02:50.060
this person did not have a scheduled appointment.
If we scroll down and enter the amount charged

00:02:50.060 --> 00:02:57.060
per visit, Excel will add the extra charges
from above and give us the Balance due.

00:02:58.120 --> 00:03:03.250
If you're ever curious about which cells have
formulas you can always click on the Formulas

00:03:03.250 --> 00:03:09.650
tab, and then click on Show Formulas.
Excel will show you where all of the formulas

00:03:09.650 --> 00:03:16.120
are located and show you how the information
was calculated.

00:03:16.120 --> 00:03:20.830
To turn this feature off, just click Show
Formulas again.

00:03:20.830 --> 00:03:25.980
In just minutes you can prepare an invoice
for your business.

00:03:25.980 --> 00:03:31.480
Go ahead and start customizing your template
today by changing the text, font, fill color,

00:03:31.480 --> 00:03:32.280
and images!