Excel Accounting Schedule of Expected Cash Collections Using A Set Of Assumptions / Formula Inputs

Geoff Turck's Accounting 203 Class Excel Project
Download workbook (at bottom in Other section): http://people.highline.edu/mgirvin/excelisfun.htm

Why Accountant's Must Know Excel: Illustration of the Power Of Excel's Golden Rule

What you will learn in this video:
1. Create a Schedule of Expected Cash Collections using a set of assumptions or formula inputs.
2. Build an assumption area or formula input area in the spreadsheet so that easy What If Analysis can be performed.
3. Learn about formulas and formula inputs.
4. Learn about relative and absolute cell references.
5. Use the F4 key to lock your cell references (make absolute).
6. Format Accounting Report with Borders, Center Report Title with Center Across Selection, Increment Text Months with Fill Handle.
7. Check your calculation to see if they are accurate.
8. Page Setup.
9. Copy sheet.
10. Change assumptions.

---

Closed Caption:

welcome it just turks accounting two or
three class XL project
if you want to download this work we can
follow along click on the link below the
video
if you click on the link to all the way
to the bottom in the
other section and you can look for this
file name: now what are you doing this
video
well we're gonna look at a accounting
problem from
in accounting on class we're gonna build
a schedule Ave expected CAS collections
and this kids wall is a budget that will
be based on some assumptions
so we want to talk about excels golden
rule
because our schedule down here will be
based on formulas were making
calculations
the golden rule is this if dow to inform
us
can change and what i mean my dad is
like your percentage of how much you
collective on account of through cash or
here soon budgeted number I've can
I've seals for July thats data
informants
solved at informers can change put it
into a cell in refer to it in the
formula with a cell reference
all right now here's our problem not
gonna read the whole thing but I'll give
you the details were going to do a
budget
on and for the months May to September
here are
are budgeted sales we will assume
that when we have sales in a particular
month
10 percent will be CAS ninety percent
will be on account I love those
on accounts sales 20 percent will be
collected in the month at the sale
seventy percent in the month following
in 10 percent two months
out now our homework here are
this project we're gonna creep a
schedule expected CAS collections
EN calculate the accounts receivable
balance at the into the period
then the third star problem we're gonna
do
is we're gonna reduce step 1: into you
with different assumptions now if you
were doing this by hand
it would be terrible you have to redo
step
what the schedule and step one in
recalculation for
the accounts receivable budget but if
you do next cell
and set things up smartly its
as simple as changing if you for your
inputs and
everything ok update alright first thing
is we want to take our numbers
our sales are percentages and put them
into what's called an assumption area or
a formula input area
and then we'll build our formulas now
when you're
building an assumption Erie you always
want to label thing smartly so
here I did percentage of sales that our
cash in account
I went ahead and labeled it so I know
what this ten percent
this ninety percent means percentage of
accounts receivable collected in the
month
one month after into month after again
he ideas
label everything smartly so up here
I'm gonna put the months in the budgeted
sales I'm gonna put a smart label
months now here's a great trick
now II just type that in hit tab I know
a lot of people in their learning
the types of men hit enter and then
bring the cursor over here in click
forget it if you're entering data to the
right use the Tab key
now I'm gonna type for months me and I'm
not going to use
enter or tab Company's control in turn
the reason why is I wanna put this thing
in the cell
and keep the cell selected so control
enter notice
put main and the cell still selected now
I medially wanna do something to that
sell
there's a great feature in Excel that
little box in the lower right hand
corner is called the fill handle
this is the selection cursor if you move
your selection cursor
towards that fill handle it turns
to across here or in angry rabbit you
can click can drag
and writing to the right animal
automatically in crewmen
months for you now we wanna interm a
label for
are budgeted sales and I mean hit tab
I'm gonna type
430,000 540,000
6-under Inc 900,000
and family 500,000 for September by the
way we're making the schedule for
July August and September but because we
have a Kansas evil we also need
information from the earlier months
alright so always put your formula
inputs
and label them smartly now I'm actually
gonna show is little trickier
if we're given a situation where it says
there's two categories like this in 10
percent of the sales will be
cash well the other percentage
love their on account collections
guess what we don't have to take this
into a so we don't wanna take
I'm 90 percent like that we will put a
formula here
and the reason why is if we change or
something to 15 percent
I want this number two automatically
update
controls it now I usually for my own
convenience and for teaching
distinguish between half for me like
input mean I'm typing that number in
Anna
cell with a formula I always put a green
in my assumptions area II always do that
so when I come back and use this later
I know KB cells are all things and
typing into the cells
this is not the salon medical calculate
now forced
reports I you know you know oftentimes
you can have that color but
up here all illustrate that hey this is
easy equals
well as 10 percent are
are cast the remaining amount ninety
percent is on Capp
well I could go a hundred percent but
remember the percentages are actually
of form added numbers so instead of a
hundred percent I'm just put in long cuz
that's the number
%ah that is represented by 100 percent
sexy
one minus 10 percent now wait a second I
did that fastens was to say something
about formulas
if I taping equal sign that tells Excel
hey I'm about to do for me
now I can type the number one in the
cell
and then minus and I need to get that
10 percent from Selby night thirst two
ways I can do this
I can either click with my selection
cursor in the DNC nance will dance right
around the cell
you can see the bean I'm is putting you
could also go home
equals one minus and since the cell
references close your navigation
a row keys if you look wherever they are
on your keyboard
if I hear the are left because I mean
edit mode and I'm making a formula it
will automatically
hunt with the arrow keys for your cell
references now if you go too far the
riot wrong direction
as long as the Danes in answer still
dancing just keep going to get to the
right place and then hit
enter I and so the beauty of that is if
I type this
you nasa 15 percent now I already pre
format it is but I gotta say some over
here about percentages
in fact our I will our do a little
trickery here in
and I so you the
%ah teaches some about percentages down
here if I come over here
in for this this is how much of the
on account sales were gonna collect in
the month with the sale
one month after in two months after now
the number one mistake that people make
with Excel is with percentages and
number format
so let's say I wanted this to be twenty
if you type a twenty into a cell
and come up to the home and now I have
my home ribbons turned off so I can
have a bigger screen here you can
right click and on collapse there's a
few other ways there's
this little item over here that will
collapse and there's also a key Porter
could control
after one is that hog all control f1
right so that I come up to the number
group in Eq come to the drop down and I
see a percentage you can already see
trouble here
notice down here I type 2 20 when I
apply a percentage format
it properly slide the decimal two places
and adds that percentage symbol
cell I'm million arm
delete that but I want to be known as
something to leaving only removes the
content it doesn't remove
the I'm number formatting if you have a
number for men it's bothering you
applying the general number format will
wipe away all the number for me
so you don't want to type a twenty if
you type in a number in first you wanna
take
plea to you now you could put type 0.2
but you could see that it put it in
there for us
so it's an unnecessary keystroke now
point to you that means 20 divided by
100 that's the fraction or the decimal
number that %ah can be expressed as a
percentage by applying
percentage number format now there's one
other way could do this
notice I can see that this is general
number for men appear
since I know that this number needs to
be seventy percent
you can actually format as you type so I
could take 70.00
now right now if I hit inter control
enter tap
it put the number 7 a.m. but as soon as
I type a percentage symbol that's
you telling you XL please
apply percentage number for many now the
cool thing control into about ideas is
guess what
I see a seventy percent up here and a
seventy percent here
the number that you put in even though
you put the percentage symbol on it
looks like this
the imager seventy number they got put
into the cell is actually what
points7 so if I come up here in applying
the general number format you can see
that's what's there and that
number .7 house to be in the cell
because Excel
bases all its calculation on a number
less than one in this case
I nominate use on do you there's also a
keyboard shortcut
Keyport circuits if you hover your
cursor over many of the features
they will tell you what the keyboard
shortcut is and so in this case
control Z since undue is our best friend
I like that keyboard controls the
I now this one right here this is
10 percent now this one could be a
formula or not
and the reason why is we might change
anyone is I'm assume that I'm gonna
change these two in the remaining
percentage for two months after all be
the one that will be the default that
just as the plug number
some to build a formerly equals in my
equals 1 minus now I need to do minus
this and then minus that but another way
to go
is to type this song function
the sum function allows you to simply
highlight ball for those cells
in closing of now what is
one minus seventy percent
minus 20 percent its gonna give us 10
percent so just like that
boom and again the idea is if I change
this
hey wait a second check that out if I
want to change this
notice it's already and I can see appear
percentage number for men
if I just type it ten it automatically
has a percentage symbol becomes
its pre format if I preform out that
I'm I just typed the 10 and control
enter
not instantly updates nominal control C
so we have our numbers are going to
change this to our
10 percent also all right now it's come
down to our schedule
I'm gonna close this either right click
collapse
can't believe there's do usually is
something over here I don't know why
it's
always right here book
so there is someone but I mean he is a
keeper control of one which is the taco
all right now I I've already pre type
some stuff here you have to type this
actually do I want to show you yes
pretend like you didn't see this okay
I'm
I'm gonna see if you formatting things
because these are important
I tape roll this out but its a credit
sales
and some months I actually want to
highlight although these labels here
an indent them saying come up and by the
way
this ribbon if you click on it you can
do stuff and then we'll on collapse a
minute
indent says increase Indian and I'm
gonna come over to
May and through September nominee
indented one
steps further
I need to label up here and
we might I need I'm gonna put scheduled
expected CAS collections
you might ads i'd dates or other items
here but I'm gonna add just one line
will it take
I'm in a min hit enter now I wanted
centered across this summer to highlight
all love the cells were here now there
is emergency center button a lot if you
use that
love you up might also know that there's
problems with that
so also you an alternative it's fine to
use merge in center but an alternative
is
well we have to go to the Format Cells
dialog box now
there's a dialogue launcher at the
bottom each one of these groups these
are not know home living here
the open up the format cells to that
particular tap
but the keyboard shortcut to open up
Format Cells
is control one
I'm gonna go to the alignment and the
alternative
is center across selection else ever
cross election
will not merge the cells but it will
look exactly the same I'm gonna click OK
all right now another thing we need down
here is the total we really need to do
some borders
I'm in a highlight although cells and
you could go up in theirs in the home
ribbon there some borders
but not all of the options that you
might want are here
so many clichés keep the ski companies
that same keyboard control one
I'm gonna go to border now you can pick
any line and then dry
you can actually use these to draw
anyone in the lines there simpleton once
up here some presets
I'm on the Select this up really thick
one
and click now wait a second what's how's
that gonna
well notice we have and outside all the
way around
and then we looks like we have some
vertical lines so anything that we were
to click around the outside edge here
will do just the outside it so when I
click right there it puts a only on the
top
now I want no lines in the middle so not
conclude there but i wanna double line
on the bottom so
come over here and then click on the
bottom now looks like
I'm in need a line here
and it looks like which one of those
little thin line so many click their
group a new nominee click there's one
over here that's kinda invisible I'm in
a click over there I just don't want to
click in the middle cuz I don't want
all these ones this is actually a great
trick for
many accounting templates have you know
complicated
border patterns and really this is the
track
inside does all the incitement outside
its only
outside click OK and there we have it
now that would think border extra thick
their looks kinda funny some
highlighting control one
and use not the super thick one but that
little
than one and I'm editing right over a
click OK
all right there again now we're gonna
need July
August September and I already have that
information over here
and especially since this may change I
may come here and
retype these are later so I'm gonna
build
a formula that simply gets a label in a
click and
equal sign in click on July now we have
to talk about
two different kinds a cell references
and there's actually a buncha kinda cell
references
but the main to you that you need to
know they're called relative cell
references and
absolute now relative cell reference
means
if I mean a formula I'm always gonna
look 1,2,3,4,5,6,7 89
10 above me into to my right
so watches control enter and I'm gonna
copy this
and then I'm just gonna look at it real
quick comment click in that sell enough
to well
its relative cell reference that means
to
relative to me the formal wear my was
gonna look
10 up and to to my right
so when I copy this over I look at it
it's a relative cell reference
notice over here its d5 here its
easy five in here it's after five
it some as if it's a movin over as i
copy my phone in fact it is a cell
reference
is moving over 10 up to my right
alright so we have that we have quarter
we have our labels now
cash sales here we're going to have to
do a formula
a calculating for me like we did appear
for a number
answer but we're gonna have to learn
about relative an absolute cell
references
so for cash sales for July I'm gonna
click on that 600,000 now let's check
this out control enter
if I were to copy this over you can see
that
is a relative cell reference right but
that's not what we want ten percent us
now here's what you don't want to you
don't want to have to type
10 percent and then come over here and
do times 10 percent now notice in this
case
each one these formulas needs to look it
be now online
so I wanna avoid having to any each one
notice each 1/2 uses B-nine
nominal control ZZZ
if that's the case mean when you're
hopping year for me a lot you need to
lock down on a particular cell reference
so when you copy it doesn't move use an
absolute cell references times
B-nine now right now it's a relative
sour things but hit
the after four key it puts the secret
code in
dollar signs the dollar sign in front of
the be the column reference
and the dollar sign in front of their
number there
the role reference the number means it
will not move relatively as we copy
control enter and copy it over
I'm gonna click in the last cell and hit
f2 cuz I wanna prove to myself that my
formal still working and look at that
September times 10 percent
now what does that do you that saves an
immense amount of time when you're
building
our budgets like this cuz you don't have
to take each individual former just one
formula and copy it over
all right now we do have to consider
credit sales
and when we collect them so many well we
have
made june july this is july so we will
take our many sales
I love those sales ninety percent or on
account some news the multiplication
symbol
Astrix that would give us the
up all love the own account
amount but way to San we've already
collected two months previously
so we take that amount and multiplier by
the percentage we collect two months
after the sale
and that will be our are now now this is
in July so we're done with may now we
need to move on to
June now June sales we could see their
up here we still we've already in the
last schedule a vote
to expect to Cascal exit account for
what we collect into mostar do
July and on gets so when starter formula
what we collected in july an Argus was
started in
be. 19 equal also we really click on
Arjun
now I'm gonna copy this over knee locked
down on June so hit the f4 key
times all on account so that's ninety
percent
that also has to be locked after four
times this is the month after the sale
so I click on my seventy percent
knots relative solomon's so when I copy
over here
it'll move to the two months after
percentage self control under
and I copy over I'm clicking in the last
cell in hearing the
after to keep my way I learned f2 key to
put it into and moved from
gf turks so many years ago
start eating in Highland ECCA you gotta
learn keyboard shortcuts
I would love that have to us a call at
the jet turkey
so there we have that's looking good we
have our two locked cell references
and boom the seventy move to 10
all right now let's do July I wanna see
eat cools
there's our July sales lock it down with
f4 key
times on account
that means right they're gonna let me
hit F-four that means right there
600,000 tonnes ninety percent that's the
dollar amount for
everything on account but now we need to
chop it into three pieces right
July August September July is this month
so that's the twenty-percent
books ninety percent
after four times about the times
and we will do are relative cell
reference
I already control enter and copy it all
the way over to September on clicking in
the last cell in him that
gf turkey f2 and boom there it is
the full amount for on account for July
sixteen thousand times ninety percent
times a ten-percent that's the amount
we're going to collect in September
working perfectly now in August we have
to start in August
equals August after four times
ninety percent after four times
this is the twenty percent this is in
the month were collecting
that's a relative these two are absolute
control enter
and copy it over McClurkin
not sell in here the af to key
I finally have September we don't need
to worry about cell references cuz we're
not copy in this
just this one month $500k times on
account times the month for
week I'll
per month the month with the sale 20
percent
alright so now we've made all of our
calculation we need to ask for each one
of them months the tolls and then for
the corner
now many come down here in a Musa some
function equals
s %um now great thing in 2007 or later
anytime your function that you want from
you drop down overseas are all the
passes
his in blue I can simply hit tap now I'm
in a highlight with my Dean seen ends
there
relative cell references those are
pleased on all the ones
above me control enter and then copy it
over
come over here he cools actually let me
show you a great trip here if you have a
bunch numbers right directly
next to where you want your formula or
above you can come home and there's the
some
button that's what most people do but
Shekau if you hover over the some bomb
it tells you what the keyboard is alt
equals now all to equals there are over
400 functions and some function is the
only one that has a keyboard so let me
try alt
equals and just like that you gotta be
careful when you use alt equals
or the some button more the functions
dialog box
make sure that the Dean scene answer
Warren around the correct numbers cuz
sometimes it doesn't get it right
hear it does its please add up to 32 my
lap control
enter in a minute copy it down now I'm
gonna
are check this out just to test it now I
have my
scheduled expected cash collections how
mood change this number here
220 preform in it so that person it
shows up in before you enter this is
gonna change
and everything in the schedule change
boom
absolutely beautiful control Z
now arnelle's next task
is to get don't calculate
the amount that we should I have an AR
on september thirtieth
still to be collected some in August in
some
in September now I'm gonna just do some
basic subtraction here I know
in our guest
I need to see this number appear there's
my total from
August right there bought I've already
clicked in ninety
in cash sales in from right here
729 in AR sale so I'm gonna
just two simple subtraction take the
toll on
up before August civil the budgeted
sales minus the cast cells have already
collected minus
the total AR we've already collected
assume the clock in Boone so we have
81,000
I can be the same thing for September
there is the Sept
total minus the cash amount -7 there's
only one
ninety thousand the ten-percent
love over 20 percent in the month to the
sale of AR so there we go we can do the
street calculations
and so the balance obvi I'm out there
alt equals enter and that will give us
are budget-balancing accounts receivable
balance on September 30th
I to allow out would be to big number
there it's a sleep 2013
do you know when I'm doing calculations
like this I like to
double check enormous cool down here
and think in some different ways to kind
of calculate Tom
these two maybe a few other numbers just
to see if I'm
on track so maybe I am
PR and Augustine ER and September
see if we get the same numbers here
up here we subtracted
well we can do this calculation a
different way by doing our
multiplication cuz it they are with our
ninety percent in whatever
a percentage is here so I'm gonna come
down here in four
August lunacy equals
well for August we've already collected
to bits and we still have those ten
percent we haven't someone to come up
and get
August that saw love the budgeted sales
times the ninety percent we
cell on a countdown to give us the whole
amount we just need
to multiply that times 10 percent I and
so we gotta get
81 now September little bit trickier
forming I'm gonna try and do it all in
one
cell you could certainly do it into
cells because what
there's to we've only collected that 20
percent above the 90 percent for a are
we still have the seventy
and Nana 10 percent
me to go ahead and see equals
September that's the whole amount times
this ninety percent
now notice I I had to scroll up there's
a formula
well amusements cold war over here
we still have the seventy and the 10
we're now we could do this if you
examine it just go like this
now any that's just the amount for one
month after plus
I'm gonna copy something see a min ago
like this
and then dominated multiply it times the
10 now
that little be right there is going to
give us what we calculate
two months out and that little bit will
give us what we
aka lacked sorry collect two months out
collect one month after the sale
there's still another way we could do
that to you
IQ
get the $500k times than 90 percent
you know we can and those together and
just do one
so he used the sum function and then and
these two
cuz I have the full amount right here
knots the full amount and it's gonna be
one piece is seventy percent and the
other pieces 10 percent
so I can simply add the percentage to be
alone again I'll get eighty percent
so there's a buncha ways we could do
that now let's go ahead and all two
equals
and so it looks like we're on track
their now
what about 4 July August and September
you know I'm
I wanna see if I can calculate from all
my calculate numbers and get the totals
for each one and he's
here what's this I'm going to do a trick
your cuz I would like to see what's
happening down here
and up here I'm going to
select the row header 7 click and drag
all the way to 13 the nominal right
click hi
notice there's a nun I do something to
hide
alright so here we go 4 July
I said my target number six hundred
thousand alright ready
peak walls well July cast sales
plus all love the July AR
and that would be it right 600,000
absolutely
on target how about for August well in
August we collected nine the
thousand in cast plus oh yeah
this AR plus the amount we just
calculated
for leftover in AR after I this
period here okay 900,000 so there we go
again the idea is if I'm in charge to
the spreadsheet on checking I did all
those calculations and I was careful
when I'm
doing it a different way to make sir I
haven't September I could say hey 500 K
plus
well we collect a little bit a cast a
little bit AR here and then there's a
buncha AR leftover
so those are all the pieces who not
right what did I do wrong there
right there
so the area one so those the pieces
there
so the cash they are collected during
the schedule on the
we are left over after the schedule so
500,000
alright we need to go up in on the hyde
so many click on the row header six in
drag all the way to 14
and then right-click on high
alright we still have two things left to
do we want to do some Page Setup
because right now who printed this it
would print across all all the stuff we
don't want and then we're gonna change
copy the sheet over and change the
assumptions
now which is going to take a look at
what happens when we use
control PE for print you can also go to
file- print for control P is a lot
different in
Excel 2010 in Excel 2013 which I'm using
the force you to look at print preview
which of course is awesome cuz what are
we all doing all days
click praying that would preclude
crossed page is not what we wanted then
we have to come back and do
paid set up so this is nice a nice
improvement
it forces you to look at Print Preview
I'm in a click
escape first thing we want to do is set
the print area we have a bunch of
calculations down here and all this
other stuff we don't wanna print out
with a report
and I actually am going to include my
assumption Simona
highlight just the assumptions the
schedule
and the budget balance sheet calculation
here
and go up to page layout and set print
area
back only that area will print out the
rest to the stuff it will not let's
control P
I'll very nice blog we still have to do
P
Cena the September is kind of the
Anjuman a click its key
page set up we go to page layout now
there's a buncha buttons that would help
us to page set up in every time it opens
a dialog box I like to go straight
to the dialogue bunch the dialog box
Page Setup group this is called dialogue
launch right click
and there we have our page setup now I'm
gonna select landscape this is
you if it is wider than it stalled the
news the landscape looks better
this is almost exact is actually the
same dimension both ways but I'm a
select landscape
come over to margins usually it looks
good to select wars on a vertical looks
funny especially if the report is small
header and footer now one think we're
going to do is we're gonna have one
sheet and then a second sheet with the
second set of assumptions
so watch this there's food custom footer
in custom header
this is the preview appear for hello
this is the preview for further but
there's some built-in lines
in one great built-in header or footer
in this case a footer is
page 1 of question marks that means
it'll say one
I love to to have 21 we have two pages
now the custom header footer built-in
filters
there's the preview of the footer custom
header on seeing appear on a bill this
from scratch now one thing nice about
this custom for a dialog boxes
we can type whatever we wanna Pierre
so I could type accounting homework and
then your name
you could type something in the middle
or in the right section
and there's a bunch a great buttons
that's I actual page number total page
numbers Date Time
workbook name in even she tab name
so I'm gonna put sheet tab name here cuz
I'm gonna changes well
this says schedule love expected not
cast collections
set 1 when we copy issued overall says
said it to set to you and this what
update perfectly I'm click OK
one more tab here I'm gonna click see
we don't really need anything here but
notice that's where the print area
got set I'm gonna click OK now let's do
control P
and there's our preview you know I'm
kinda looking here are like this preview
I see there have some extra room on each
sign in below some increase the
percentage
actually control P this Page Setup
I link old jobless right to that dialog
box
I'm is gonna try a 120
click OK perhaps I was his gas in there
but look
I see page 101 this is looking great
alright I'm gonna click escape its set
there when we present from now on it
will
print now the next thing is to copy the
sheet over
in Chains the assumptions I'm gonna go
ahead and
I'll change the name up the she
scared to love expected CAS collection
set
and I'm gonna actually highlight this in
here's a cool trick if you put a number
in parentheses anytime you copy the
sheep the number one increment
I'm gonna change that sheet tab name
which is the
name of this work see hit enter
and now I want to copy this right click
move or copy now
the last year before which she I want it
to move to
end and look at this by default if I
clicked OK would move in would do
nothing cuz there's no
other seater be sure to check create a
copy
another great way to do that and this is
kinda hard but check this out you hold
control
key and with the control key selected
I'm in a click on the sheet with my
mouse and drag up
notice that piece of paper and the plus
symbol
notice that black triangle pointing down
that black triangle
is pointing to where it will drop now
the trick is you have to let go of your
mouse button not
controls on letting go of the mouse that
is much faster for copying and that's a
good way
now we can have three sets and we will
print the thing out it'll say page 1 of
2
1-3 2-3 3-3 and the sheet tab names will
show up
when we print all right now let's go to
set to
the homework says our 15 eighty-five
percent to check this out for Cass
collections were gonna assume we get
15 percent and just like that the 85
updates
so does everything here that's why we
gotta know how to do Excel why
accountants must know Excel
and illustrates the power excels golden
rule right
everything down here was partially based
on that fifteen percent so when we
changed it
in all updated alright then
the other something was 30 percent
own account and 65 percent in the second
month long gonna do 30
tab in 65 knows the preform an incise
take 65
absolutely beautiful now I'm gonna come
over here the homework didn't say it but
I minutest
mess around here I'm a seat twelve
percent
this one's actually fifteen percent and
50 percent
so we have our sets of assumptions now
let's
control P and I'm gonna come
and say please select entire workbook
and now look at this page one of three I
can see my page 1 of 3 their
up here at house my om see tab name when
I click Forward
page 2 of 3 there's my I see tab name
ex-senator alright I'm not going to
click Print on the click escape one
other
thing if you wanted just print set 1&2
you click on the sheet and then hold
SHIFT
in click on this sheet now when you
control P
the default is I'll prints
active work seats that's what comes up
there and so now you can see it's proof
while
one of two you could also say the pages
here
now one thing that status I'm gonna cook
a ski these are
simultaneously selected and if I start
doing
anything it does it to both seats so be
sure to right-click
on group worth there's another she click
on it nobody select them
alright that was a lot about
the power and beauty of Excel and
illustration of
excels golden rule which means anytime
your house formula inputs that can
change including something
you know like this ninety percent that
doesn't seem like it will change
don't type in the cell I you know create
a formula based on formula inputs
alright we'll see next video