Excel Tutorial: Learn Excel in 30 Minutes - Just Right for your New Job Application
Excel Tutorial: Learn Excel in 30 Minutes - Just Right for your New Job Application
Learn how to use Excel in exactly 30 minutes starting with the very basics (for the complete beginner) and then move to more intermediate features such as charts, mail merges and reports. For more info. and to learn more visit https://learn.kaceli.com.
I have designed it to be a resource for anyone starting to learn Excel or is applying for a job and wants to know how to use Excel and enhance their resume with Excel skills. The tutorial is based on Excel 2016 and all features also work in Excel 2013, Excel 2010 and 2007.
If you like the video, please “Like,” “Favorite,” and “Share” it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.
The full Excel 2016 Tutorial is available from here: https://www.youtube.com/watch?v=8lXer…
In more detail, as you can see below, it includes everything you would need to know to sharpen your skills for a new job application.
Data File if you need to follow the tutorial hands-on: https://kaceli.com/a/excel-2016-data-…
Learn concepts related to Excel spreadsheets such as cells and references and formulas.
Learn how to enter formulas in Excel including, SUM, AVERAGE, MAX, MIN etc.
Learn about other mathematical calculations in Excel.
Learn how to sort and filter data in Excel.
Learn how to create charts in Excel.
Learn how to change the page layout and create headers and footers and change the margins including setting the printing area.
Learn how to use conditional formatting and other formatting features in Excel.
Learn how to do cross-sheet calculations in Excel.
Learn how to even perform mail merges in Excel
Learn how to link a spreadsheet with Word for reports.
Learn how to email an Excel spreadsheet and even save it as a PDF.
Excel in 30 minutes URL: • Excel Tutorial: Learn Excel in 30 Min…
Keep in touch:
Website: http://kaceli.com
YouTube Channel: / skaceli
If you want to take get a deeper understanding of Microsoft Office applications, take a look at http://learn.kaceli.com
**Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.
Content
1.81 -> Hi! My name is Sali Kaceli and welcome to
Excel in 30 Minutes. This is a concise
7.609 -> tutorial on learning Excel even for
anyone that has never used Excel before.
13.42 -> To get you started and understand how
Excel worksheet how to use it
17.779 -> effectively in business in just 30
minutes. This tutorial is designed to
22.789 -> give you the tools necessary in your
technology toolkit for a new job
27.8 -> application or for just understanding
how Excel works. This is based on
33.38 -> Excel 2016 but the functionality is
gonna work exactly the same in previous
38.69 -> versions. So let's get started. So as soon as you open Excel and you started your
43.95 -> spreadsheet you are presented with a
window very similar to this. So in Excel
48.48 -> you have the workbooks or spreadsheets
and these are the files very similar to
53.69 -> like Microsoft Word
58.91 -> was designed to perform calculations
using formulas.
62.77 -> The other thing is is that you have here
in the bottom these Tabs. Typically it
67.509 -> starts with with only one time and you
keep on adding new ones by simply
71.7 -> clicking on this plus near the bottom. Now to rename you can simply
76.359 -> right click on them and choose Rename
and you can give its whatever name you
79.859 -> want. If you want to delete a specific
Tab of course with caution you can just
84.259 -> simply press Delete. Let's get started on
some of the other concepts as well.
88.609 -> Basically you have these columns and
rows these and then you have also these
94.88 -> squares here in these are referenced as
the cells. Now this reference right here
100.52 -> is referred to as B3 and you take into
consideration the column and where it
106.6 -> meets all the row, that's the reference. Now typically whenever you're
110.179 -> building those formulas for the
calculations you'd be using those
113.49 -> references values within the references.
117.109 -> That's one of the key concepts in here.
119.6 -> Additionally in each one of those cells
you can insert text or you can
124.7 -> insert numbers. And those could be numbers formatted in a variety of ways. They
131.63 -> could be general number they could be
currency they could be accounting, or
135.15 -> a date or time and percentage and
things of that nature. And use format it
140.98 -> from here or it could be a formula as
well for example here you could have
146.94 -> D3 you could have 3 could have
five and now in here you want to get the
152.459 -> total for those. Well in here you could put a
formula. And by the way all formulas in
157.53 -> Excel start with the equal sign. That's how their computer knows that
161.209 -> it's a formula. And then we put in the
function and then we get those has a
169.12 -> total for those values and I will explain thoselater as well. This is an example of a
173.75 -> formula within a cell and what does that
equal sign in front of it. And the other
179.86 -> thing to remember in Excel is that
if I change one of those values and
184.459 -> enter the total be updated automatically
and that's where Excel the power of
189.28 -> Excel comes in. As far as other functionality functionality the tabs here
193.72 -> other functionality it's very similar to
Microsoft Word or other applications
197.6 -> from Microsoft Office. So now let's move
on to another area for you to understand
203.54 -> how Excel works and how to get started.
So I have created created these worksheets
208.69 -> here in the bottom and now I'm going to
demonstrate how to use formulas to make
213.42 -> those calculations here. So one thing to
remember as well as an adjusting these
218.38 -> columns you can simply, notice how the
text doesn't fit in there you can just
222.07 -> drag it to the right and make it fit or
you can simply doubleclick and it will adjust
226.03 -> accordingly to the widest point in
in your column there. So that's how you
231.45 -> adjust it. Now if I wanted to put a title in
here it could simply start typing and
236.709 -> then hit enter the other thing I could
do here is that I could select these bunch
241.54 -> cells in here and then I could
use what's called here merge and center
248.09 -> and for you the icon might be a little
bit larger than why there's because
251.92 -> my recording screen size here. Then
choose merge and cent er and now and
258.72 -> notice all these cells have been merged
and text has been centered. Now of course
263.55 -> you could make this font larger in adjust the properties manually or what you
268.02 -> could do is you can go and use one of
those styles cell styles and format
273.73 -> this using one of the themes. The next
thing that will learn here is to get you
277.95 -> started right away with using Excel is
that we all want to format this cells
282.74 -> and you select them and you want to
format them so that they are currency
287.53 -> well you can format in currency by using
this drop down here and choosing
291.479 -> currency or you could use this dollar
sign icon over here on the other number
296.53 -> area in at this point that this has been
formatted as currency. Here on the right hand side we want
302.56 -> to do potentially is that we want to
calculate those values and add them up
308.16 -> basically get the sum or the total fees
and expenses for January February and
312.229 -> March now to calculate it one of the
easiest ways of course would be to use
317.13 -> this tool here the the autosum on the top
right and hit Autosum, and then
323.66 -> just press Enter and that will give you the total. Notice
328.419 -> that you have this toolbar here that
tells you what it's calculating you need
332.21 -> to make sure when you use the AutoSum make sure that it is doing the proper calculation here.
place doing the proper calculation here
336.68 -> The other way to do this AutoSumor
to get the some of these numbers is to
341.24 -> understand them and do this manually so the manual way is the equal sign. All
346.229 -> formulas start of the equal sign and then
in Excel you put in the next thing is
351.3 -> typically the function that you want to
perform in Excel. Excel has hundreds and
356.87 -> hundreds of functions in here we are going to cover only few of them to just get you started so
361.85 -> in this case as we type SUM and then
notice it says some it adds all the
369.229 -> numbers in a range of cells so now it's
it's expecting you to insert the range
374.47 -> The range in the cells here is
expressed by using parentheses and then
379.62 -> you can simply either type those
references e.g. C5
383.79 -> we want to start on C5 and all the way to E5 the colon there it
389.28 -> represents the range in between now and
the start of C five all the way through
394.15 -> E5 or it could be E500 for that matter so it's
going to calculate everything in between
401.07 -> you could type those or you can select
them like I selected them here and
406.41 -> you can hit Enter and you could do the same thing if you wanna through this next one
410.97 -> as well. SUM and then open parentheses you could even do that
415.77 -> c6 colon e6 and close parenthesis and hit Enter or you could drag it like I did earlier.
425.3 -> Another method here instead of me spending all day typing these references here are these
430.03 -> formulas what you could do is it you can
drag this down from top to bottom
436.79 -> top to bottom or left to right
this by the way is referred to as
442.65 -> the Autofill feature in Excel. Now you
can use this for anything in sequence
448.6 -> and I'm not gonna go into details of the
technicalities already you can check one
453.47 -> of my other videos regarding that you
wanted to calculate also the totals for
458.1 -> January here. So you do it the same way
460.59 -> equals nine so open parentheses and then
drag this thing down hit enter and now
468.7 -> we have the total here for this column for January. Now to move it to the right we
473.12 -> can apply this also on the right hand
side by using the Autofill Feature.
479.35 -> So just drag it here to the bottom when it changes to a plus sign and then let it
484.13 -> go and it gives you the total. Now let's
say we want to get the average of these
490.03 -> these values from C4 to C12 so
let's type here AVERAGE
497.22 -> you can either start typing equal sign
and then just type AVERAGE and will
501.3 -> show up here
502.72 -> Equal AVERAGE or I will show you also a trick how to use those formulas and functions and
511.29 -> basically what you do is you go under
formulas here you click on insert
515.52 -> function and let's assume you do not know where Average IS. You say give me a brief description as
521.9 -> And tell me what you want to do. Notice it returns the
527.4 -> arithmetic mean of arguments
and all that type of thing and then you
531.83 -> also have this option here so for any of
the functions in Excel you can always go
536.3 -> here Help on this function and it'll
take it on Microsoft Help is all give
541.33 -> your description of it as to how it
works. e.g. equal sign average
546.26 -> A1 through A20. So instead of doing the SUM A1:A20, you could do
553.45 -> average A1:A20 then it gives us
the syntax how it works and
560.26 -> even some examples below that's one way
of doing it so you could do it from this
565.25 -> point here you choose average and then
you're saying okay I want the average
570.74 -> where it starts and then number one
where we want to start, selecting it
577.46 -> and then I am doing on clicking OK and notice the average is 154. Notice I
584.03 -> could have done that
585.17 -> also this way. The Equal sign, Average, open parentheses
590.01 -> and then select the range to get
the average for. And notice, I could
598.29 -> use the Autofill Feature and get the
average for all the other columns.
602.1 -> It works the same way for also using the lowest numbers. So let's say I want the Minimum. I go
609.48 -> here under equal MIN parentheses select
the range of start from top or bottom
618.15 -> and then drag it to the right and there it is.
let's say I want to get the maximum
625.72 -> number and I'll let you do that you
should be able to figure it out by now
631.04 -> now let's move on to something else is
more fun as well so now let's say we
635.42 -> wanted to do some calculations so let's
say we wanted to get the SUM of a bunch
640.77 -> of numbers and know that we have here a
bunch of employees and we want to get
645.589 -> their pay figured out. Their total
deductions so this is the amount they
650.6 -> pay their deduction 1 and deduction 2 and we want to calculate the total deductions.
654.7 -> This is again adding a bunch of numbers
together so it will be equals and then
660.84 -> the first number with the next one hit
enter and it gives the totals now
666.99 -> this feature here Autofill automatically, that is a feature in
671.52 -> 2016 if that doesn't work for you in
previous versions don't worry about it
676.99 -> you can simply drag it and do it this
way now the next one is to be the net
682.589 -> pay how do we calculate a net pay so
basically be gross pay minus
687.44 -> deductions and that'll give us a net
pay. So we are learning deductions doing subtraction
692.39 -> so we do the equal sign and then you could
choose the gross pay which is C4
699.61 -> minus the total deductions which would
be f4
705.64 -> hit enter and there is the total for all
the employees at this point and there is
713.43 -> the net pay for the first employee now
we can drag this down and of course we
718.19 -> have the calculation for all employees
whenever you're doing this
723.9 -> make sure that you double check their
references and also note that we did not
728.5 -> need to put the function for basic
arithmetic calculations now let's learn
734.48 -> about the annual net pay. So we want to get this multiplied by the monthly net pay
742.31 -> multiplied by 12 and here we are
learning the multiplication aspect how
747.23 -> to do it in Excel so we need to do it
here is = G4 that will be
756.15 -> the cell over here
758.21 -> times 12 hit enter and that gives us the
annual pay for the employees. Then
764.98 -> let's say we want to calculate weekly
pay this will be dividing the annual pay
770.78 -> by 12 and again it will be equals sign, the
reference which would be h4 divided the
780.84 -> division is represented by the / and then
divided by 52
788.98 -> which will be the number of weeks per
year
791.67 -> enter and there is the calculation per
794.82 -> pay per week so this briefly explain how
to use the arithmetic functions in Excel
801.41 -> and these are very key even though this
may seem simple they're very key in
806.47 -> utilizing Excel effectively for your job
or whatever it is you're doing. The next
812.54 -> item here before we waste too much time
and we go beyond our 30 minute time
816.82 -> limit here for this tutorial is how do
you sort your data and
821.9 -> filter your data. In Excel that's very
easy as well let's say we want to sort
829.15 -> say by date first so all you do is you
go to the column you want to sort by
834.019 -> by and you click here on sort and filter
you choose oldest to newest to oldest
839.059 -> however you want to sort it or another
region here and choose a through Z or
844.989 -> alphabetically or however it's as simple
as that
849.069 -> Basically click on it and choose to sort it.
want to filter this data let's say we
854.079 -> want to see all the sales by a specific
sales person so we go here we want a
860.739 -> filter only as the sales from
Franks
864.61 -> well what you do is you click here on
sort and filter click on filter and
868.54 -> notice it will put these drop down arrows now in here you can click on the drop down
874.369 -> and choose which ever you want to have
them filtered by. So we choose Franks and now know
880.529 -> all the Franks records show up the
rest are not being displayed at this
885.019 -> time you can filter by more than one
criteria here so you could say I want to
890.42 -> filter by the region specific region
that say the eastern region and then
895.579 -> Franks and then I see only those from
Franks and the Eastern area now to
902.269 -> clear the filters what you have to do is
unfortunately this doesn't fit on my
907.889 -> screen here but there's an option right
above the recording screen here
913.92 -> it says clear filter from region or you can
just uncheck this so clear region and it will clear out.
920.129 -> And next unfilter, and it will clear it out.
924.24 -> The next one you just clear it at the top
926.319 -> notice as well that one other feature
here is that you can also create filters
935.529 -> that match a specific criteria that are
greater than smaller than top ten and
939.97 -> all that type of stuff now that's data
filtering in just less a minute here or two.
946.98 -> next thing that I will show you here is
947.959 -> is how to create charts in
Excel so that's another very useful
955.339 -> feature so let's start with the basic
and easiest one first. So it's a
959.459 -> you have the year and the sale and you
want to apply a specific chart for this.
964.13 -> well one of the cool things is that
if you have office 2013 or 2016 is that
969.61 -> you have this option here on the bottom and will give you some additional things
974.66 -> that you can teak and and customize here
for your liking and tinkering will so
980.89 -> here it and go on the charts and you can
create a line chart that's how it would
985.44 -> look like or a clustered chart or any of those other types of charts here that's one
991.38 -> way to create a chart the other way is
that this is the traditional way is by
996.03 -> going under insert and then you choose
to insert a chart. Now you know that you
1002.07 -> have all these different types of charge
but one of them
1004.87 -> features here is the recommended charts
and this was new in 2013 and 2016 so
1011.94 -> click here and you choose one of those
charts click OK
1015.57 -> now know this is inserted the chart
automatically here and the next thing
1020.46 -> you can do is you can customize and use
any of those tools and options here on
1025.27 -> the top to tinker with it.
1027.14 -> The other thing you can do is you can
change colors if you want to tinker with colors
1031.54 -> more the layout to make it a different
layout to bring more data or less data
1036.49 -> on the screen here and also notice that
you have a bunch of options here on the
1040.89 -> right hand side and we have two tabs and
these contectual tools on the
1045.959 -> charts in Excel so you can tinker with
those as well with the charts now you
1051.61 -> might have references like this where
you have a bunch of stuff a sales for
1058.16 -> example for this year have multiple sets
of data now if you want only one set of
1063.27 -> data, you can just select the labels in the data area and then create a chart very similar to how
1070.68 -> you did earlier if you want more than
one so like two or three of them so
1077.42 -> let's say three of them will go then
under insert and then choose recommended
1082.63 -> charts, pick one of those charts and
then click OK. Now notice they are
1087.83 -> grouped together and you can tweak it as we discussed it earlier.
1092.59 -> You can tweak it further. Before we
move any further here as well I'd like
1097.37 -> to demonstrate how to get data from one
worksheet to another so let's say I have
1103.75 -> here and I'm creating an annual report
and then I want to put in there the various
1109.549 -> employee expenses per month or per year
or whatever and I had to come in here
1115.19 -> let's say these are the names of my
employees and just copying and pasting
1119.7 -> them at this point but now I want to
post in another one another area for a
1124.89 -> report
1125.96 -> well what you can do is basically you
can post the value of another cell in
1132.82 -> another worksheet wherever you want to
another part of the worksheet you can do
1137.52 -> this in a couple ways by using what's
called named references but here I am going to explain
1142.559 -> the quick and easy way is
by hitting the equal sign so there are
1148.11 -> three steps remember three steps here
1150.429 -> equal sign on the cell if you want to
post the value you go wherever the data was.
1155.299 -> For now I want to post for example
the pay for hubert here so I just click
1162.909 -> on it and then hit enter and it posts
it. Now if I change it somehow over here
1169.49 -> his pay let's say it increased or decreased or whatever happens then I can go here and
1176.909 -> it will be updated now notice
whenever you see these number signs
1181.72 -> here that means that the column here
it's not wide enough you just need to
1185.09 -> drag it to the right and it will be
posted this could also be a calculated
1189.649 -> his value as well so equal it could be
wherever there was a formula for example
1195.22 -> for this person here and hit enter and
it's now posted for this person here.
1203.09 -> Now in my madness here to show Excel in 30 minutes, I am going to move to
1207.299 -> another quick area here as to how to
change the print layout for this
1211.83 -> document and let's go here to the beginning of this document, let's say I want to format this and tweak
1219.21 -> tinker with it more so we can go and
highlight a certain area in Excel and
1224.809 -> you can apply to format that as a table
and you just pick any of these designs
1229.659 -> and you could say my table has headers and format accordingly the
1235.139 -> other things you can utilize is you can
under the Home tab you can use
1241.169 -> conditional formatting where you can format the data by using these bars here based on
1247.139 -> the value that exists in that cell. You can set the margin you can basically click on
1252.919 -> custom margins and you don't specify how
many of the margin should look like the
1258.289 -> top or on the bottom and other things
you can put a header and footer so if
1263.039 -> you want a custom header it'll say just
type in here
1269.46 -> and and then that will be posted on all
the pages there then you can also click
1278.33 -> here on print preview and it will give
you a preview of this document let's say
1283.909 -> that I did not want to print this other
stuff I just want to print this area this
1289.5 -> table right here to set the print area
here what we do is select the area that I
1295.94 -> want to see others my print area I go on
under page layout and then I can go
1301.33 -> another print area and choose set print
area. If I go to File Print and get a
1309.71 -> preview of it this is what's going to
print out only that specific section is
1314.309 -> going to print out I'd like to also
demonstrate how to do mailing and
1319.77 -> sharing with other users as well. So what
we do is if we want to share this spreadsheet
1325.299 -> with somebody else you can go here under
the File menu and then you can click on
1331.75 -> Share under share and share it via
email or other people in the cloud or
1338.13 -> also you can share it as an attachment
and this will be the most common one the
1342.419 -> other option is to send it as a PDF you
can actually choose to export this you
1347.85 -> choose to export it as a PDF format and
that's all you have to do you give it a
1353.48 -> name. I'll demonstrate this point very
briefly how you can link of this were
1359.13 -> reports are supposedly every month
you're making a report but you'll want
1363.809 -> to data from your Excel to be
automatically linked to your report in
1367.36 -> in Word. So there's a way that you can
actually link a portion or part of
1373.37 -> your data in Excel with a word document
for your reports and then every month is
1379.72 -> gonna be pulled are automatically to your
report. So suppose this is my document in
1385.07 -> Word here
1386.25 -> and say this is my report copy and paste
it. so for example if I choose here
1391.39 -> Control C to copy it so or copy over
here if i go and paste it into Word now
1398.48 -> this that's the first thing is going to
happen here is it's going to paste it
1402.12 -> that doesn't look too bad however it's
not really linked with Excel so what we
1406.46 -> want to do is we want to make sure that
this is actually linked with our excel
1411.53 -> file and then you go here to excel I
select the data I copy it just like a
1418.84 -> copy this area control C now I going
to word here instead of pressing Ctrl V
1424.68 -> to paste it i click here on under the Paste
section click on paste special place
1431.96 -> there's a link to an Excel object and then
click OK and then it has been pasted.
1439.42 -> doesn't look too different from the
previous one if I were to close this and
1443.91 -> save it so we'll save it I'll call this
is my report now if I go here to and
1451.71 -> now I let's say months passed by and
whatever happens there I go and change
1457.12 -> my expenses here have changed so let's say I spent more and notice now my numbers have
1461.93 -> changed here such and my expenses have
gone up and instead of me going and
1467.4 -> copy and paste in my report and so on
what they can do as I can minimize my
1471.39 -> Excel or close it doesn't have to be
opened by the way ,
1475.7 -> double click on the report
1476.77 -> notice that the first thing that will pop up
as its gonna say this is linked to an
1480.88 -> Excel or other file out there do you
want to update it now yes and the magic
1486.81 -> happens automatically here but this was
after I made the changes and it updated
1493.11 -> this data automatically from Excel as
I change something in Excel Word
1499.73 -> report. Another feature that like to show
you and the ability to do mail merges
1504.51 -> using a data file from Excel this is our
data file and we can maintain this
1510.01 -> anyway you want as you go and you
basically have the first row has the
1517.45 -> field names then you maintained a
different columns here and the addresses
1521.09 -> and other information as well. Now you
can utilize this and update it as you go
1526.47 -> and then every so often create a mail
merge to create the mail merge what you
1532.1 -> do is you go under mailings here in word
and you click on mail merge and I
1536.18 -> usually recommend that you utilize the
step-by-step wizard then you click on
1540.77 -> Next here and then you choose Letters. You could choose envelopes, email messages as
1545.67 -> well and that'll be a powerful feature
free to utilize its the same principle
1549.85 -> overall for all those functions and have
other video tutorials
1553.11 -> for those as well then what you
do is you click here and create letters
1559.4 -> and that you click on Next and then it's
going to ask you if you want to use the
1564.2 -> current document that's what we are used
in this case we're going to create one
1567.78 -> from scratch then right click on select
recipients and we go and locate that
1573.53 -> file the excel file that we have the
data and and this is my file and
1578.98 -> I'm gonna pick the one that says Sali
Kaceli customers typically it will be
1583.79 -> the first one but in this case and I use
the second one because that's how I
1587.39 -> renamed it as you noticed the moment ago. then I click OK
1592.14 -> here and notice it has all my customers. I could sort it, filter it find
1596.25 -> duplicates and all that type of thing
from here and then click OK I just told
1600.77 -> the system will use this document and
I'm going to use this data file for the
1605.59 -> mail merge.
1605.91 -> The next one is to write the
letters it says go ahead and write the
1610.27 -> letters I say Dear and then ago here
on there in certainly merge field and I
1616.62 -> say their first name and then you could
write the letter and then also include
1625.24 -> in their various fields such you have
from your Excel file so for example if
1630.26 -> I'd say you could basically just fill in
the fields here you get the idea and
1639.5 -> then you can also include in here the
comments field that we have from before
1644.67 -> You could also say say and you can format this however you want of course there are
1653.28 -> multiple uses to incorporate various
fields and customize this for other
1657.41 -> functions as well but just for
simplicity at this point and then here
1662.8 -> you can click on preview letters by the
way at this stage you can also save this
1666.7 -> file you can save it so that it's time
you open it up in the future it will
1672.17 -> actually linked to your Excel file and
you can simply run another mail merge
1676.48 -> automatically without going through all
the steps you can preview your letters
1681.51 -> and know this is kinda put here Dear Owen then I can go to the next
1686.11 -> customer next one next one of those how
it's changing them and then finally you
1690.78 -> can scroll to the bottom here next to
complete the merge and then you can
1695.76 -> either and it's those individuals others
or you can print them directly to the
1699.45 -> printer. Notice you also have this
finish and merge button here in the top
1702.96 -> so personally I choose to edit them. It will create a new document and at this point
1708.57 -> all the files have been compiled and I
should have thirty eight letters created
1715.36 -> on him because they had 38 customers in
my excel file. These merged results
1721.07 -> documents do not need to save unless you want it for
1724.25 -> documentation purposes and the form file
that you have from earlier you can save
1729.53 -> that and utilize it for future emerges
as well so now if I if I don't open it
1736.64 -> again here from emerged know this it'll
prompt me the link to the excel file you
1742.78 -> say yes and at this point they can go on
their mailings and then I can to another
1747.9 -> merge or customize this by adding
something more finish and merge and i
1753.38 -> edit individual letters all of them and
then there is just a couple of clicks if
1759.55 -> you wanted to do an email merge to send
email messages you can click here on
1763.75 -> send email messages for the subject in
here and then the to field that is the
1770 -> field that corresponds with the Excel data file you press email here you click all
1775.64 -> records and engage using Microsoft
Outlook to send this out your customers
1780.4 -> and that's how do I mail merge in
conjunction with Microsoft Excel and
1786.03 -> Microsoft Word. So that is it this
tutorial excel in 30 minutes I hope this
1791.87 -> was helpful and useful and if you want
to learn more about Excel just check the
1797.02 -> full tutorials have put together an
Excel and thank you and feel free to
1802.13 -> post comments and contact me if you
1803.87 -> have questions or comments
Source: https://www.youtube.com/watch?v=7RCdzTpKO0A