much for joining substantially they can
very easily create these raffle tickets
then used to create for an upcoming
raffle we have at our elementary school
they look at Lake Chelan which is a
fabulous place if you're ever in the
Washington area with generous generous
enough to donate a weekend away and as
you can see here very easily created I
think a little over a hundred lottery
tickets within a matter of minutes using
nothing but Microsoft Word and Excel
alright so before we get started I do
want to point out that I do have a
YouTube channel which has lots and lots
of printables and most importantly it
does have these certain fonts installing
and using symbols if you do not know how
to download and install new fonts and I
use a font that you do not have default
on your computer please watch that video
to learn how to do that subscribe to my
channel and or like any and all of my
videos that would be so appreciative
alright so let's go ahead and get for it
first thing we want to do is go to file
new blank document you don't want to go
to page layout go to marketing to go to
narrow we then want to go to insert
picture oopsies I'm so sorry insert
shape and we want to insert a rectangle
again I did shape and I did a rectangle
insert shape rectangle and then you can
click anywhere on there once you do that
you can see the distance listed because
it has a little squares around it and we
want to go up to format and we want to
make this 2.5 by 4 size pretty average
for a raffle ticket and then you can go
ahead move the filled up furnace you
then want to click on format' do a shape
0 of no fill a shape outline of black
and we want to do a weight of this is
two and a quarter car next what we want
to do is create this part of the ticket
we then want to go through and we wanted
to insert text box and we want to draw a
text box and we can kind of draw it
anywhere in there but what we want to do
is go up to this format and we want to
make this 2.5
by 2.3 we then want to click on format'
do a shits out of no film more
importantly we want to do a shape
outline of three and a quarter and we
want to do the dashed lines right here
and that's going to create that sort of
dash line bit so here that's right when
a weekend okay land now if you notice
here the spacing is a bit big so I'm
going to highlight that text get a home
click on line spacing options and we
want to go down to zero and
single-spaced press ok okay
we don't want to go and we want to
highlight this and we want to Center
this and then we want to change the font
and we want to make this trip
I believe it's culturally Desha I'm not
sure but I think that's the trading Shea
ask again if you don't have that default
please watch my video and in down that
and download that fonts and this is 12.1
and this is actually constellar font and
this is a 14 point font alright once we
have value to kind of enter to make that
a little bit longer process here a few
times and then some here we want to do
name those you know and again if you
want to add address you can add address
but what we want to do is we want to not
Center this but align left and again we
want to add that same at trebuchet but
we want to make that ten point one and
obviously we want to add some space
people too right now we want to add
those lines so we want to hold down our
Shift key go put your cursor next to
name hold down the shift key and click
on the underlined and that's it pretty
easy hold the shift key click on the
underlined my underline is found next to
the zero key on my keyboard firm your
keyboard could be different
I can hold down the underline okay
finally we want to click up here and we
want to insert our pcs we're going to
insert pixel we're going to go to
desktop we're going to go to wrestle and
we're going to find our East Gate PTA
logo we want to right click and we want
to do rap text we want to do behind text
we obviously want to make this much
smaller and we want to change the color
to gray and we want to click the
corrections to make this much lighter
and then finally we just want to move
this in the middle finally let's add our
actual ticket portions we want to do
insert text and what did you draw a text
box and let's just make this text box
right there and we want to click on
format' do a shape fill of no fill and a
shape outline of no outline for that
text box when a you can actually amazing
and it really is amazing
see okay then and once again we want to
highlight this go to our home click on
this line spacing options and we want to
make this zero and single spaced we then
want to Center this and once again we
want to change the font is that
trebuchet ms' and this is casteller and
this is a 14 point font
and from here we want to do and enter
for the look out at Lake Chelan
okay get treatment just a little bit
further down just not quite so far right
alright and then from here we can go
ahead and press enter but what we want
to do is actually change the fonts to
Calibri and a 10-point font and we're
going to press enter one more time and
the reason we want to change our plan is
because if this is a 14-point one it's
going to make the spacing bigger so we
want to sure to change up to Calibri
we'll change this up
well you 14:17 and we can add our little
flowers moon in the comment and we can
make this bold and then from here we're
going to go back and I'm just going to
copy some of the Burbidge that was given
to us from our amazing partners at to
look at a little and and and that's it
to create this oh we do need the logos
that's right we want to do an insert
picture and let's take a look out and
once again we want to do behind text we
want to make this much smaller and we
want to change the color to black and
white we want to move this right over
here and we want to once again click
over here do an insert picture click on
our PTA logo once again we want to do
behind text move this up here against
with all I'm kind of going fast because
we have a lot to show you and I have
already showed you this part make this
smaller and we want to change the color
to black and white and we want to move
this right over here
now finally we want to add in those
numbers so we want to insert text box
draw our text box we want to draw the
text box right here and we're going to
write in number period and we're going
to leave the rest of it as a space okay
we also want to do a shape fill of no
Phil shade line of no outline and I want
to change this font what I used is the
modern number 20 okay from here we can
write with this we can right click on
this text box and click on copy go up
here and click on paste and we want to
move this right down here because
obviously need the numbers twice now the
last type is last part before we copy
and paste is we want to insert shape we
want to insert the line we want to go
hold down the shift key and do that line
right there we want to do is shave
outline a black the weight of one and we
want to do sort of that on both sides
okay so that is it to create the outline
of this now let's go and copy and paste
this and add a numbers so in order to
copy and paste this multiple times in
the sheet you're going to press ctrl a
and that is going to select all then you
want to press ctrl C for copy ok from
here you want to press the Enter key to
move this one down you want to go back
up to the top and press ctrl or control
V okay move your arrow key down here
both control Z all right and again you
can always press the Enter key if you
need to move these around so now we have
three on one page again if you played
with the spacing or maybe bigger or
smaller your pipe it fit four or five or
six now we need to fill in these numbers
here's where you need Excel okay we're
going to go ahead and open up Excel a
new blank workbook okay because we have
three per page we need to use three
different columns if we have four
tickets per page we would need four
columns if we had five tickets per page
we would need five columns but what we
essentially do is have the numbers go
one two three four five six and this
column we increment is three so what we
want to do is we want to do an equal
sign open parenthesis three plus we want
to do this so and again you just
highlight that cell where you could type
in a one and you end parenthesis it's
very important and parentheses then you
just press the Enter key again equals
open parenthesis three plus
be two and parentheses enter key equals
open parentheses 3 plus highlight the
cell or you could even type in c1 and
then the enter key okay now all you need
to do is go to the bottom right hand
corner hold down the left click button
and go down to as many as you want this
is showing you how to make 72 but again
you can you can do this version as many
as you want okay now the next thing is
you can see here that these are actually
from values these are formulas not
actual data number so what we want to do
is change these formulas to data numbers
so what you want to do is you want to
highlight
left click do a copy okay and then you
want to highlight and you want to do a
left click and you want to do paste
values you see that little 1 2 3 the
second you just want to do paste values
now as you can see these are actual data
values finally we want to add 2 0 0 1 0
0 2 0 0 3 so you want to highlight all
of these and you click on more number
formats and again this is under the Home
tab and then from here you get a custom
click on this and you just type in if
you want this to be a thousand or 10,000
you can do that so you want to make them
up to 10,000 all right now we have our
formats so one more step before we save
is we want to do inserts and we were to
say now you ticket won two tickets one
ticket
two tickets three okay
from here we want to say file save as my
computer save this in a raffle and this
is very important you want to save this
as csv comma-delimited okay and let's
say this as raffle data yes okay now we
want to go up and we want to close and
we can save it again we already saved
this both mean I just like saving again
okay again very important to close out
Excel document now from here what we
want to do is click on to mailings and
we want to click start mail merge and we
want to do step by step wizard now over
to the right we can go ahead and click
on letters up sign current document is
what we want and we want to browse for
the data set again use an existing list
we want to go to our desktop we want to
go to our raffle and again we call this
raffle data here's the data that we want
this looks perfect
then we just press ok next write your
letter okay now again you want to click
on that first raffle ticket and you want
to hit it a space between a number and
then you want to go click on more items
from here we want to do take it one now
from here we want to do take it one now
from here you want to click on the more
items and we want to do is you could
imagine ticket to and from here you
Wendy widens and ticket to and then from
down here
we want to click on more items to get
three and from here more item to get
three and then we want to go to next and
we want to complete and then we want to
print okay very important what you can
either print to a printer or I like to
print a PDF so I can see what it's going
to look like and we want to call the
gospel ticket dot PDF okay let's wait
while this is printing and let's go
ahead and go to our desktop and let's go
ahead and go to our raffle and let's go
ahead and open up our raffle ticket so
now we can see here I'll just paste and
got a little off but you could easily
play with that zero zero one zero zero
two zero zero three and we have our
raffle ticket okay thanks so much for
watching and if you found useful please
like this video watch in any and all of
my videos like the mama subscribe to my
channel and I do monitor the chat lines
often if you have any questions or
comments please feel free to comment
thanks so much and I hope you did find
this useful
bye