I'm gonna show you how to create a basic flow chart with your Excel to create a
flow chart first what we're gonna do is we're gonna go to the view on the menu
bar here and we're gonna take off the grid lines and then we're gonna go to
the insert the insert tab on the insert where the pictures online pictures and
then what we have is we have shapes up here so we're gonna drop that down and
work then you go down fairly far down on the on the screen here and you have
flowchart symbols so let's choose the first one and that's going to be our
start so then what we're gonna do is we're gonna place it on our on our flow
sheet and then to put our grout our our text in there what we're gonna do is
we're gonna go right click and we're gonna choose edit text and we're gonna
go start alright and then what we're gonna do is you're gonna go back to your
home tab and you're gonna Center that you're gonna select the cell and then
you're gonna Center it so there you go so our little process the next thing
under our process was we're gonna have a step whatever the step is so we need to
have a square here so what we're gonna do is we're going to go back to the
insert we're gonna go to our our flow charts and we're going to get a square
and what we're going to do is we're going to draw a square here to another
one so let's let's make it green okay and then this what we're gonna do is
we're going to edit the text here and we're going to call it step 1
what we're going to do is we're going to select it we're gonna go to the Home tab
and we're going to Center it and center it this way and we're good and then what
we're going to do below that is we need a decision so let's go back to our
insert let's go to our shapes and let's get a triangle which is our decision
cube and we'll make a decision here and I think I'm gonna get it centered here
now I'm going to make my decision one slightly bigger and I'm going to change
the color of this as well so let's change the color so up on the toolbar
now that we have one on here you can drop this down and let's make it Orange
and once again we can right click - to edit the text and what we'll do is we'll
right decision in there
okay and so that so going down would be yes and going to the right would be no
and so what we're gonna do is we're gonna put another step in here so once
again we'll we'll go to the insert and that once again we're going to the
flowsheet here and so we're gonna get another step from here now we want this
to be green similar to the step one so we're gonna drop the list arrow here and
we're gonna choose the green and we'll call this step two and then at the
bottom we're gonna going to do an ending statement so what one more time we'll go
and we'll get this one that it's already up here for you so you can just put it
in move it over a little bit and I will call this end okay so all you have to do
now is get some arrows between between the thing so what we're going to do is
we're going to type in here we're gonna type the word no and then just a minute
we're gonna move this down a bit and we're going to type the word yes in here
and then what we're gonna do we'll move this down to here and we'll go back to
our insert and we're gonna go back to our shapes and we're gonna get our
arrows so from here to here you need an arrow maybe I need to square that up a
little bit and you have the arrows on the top here so from here to here you
have another arrow now I need to bring this over a bit and
then from here to here you have another arrow and then you need to have an arrow
for this going back to here so what we're going to do is we're going to
choose an arrow that has that has a break in it
so there you go there whoops forgot one here
there you go there's your basic flow sheet and it's completed in Excel please
subscribe