How to Make a Business Account Ledger in Excel : Advanced Microsoft Excel

Subscribe Now:
http://www.youtube.com/subscription_center?add_user=Ehowtech

Watch More:
http://www.youtube.com/Ehowtech

Making a business account ledger in Excel is a great way to keep track of your finances. Make a business account ledger in Excel with help from a mechanical engineer in this free video clip.

Expert: Edward Russell
Filmmaker: Patrick Russell

Series Description: Microsoft Excel isn't just for creating basic tables - it can also be a great way to graph information or even perform advanced calculations and analysis. Get tips on advanced Microsoft Excel topics with help from a mechanical engineer in this free video series.

---

Closed Caption:

hi I'm Ted
today I'm going to show you how to make
a very simple business account ledger in
Excel
I have something set up already on my
screen here and it's just several
fictional transactions and i have a
table with the data date of the
transaction the transaction the category
the type meaning expense or income and
then the amount where if it's an expense
it's a negative number if it's a
incumbent so it's a positive number so
the kinds of things you can do with this
is you can if you by entering in the the
category you can actually sort by
category and this is something that's
very good to know
in fact it's important to know if you
use excel at all is the ability to do
this kind of thing so but first let me
just show you how you can you can use
this to add up your balance as your as
you as you move along
what it is going to be in the balance
here
just scroll in a little it's going to be
a formula and it's just going to be
equal the sum of all the numbers from
the first number to whichever number
you're at so the first one is just
simply itself
so you and you can have a range of the
formula it goes from e - I - E - that
just means i'm adding all the numbers
from this number to itself but we're
going to do before we hit enter and and
actually enter in the formula the the
first be the start of this range here on
that on the E - we're going to put a
dollar sign before the 2 and what that
means is that's that's telling excel
that when we copy this formula it's
somewhere else somewhere else
we don't want to change that to the two
remains fixed and you'll see why that's
important in just a second
so I'm going to return and and there's
there's the balance
just scroll back out so there's the
balance and what you can do is you can
take this formula and you can copy it so
will copy it and then we'll go to the
next cell and we'll paste it i'm just
doing right click copy and and then
whoops
right click and then paste say like
be the blank here I copy that and then I
come down to this cell and i right click
and I paste
ok and then I come down here and i right
click on a paste
now we're going to be right clicking and
pasting a lot here let me show you a
little shortcut if you're at a formula
I mean I'm sorry if you're at a cell and
you want to copy the cell all the way
down to roll numbers
just click the cell and then move your
cursor until you see a plus sign like
that and then just hold your mouse down
and click and drag it down and that will
i'm just making this the column a little
bigger
that will copy the formula all the way
down to the bottom so i hope this has
been helpful
i'm ted and today i showed you how to
set up a ledger using Excel
thank you for watching