Microsoft Excel Tutorial - Beginners Level 1
Microsoft Excel Tutorial - Beginners Level 1
Want more Excel videos? Here’s my Excel playlist: • Microsoft Excel Beginner’s Tutorials This video tutorial will show you how to use Microsoft Excel for beginners. Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel.
Intermediate Microsoft Excel Lesson 1: • Intermediate Microsoft Excel Tutorial…
Dive deeper into formulas and functions in excel with this playlist: • Formulas and Function in Microsoft Excel
Creating Charts in Excel: • How to Create Charts and Graphs in Mi…
0:00 Start
1:07 Starting up
1:27 Recent documents and pinning documents
1:54 Templates
2:34 Layout - Tabs, ribbons, and groups in Microsoft Excel
3:48 Rows, Columns, Cells and Ranges
5:49 Worksheets in Microsoft Excel
6:52 View and zooming
7:30 Inputting Data
10:56 Formatting Data
13:38 Wrapping Text
14:22 Insert Row/ Merge \u0026 Center cells
15:41 Currency formatting
16:20 Print view
17:02 Add cell borders and colors
18:18 Basic formulas in Microsoft Excel
21:17 Copy formula
23:45 Freeze Pane
24:52 Basic Microsoft Excel functions
28:59 “Tell Me” in Microsoft Excel
29:43 Inserting charts in Microsoft Excel
Excel for Beginners Tutorial - Level 2: • Microsoft Excel Tutorial - Beginners …
Excel for Beginners Tuotiral - Level 3: • Microsoft Excel Tutorial - Beginners…
Excel for Beginners Tutorial - Level 4: • Microsoft Excel Tutorial - Beginners…
Microsoft Excel for Beginners - Level 5: • Microsoft Excel Tutorial - Beginners …
VLOOKUP Function for Excel: • Vlookup Function in Excel for Beginners
Learn Pivot Tables for Beginners: • Excel Pivot Table Tutorial for Beginners
10 Best Excel Beginners Tips: • 10 Best Excel Tips for Beginners
Make a Line Graph in Excel: • How to Make a Line Graph in Excel - F…
I use Camtasia to create my video tutorials: https://techsmith.pxf.io/KYOeN
DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Content
0 -> hi there Jamie keyed here today at
2.129 -> teachers tech hope you're having a great
3.75 -> day today we're going to look at a
5.64 -> beginner's tutorial on Microsoft Excel
8.4 -> so I'm gonna go through this tutorial
10.38 -> and show you just a basic lay out some
12.63 -> terminology how to input your data how
15.36 -> to format your data how to work with
17.85 -> functions how to work with formulas how
20.01 -> to work with charts and how to do some
22.38 -> printing at the end so there's lots
23.88 -> packed in here I'm going to throw in
25.38 -> some tips for you too so that when
27.39 -> you're done this that you feel
28.56 -> comfortable maybe advancing your levels
30.3 -> to the next one I'll put out some other
32.04 -> videos about Microsoft Excel to help
35.01 -> with that process too but if you're
37.5 -> looking for any parts of this video just
39.6 -> look down below in the description and
41.67 -> I'm gonna timestamp everything so you
43.35 -> can just jump to that part if there's
44.969 -> something specifically you're looking up
46.59 -> remember I do these weekly tech tips and
48.93 -> if you're looking for other Microsoft
50.07 -> products or any other tech products just
52.14 -> hit that subscribe button and hit that
54.69 -> little notification so when my new
56.67 -> videos come out you'll get notified
58.199 -> right away so today let's start on this
60.809 -> Microsoft Excel beginners tutorial
65.9 -> I'm just gonna go ahead and open up my
68.03 -> Microsoft Excel here I just have it in
69.8 -> my taskbar so when I open this up just
72.59 -> something to know I am using Windows 10
74.69 -> and Microsoft 2016 but if you're using
77.12 -> other versions this beginners tutorial
79.37 -> will match quite closely to a large
81.74 -> percentage of it so just some first
84.41 -> things as you open up your Microsoft
86.72 -> Excel you can see I might have on the or
88.85 -> you might have some recent files if you
90.23 -> have opened up things before these are
92.51 -> just going to go in order of how old
94.61 -> they are from top to bottom but if
96.68 -> there's something important that you
98.03 -> want or there's a worksheet that you can
100.1 -> that you want all the time and to stay
101.75 -> on the top just notice this little pin
103.49 -> here and if you click the pin it just
105.68 -> will be at the pin to the top so he can
107.81 -> quickly find what you're looking for or
109.46 -> you can unpin it and put it back in the
112.28 -> order so another thing is we have all
115.07 -> these great templates here I'm a big fan
118.16 -> of templates once you know kind of what
120.14 -> you're doing and this in this tutorial
122.03 -> that I'm doing today will help you maybe
124.34 -> get to that step where you can save a
125.75 -> lot of time making some
126.89 -> professional-looking work workbooks just
130.16 -> from using the templates and modifying
131.78 -> them somewhat but there's lots of
133.91 -> templates to choose from you know for
136.55 -> homework or school use right through
139.459 -> here or you can even search online here
141.98 -> but the best way to learn first is
144.56 -> starting from a blank blank workbook
146.81 -> what I'm gonna open up and just
148.25 -> understanding the basics of it so I'm
150.95 -> gonna go ahead and open up a blank
152.6 -> workbook here and when it opens up you
156.709 -> should get a view similar to this or
158.63 -> maybe if you're in a little different
159.95 -> version it might be slightly different
161.62 -> and if you look around and now this is
164.6 -> similar to other Microsoft products too
167.12 -> but across the top we have all these
169.91 -> tabs and so whether you're on Word or
173.03 -> Excel or PowerPoint we have tabs across
175.13 -> the top that you can click on to see
177.5 -> something underneath them and that thing
179.959 -> underneath them is called the ribbon so
182.78 -> if I go to my home one which tends to be
184.82 -> kind of one of the ones that you're on
186.44 -> lots you can see this is the ribbon
188.78 -> through here so in the ribbon you have
192.11 -> groups you can see here so this group
194.209 -> right here would be my font group this
196.489 -> is my alignment group through here at
198.32 -> the different groups are named so we go
200.51 -> from our tab to our ribbon to a group
202.459 -> and sometimes what shows up here there's
205.73 -> not enough room so you can see that
207.65 -> there's this little button here to push
209.42 -> if I click this you'll even get some
212.03 -> more options on this so that's just kind
215.36 -> of your basic walk through if you use
217.31 -> other Microsoft products this will be
219.44 -> familiar but those are just some of the
221.42 -> terminologies to start with we have our
223.76 -> tabs and then a ribbon and then our
226.43 -> groups so Microsoft Excel you can see so
230.45 -> what we have in Microsoft Excel we have
232.489 -> if I just click on a on the letter C
235.76 -> this is a column and then if I click
238.879 -> here on the number 4 this is a row and
242 -> now there's your you're not gonna run
243.65 -> out of these columns or rows there's so
245.72 -> many can't remember the exact number but
247.879 -> if you screw you can keep scrolling and
250.28 -> put a tremendous amount of data into
253.099 -> this here now an individual spot is
256.639 -> called a cell so where the two places
259.82 -> meet so where this Row 3 and C meet
264.229 -> right here this is called a cell
266.33 -> whatever cell i click on notice it will
268.729 -> show up here in the top left hand corner
270.59 -> here so as I click on different ones we
273.41 -> have f6 you can see and I click on and
275.81 -> c7 if I grab a bunch of cells that's
280.669 -> called a range on it so a range is going
283.55 -> to be a group of cells all together and
285.349 -> that's these all these things you're
287.03 -> going to be using as you learn more
288.139 -> Microsoft Excel because you're gonna be
290.21 -> taking the data and from whether it be a
293.03 -> cell or a range and then trying to apply
296.69 -> formulas and functions to it so inside
299.78 -> this one range could would go from in
302 -> this case you can see the top left-hand
303.86 -> corner which would be C 4 all the way
306.169 -> down to K 17 and that would represent
308.599 -> that range from there now when I click
311.87 -> on each cell right now all these cells
314.66 -> are empty so if I click on a cell
316.61 -> whatever you see in a cell is going to
319.4 -> be right up top here so you can see it's
322.039 -> empty here so if I write something right
323.99 -> here so if I just write something up
325.46 -> here it will go into that cell and if I
328.729 -> click on the cell it will show me
330.169 -> exactly what's in there so you can
332.09 -> always check to see what's in the cell
333.62 -> you can write up when you're on a cell
335.3 -> you can write something up here or you
337.13 -> can write in the cell here and if I
339.35 -> raise something else you can see it just
341.69 -> goes right in here so a couple other
344.39 -> things to talk about just before we get
346.43 -> starting started in putting our data is
348.53 -> so this whole thing is called a workbook
351.5 -> that you're gonna be working in here
353.99 -> though so when I open it up I open up a
355.55 -> workbook but within the workbook you
358.31 -> have worksheets and you can see down at
360.71 -> the very bottom here we're on sheet 1
363.32 -> you can add more sheets here you can see
366.74 -> I can just click new sheet and as they
369.32 -> click new sheets now I have sheet 2 I
371.93 -> can click again g3 and I can rename
375.35 -> these sheets just by double clicking on
377.24 -> them and calling them something else so
379.4 -> if I just wanted if this was gonna be an
382.16 -> example of I'll just write data and you
385.19 -> can see I can name each of these and I
387.05 -> actually can drag these around in
388.73 -> different orders if I wanted to change
390.89 -> them around too so that's just some
393.02 -> terminology to start off it's important
395.33 -> to know that just as you've read through
397.04 -> and add more things you're gonna see
398.48 -> when they talk about cells or ranges in
401.48 -> the worksheets when we taught start
403.49 -> talking about different things with
404.78 -> formulas and functions later on in this
406.79 -> video so let's get started with entering
409.22 -> in some data and then we can get going
411.32 -> on formatting that too
413.08 -> ok so it's time to start entering some
415.85 -> data now the one thing I'm going to do
417.68 -> before is make it larger so I can see
420.77 -> things a little bit better and then
421.64 -> you'll be able to see things a little
422.81 -> bit better so how I'm gonna do this you
425.39 -> can go to view up top right here and
428.66 -> when you click on it you can see you
429.89 -> have soom options where you can zoom up
432.44 -> and when I hit OK it gets larger the
435.62 -> other thing you can do at the bottom
437.3 -> right hand corner there's this little
439.28 -> slider with a zoom you can see how I can
441.08 -> adjust it very quickly to like that so
443.96 -> I'm gonna go back to my home and now
446.66 -> this will just make it a little easier
448.4 -> to work with so I'm gonna be entering
450.8 -> the data I'm going to be using and
452.54 -> manipulating today is going to be the
453.89 -> top 10 grossing movies of all time so
457.01 -> I'm just gonna enter some titles and
458.78 -> then just do some formatting show you
460.4 -> some basic formatting zhan text so I'm
462.65 -> gonna write this in so we're gonna start
464.72 -> with the rank and
466.07 -> then we're gonna have our title and then
468.59 -> we're gonna have our studio name who
470.63 -> made it and then we'll have our
473.35 -> worldwide grossing income and then we'll
477.92 -> have our domestic and
479.77 -> then we're gonna have our overseas and
484.52 -> one more we're gonna have a year so I
487.52 -> just quickly typed in and what I was
491.12 -> doing was tabbing over each time to when
493.49 -> I was done a certain cell so here's how
495.65 -> you move around you can click I can
497.33 -> click in any cell to move around but
500.03 -> what I tend to do when I'm typing all
501.56 -> tab and if I hit tab it moves to the
505.13 -> right if I hold shift down when I tab it
508.85 -> moves to the left you know I ever hit
510.89 -> enter it will move down if I hold shift
513.86 -> down and hit enter it will move back up
517.46 -> you can also use the arrow or sometimes
519.47 -> I'll use the arrows and you can just
521.63 -> arrow your way around your worksheet too
524.3 -> so I have these titles here and you can
527.03 -> see everything kind of fit in across the
529.7 -> top here because the words weren't too
531.56 -> long worldwide is getting a little
533.48 -> squishy in here at any time if you do
536.06 -> need some extra room if you hover right
538.73 -> around that you can see right in the
540.59 -> middle when you get this handle you can
542.6 -> stretch out your stretch out your
545.66 -> different columns or you can stretch out
547.19 -> different rows but the one thing is not
549.8 -> to worry about if it's overlapping it's
552.29 -> not really messing up anything so for
554.3 -> instance if I was I'm just gonna write
555.77 -> some I'll say studios in the United
559.78 -> let's say in the US so notice that right
563.96 -> now it looks like it's going in 2d so if
566.27 -> I click out of it it stops right here
568.52 -> and if I click into it it didn't mess up
571.4 -> this cell at all you know even though
573.47 -> you can't see it at all that doesn't
576.89 -> mean it's messed up so what you can do
578.33 -> is this is where you can stretch out
580.18 -> your cell like this if you ever want to
583.85 -> make a change remember just use the back
585.29 -> arrow or ctrl Z and you'll go back the
588.38 -> other thing you can do if you just
589.7 -> double click in between those you'll
592.37 -> instantly it will just fix it for you to
594.68 -> even without dragging so those are just
596.24 -> a couple options that you can do to
599.51 -> quickly make those adjustments and
601.97 -> remember on the slide you can get that
603.2 -> handle on the same thing so you can
605.12 -> adjust those two so if we're formatting
608.78 -> maybe you want to make it look nicer you
611.45 -> can quickly change if I click on a
614.15 -> single cell and if I was gonna write
617.03 -> something now so maybe I wanted to add
618.29 -> something the rank and I click on it
619.37 -> once it will just disappear
621.56 -> now the reason if you want a format
623.96 -> inside that cell and maybe I want it
626.3 -> ranking you have to double click in it
628.43 -> and then I could add it that would be
630.29 -> one way another way is if I click once I
633.17 -> can just go up top here and type it in
635.09 -> up in this spot too so just know that if
638.24 -> you click on it once and try to write
639.62 -> something in it it's gonna delete it on
641.24 -> it you need to double click on it or go
643.94 -> right up top here so I'll just undo
646.91 -> those ones and so the next thing what
649.73 -> we're gonna do is just some basic
650.87 -> formatting you can see this works like
652.49 -> Microsoft Word if you've used that
654.41 -> before so if I click on it you can see I
656.66 -> can quickly change my text on it I can
660.14 -> change the size notice how it's
662.45 -> disappearing right away so it may be
664.24 -> double click here and it instantly
666.35 -> changes to this double click here and it
669.65 -> fixes it for me too if I wanted to
671.99 -> change the whole row at once I can click
674.39 -> on it and now I can go back and adjust
676.49 -> maybe I wanted that smaller if I wanted
679.43 -> it bold and maybe I wanted a different
682.25 -> color like blue on it you can see now
684.92 -> that I've made it bigger things aren't
686.27 -> quite fitting in the right places so
688.4 -> then I need to adjust those columns and
690.47 -> remember it doesn't it won't affect the
692.39 -> formulas or anything as this is just how
694.19 -> it looks so we can fix it so again if I
697.1 -> double click on it you can see how I can
700.4 -> instantly fix these very very quickly on
704.21 -> it so those are just some formatting
705.65 -> things to make it look nice it doesn't
707.96 -> change or doesn't wreck anything to have
709.58 -> them overlapping but to visually look at
712.4 -> it it's just a quick thing to do so I'm
714.86 -> just gonna hit bold let's bold all these
717.02 -> I'm gonna double click on here and just
719.03 -> get I'm just gonna call this studio and
722.38 -> I don't want it that large I'll just
724.79 -> double click on it so now we have our
726.62 -> titles the other thing you can do is you
729.14 -> can add so you can just you can select
731.87 -> by dragging it
733.31 -> you can add borders to different things
735.019 -> too so you can see through here I could
736.699 -> add borders between each of them if I
739.31 -> wanted to border around it just click in
742.04 -> here and you can kind of go through and
743.81 -> you can draw borders and you have
745.25 -> different options on the styles through
748.19 -> it so you can then you change how thick
750.259 -> and everything you want on your border
752.149 -> too so if I click off it - now you can
754.579 -> kind of see that that line that goes
756.56 -> around it in a lot of this is for visual
759.05 -> maybe helping as you're working through
760.579 -> it or when you're printing it off
762.11 -> because if you print it off these cells
764.3 -> don't show off I show up these are blank
766.25 -> you need to add borders and everything
768.259 -> if you're printing it off and you wanted
770.12 -> the the outline around certain things
772.37 -> make sure you add your borders and then
775.22 -> your colors and then it's just easier to
776.779 -> look at a spreadsheet especially when
778.16 -> printing off and finding different areas
779.87 -> the other thing you can do if you notice
782.42 -> the Styles right over here so if I click
785.54 -> on this and I want this whole row in a
787.819 -> certain way so if I click down maybe I
790.399 -> want a certain heading on this and you
791.959 -> can see right here it will add the
794.75 -> heading to it and then it's all it's
797.24 -> adjust in a hurry so you can use these
799.01 -> styles to quickly adjust on these - all
801.769 -> right so we have some titles here I'm
804.26 -> just gonna take a moment and enter in
805.85 -> some data so rather than watching I'll
808.1 -> just stop and we'll get back when I
809.72 -> entry out in a bunch more so I've
812.389 -> entered in some of my data from a
813.709 -> website that I have on the top 10
815.569 -> grossing movies of all time you can see
818.3 -> there's a little bit more formatting to
819.649 -> do now a different way to format and
821.75 -> I've already showed you that changing
823.43 -> the width of this here but what you
825.56 -> could do is another way and I'm gonna
827.029 -> make sure this whole column is this
828.589 -> let's select it so I apply this notice
830.99 -> that we have wrap text when I click on
833.18 -> wrap text what it does is it wraps the
836.329 -> text in that in that cell so it goes to
838.79 -> a new line within it so I can read
841.61 -> everything without changing that the
843.829 -> width to it so if you just wanted to
845.6 -> kind of it creates you can see it did
847.73 -> widen everything through here but this
849.68 -> just makes it so if you don't want a
851.029 -> super wide cell you could just wrap the
853.25 -> text instead so the next thing I want to
855.98 -> do with this I kind of want to add a
857.269 -> main title here and I can insert rows so
860.779 -> I can insert more rows even after I have
863.389 -> something I'll set up like this so I'm
865.04 -> just gonna right on this and I'm gonna
867.48 -> go to insert here so I selected the
870.63 -> whole row and then I'm gonna hit insert
872.97 -> notice now everything kind of moved down
875.13 -> and I have a brand new row to it so I'm
878.4 -> gonna write down give me give us a title
880.74 -> here and I'll say top grossing movies of
884.78 -> mmm all-time here okay so I have a title
888.72 -> of this but this title would be nice if
891.03 -> it was kind of centered on top of this
894.03 -> here but I have all these cells so this
896.16 -> is an a1 and this stretches all the way
898.68 -> over to g1 so what I can do with this
901.32 -> now is if I select the cells all the way
904.53 -> to G here and then I go and hit merge
907.89 -> and center
908.81 -> notice now it took that it took all
911.34 -> those cells and made it one cell kind of
913.62 -> merge them all together and then Center
915.78 -> that title for me so again I can go
919.2 -> through here and I can maybe I'll add
921.3 -> another I'll just add a style to this
923.22 -> I'll call it heading 1 and now I have a
925.41 -> title to it like so so I made a little
929.04 -> bit of more formatting so I've wrapped
930.6 -> my tax tight added a title and merged it
932.94 -> now what I'm gonna do is these are in
935.85 -> dollars right through here so these are
938.13 -> in billions of dollars I just use the
939.87 -> abbreviated apart just like I took off
942.42 -> the internet but these are in billions
943.83 -> of dollars now I could highlight
946.32 -> multiple rows and apply something but in
948.72 -> this case because I'm not sure what I'm
950.25 -> gonna do down here yet I'm just gonna
952.14 -> select the area with the money in it and
954.48 -> notice right here we have a dollar
956.76 -> symbol and if I click it it
959.1 -> automatically puts it into a dollar
961.46 -> format here and gives me the decimals
964.11 -> just like the currency now I can pick
966.03 -> different currencies here also so you
969.3 -> can see I could switch from US Canada
971.07 -> United Kingdom and so on it'll make the
973.41 -> adjustments to those dollars on it so
976.98 -> how does this look if I was printing it
978.96 -> a couple and I'm gonna show you right
981.09 -> here and something I want you to point
982.68 -> out notice that this dotted line that
984.27 -> goes through right here that is the
987.09 -> print line of the page the current
989.46 -> settings and everything so everything
990.81 -> within if it's within this dotted
992.85 -> perforated line right here should be
994.89 -> fine to print I just noticed this
997.11 -> ranking I don't need this whole thing
999.6 -> this wide for those small numbers so I'm
1001.399 -> just gonna change it you can see now I
1003.11 -> would have a little bit more room if I
1005.93 -> go over to my file here and I'm just
1009.44 -> gonna click on print it gives me a
1012.11 -> preview here what it would look like
1014.089 -> when I print it noted the notice that
1016.25 -> the cells don't come up the style that I
1018.68 -> picked did come up through here so it's
1020.6 -> nice to have that style to break through
1022.13 -> things up if I wanted everything in more
1024.86 -> of a cell format if I was highlighting
1027.439 -> everything through here so I just
1029.419 -> dragged my mouse down I could go up and
1032.059 -> choose maybe I wanted those borders
1034.28 -> around everything I could pick and
1036.169 -> choose I'm just gonna go to all borders
1038.059 -> to make this quick and now if I go back
1040.37 -> to my file and my print you can see how
1043.669 -> it's adjusted so if I was just printing
1045.53 -> now to my printer I can adjust this and
1048.439 -> this goes the same thing if you wanted
1051.5 -> color in certain parts so maybe I wanted
1053.96 -> this ranking a colored here I could pick
1057.23 -> a certain cell maybe if I wanted this
1060.38 -> orange right here and I could bold my
1062.84 -> numbers on this one and remember you can
1065.33 -> Center just like in Word and everything
1067.039 -> I could if I wanted everything centered
1069.169 -> in here I could highlight everything and
1071.169 -> Center to adjust to that way so those
1074.179 -> are some more just basic formatting here
1076.37 -> and get in if you wanted to print what
1078.59 -> you had so far you can always check to
1081.44 -> see under the print what things would
1084.409 -> look like now to get everything kind of
1086.299 -> looking very well it because it just
1087.65 -> makes things so much easier to analyze
1089.48 -> that the data when you're if you're
1091.909 -> printing it and showing it to somebody
1093.409 -> they'll be able to find things very very
1094.789 -> quickly
1095.83 -> okay so let's start now with what makes
1098.48 -> Excel powerful and that's formulas so
1101.57 -> formulas are of course an equation but
1105.02 -> it's when you're taking a cell because
1107.51 -> you want if the cell changes the formula
1109.58 -> will change so let's go ahead here's an
1111.679 -> example if I was just clicking here and
1113.99 -> you always need to start a formula with
1117.08 -> an equal sign so if I hit equals and I'm
1120.169 -> gonna choose a cell so actually I could
1121.789 -> use a number here so if I go equals to
1124.179 -> and I'll say times two and I'm just
1127.73 -> going to hit enter and I get four so I
1130.61 -> could use Excel like a calculator you
1133.28 -> you may see four here but that's
1135.23 -> actually not what's in this cell now
1137.6 -> look at the four and now look up top
1140.27 -> here you can see what actually is in
1142.94 -> this one so there's a formula here
1144.74 -> equals two times two even though there's
1147.14 -> four over here so if you wanted to solve
1149.48 -> something really quickly in Excel just
1151.7 -> put the equal sign in and then write the
1154.19 -> formula after that now if I click on
1156.62 -> these cells you can see it's just a
1158.18 -> number but this is a formula here so
1160.85 -> sometimes you might need to look in this
1162.83 -> spot right up here to see the formula
1165.29 -> inside this is the formula bar so I'm
1167.9 -> just going to go ahead and delete this
1169.19 -> so let's apply a formula now to our
1172.54 -> spreadsheet that we have over here so
1175.37 -> let's say I wanted to know the
1177.53 -> percentage of domestic versus worldwide
1181.13 -> so I want to put it right after domestic
1183.86 -> here so what I'm gonna do is I'm gonna
1186.5 -> click on this F row right click and hit
1189.05 -> insert now this is going to give me
1191.54 -> isidro I meant to call them this is
1193.46 -> going to insert another column right
1195.89 -> here rate this side here so now I'm
1198.92 -> gonna enter in the information here but
1201.23 -> I want an equation so the first thing I
1203.87 -> said you always start with in an
1206.33 -> equation is just double clicked in here
1208.55 -> I could write it in the formula bar - I
1210.47 -> give it a an equal sign so I start with
1214.1 -> an equal and now this is the powerful
1216.65 -> part so if I click on domestic I want to
1219.44 -> take whatever is in III and then the
1222.65 -> divide sign is they so I'm going to put
1225.68 -> the divide sign is this one right here
1228.07 -> through here so I want to divide III by
1232.49 -> d3 I'm gonna hit enter and notice that
1235.19 -> they went to 27 cents but that's because
1237.38 -> I formatted earlier with dollar signs
1240.26 -> and I don't want dollar signs on this
1242.09 -> one I want a percent so if I go click on
1244.43 -> this one notice I have a percent symbol
1246.74 -> rate up here and I can click it and it's
1248.48 -> 27 percent maybe you want more accurate
1251.96 -> and different percentages notice that I
1254.51 -> talked about this little button before I
1256.04 -> could add I'll go to two decimal places
1258.86 -> and I can adjust it a little bit more if
1261.23 -> you want that a little bit more exact
1263.47 -> now here's the great part with Excel so
1266.86 -> if I click in this cell so I could go
1268.389 -> through and go down and do every single
1270.759 -> one and it would work out fine but the
1274.179 -> formula that I gave III divided you can
1276.279 -> see if I click on this cell here's the
1279.07 -> formula it's saying divide a 3 by 3
1281.639 -> now if I click on this right here in the
1285.399 -> bottom right hand corner notice I get if
1287.019 -> I hover over in this I have this little
1288.61 -> square this is kind of a copy the cell
1291.129 -> down I'm going to drag it down and I
1293.2 -> want to copy it all the way down look
1296.139 -> what it just did for me it did the form
1298.299 -> so now as I click on each one now it's
1300.759 -> efore divided by d 4 e 5 divided by e
1305.049 -> phi divided by d 5 it copies all the way
1308.35 -> down I didn't have to spend time I just
1311.11 -> made that one cell then the way I wanted
1313.149 -> it it knows when I Drive when I drag
1315.129 -> that down and copied everything to
1317.169 -> adjust it to the side so let's do this
1320.169 -> again with the over C so I'm going to
1322.179 -> click on this one I'm gonna right-click
1324.57 -> insert another column it goes to the
1326.889 -> left here I'm gonna get make a formula
1329.289 -> here so I'm gonna hit my equals I'm
1331.75 -> gonna click on my overseas and then I'm
1334.779 -> gonna hit my divide sign here and then
1337.629 -> I'm gonna click on my worldwide hit
1339.7 -> enter again didn't want money I'm gonna
1342.61 -> hit my percentage make an adjustment
1344.889 -> here back to my two
1346.889 -> percentages
1348.629 -> grab this little handle get that little
1351.07 -> black cross right here and drag it down
1353.62 -> and I get all these percentages that
1356.71 -> fill in automatically so that is a power
1360.37 -> of a formula and copying it through
1362.769 -> using a percent symbol you can do it in
1365.559 -> so many you know once you have your your
1368.71 -> your numbers in you can just set up
1371.649 -> these formulas and then we get so easy
1373.059 -> now why are they so great to let's say
1375.129 -> there was an error in something or this
1376.48 -> changes or you were updating it the next
1378.789 -> year so if this domestic number changed
1382.029 -> now let's say if I changed it to nine
1384.429 -> hundred I'll have nine hundred so I'll
1385.96 -> make it larger notice that this number
1388.48 -> changed automatically because it's
1391.059 -> connected to the cell and so it knows
1393.669 -> how to adjust automatically to it and
1395.59 -> now this is the power of spread and how
1398.01 -> it works so well in Excel so you can
1401.22 -> play around with some this is just the
1403.049 -> beginners one so there's so much more
1404.639 -> you can do with formulas and there's
1406.559 -> more adjustments but that's for a
1407.88 -> different tutorial but try some basic
1409.909 -> basic formulas in your spreadsheet to
1412.71 -> see how it works and how it can save you
1414.36 -> some time now but let's not go look at
1416.519 -> some of the functions that even can save
1417.929 -> you some even more time here's a tip
1420.63 -> before I get into some more formulas and
1422.399 -> functions here and I'm gonna zoom up to
1424.98 -> show you this tip here so I'm gonna try
1426.84 -> to zoom up and I'm gonna move over all
1429.24 -> the way to the left notice now we have a
1432.299 -> little bit of the actually going to zoom
1433.889 -> up a little bit more here and notice now
1437.07 -> we have some of the last few cells we
1438.809 -> can see so a handy feature if I look
1441.57 -> under the view here is freeze pane so
1444.929 -> let's say if I wanted to be all the way
1447.45 -> I wanted to be able to kind of look at
1450.179 -> the rank and then look at the numbers
1451.5 -> over here but I just want to make sure
1453.21 -> that I'm looking at the right spot if I
1455.789 -> go ahead and click on freeze pane here
1458.34 -> you can see I can freeze panes top row
1461.039 -> first column well I want to freeze this
1462.87 -> column here now you might have a
1464.549 -> different spreadsheet setup for a
1465.75 -> different purpose but if I click on it
1468.12 -> now if I was going over notice it stays
1471.899 -> in that ranking so I can compare things
1474.87 -> all the time to that rank and so it just
1477.029 -> makes it really visually easy to kind of
1479.519 -> scroll through to where if it whether it
1481.71 -> be rows or columns and you can compare
1483.659 -> it to that first thing you can turn it
1485.7 -> off very quickly like so I'll just go
1488.279 -> back out a bit so you can see everything
1489.87 -> alright so let's talk about some more
1492.269 -> formulas and functions here just kind of
1494.34 -> save you some time and I'll actually
1497.549 -> I'll zoom out just a little touch more
1500.49 -> here so I'm gonna write the word total
1503.429 -> right here sort o ttle and
1505.82 -> so i just showed you a formula with like
1508.529 -> using it like a calculator where you hit
1510.149 -> the equal sign and then you could just
1512.07 -> select the cells that you want so i
1513.69 -> could do the same thing if I wanted to
1515.639 -> add up all these different ones in the
1517.95 -> worldwide to get a total amount I could
1520.62 -> hit the equal sign and then click on a
1523.289 -> certain one I hit the hit the plus go to
1525.629 -> the next one hit the plus hit that go on
1528.87 -> to the next one and
1530.34 -> he had enter when I be all done it would
1531.96 -> give me mount it would work fine now
1533.97 -> here's a quicker way to do it here I'm
1537.51 -> just gonna go over two formulas here and
1540.21 -> what you can see is autosum another way
1544.14 -> you can do it if you're on your home
1545.58 -> notice all the way over to your right
1547.679 -> you get Auto sum right up here but I'm
1550.38 -> going to just be in formulas right here
1552.27 -> and I'm gonna click on autosum and it
1555.779 -> just instantly highlighted all this I
1557.669 -> don't really need this sell it gave me a
1559.95 -> range and I talked about ranges earlier
1562.559 -> on I'm just gonna highlight the exact
1564.63 -> range I need here so it says equals sum
1567.659 -> everything between D 3 and d 12 so in
1571.89 -> this case and you could just write if
1573.57 -> you know the different functions I could
1575.279 -> hit equals and write the word sum and
1577.049 -> then the range and it's gonna take care
1578.61 -> of the job for me so if I hit enter it
1580.89 -> gives me a sum of everything here and
1583.62 -> same thing as I showed you before you
1585.24 -> can copy over you drag that little
1587.159 -> handle grab that little square drag it
1589.83 -> over and it just does it for you here
1592.649 -> the other thing you can do I could copy
1594.69 -> so if I go right click copy and then
1597.45 -> maybe I want it over here and right
1599.25 -> click and paste it will do the same
1601.71 -> thing for me so I can put it to a
1603.539 -> specific spot and notice when this one
1606.419 -> is selected right now it shows me some G
1609.12 -> 3 to G 12 and it did G 3 here 2 all the
1613.47 -> way to G 12 so here's another one so if
1616.289 -> I wanted to
1617.779 -> rate average so if I was typing average
1621.27 -> I want to know the average amount so
1623.97 -> let's look under recently used here and
1626.52 -> usually this one is gonna be rate up top
1628.86 -> so you can see I just did some and now
1631.5 -> I'm gonna click on average what do I
1633.779 -> want to average it's asking for a range
1635.549 -> looks like better click on here just one
1637.289 -> the sec here I'll go back I'm gonna
1639.33 -> click it's going to ask for a range here
1641.549 -> and then what's my range it's gonna be
1644.73 -> this one right here and I'm gonna hit
1647.64 -> enter and now I have average of all
1649.89 -> these and the same thing I can copy it
1652.049 -> over I could copy it all the way over
1654 -> and now it even averaged this but let's
1656.789 -> say I didn't want that and I could
1658.049 -> change that to a percentage if I go back
1660.78 -> to my home hit percent and
1663.55 -> gives you a total amounts right through
1665.8 -> here so you can see how quickly and
1667.45 -> again if any of these change so if this
1669.55 -> was changing to a bigger a larger number
1672.43 -> and hit enter everything changes because
1674.86 -> it's connecting to it so I'm gonna hit
1678.13 -> undo because that wasn't accurate so if
1680.26 -> I go back you can see under formulas
1682.33 -> there are so many in here now each each
1685.3 -> of these can be a video by themself
1686.98 -> explaining how these all work and this
1688.9 -> shows the power of Microsoft Excel here
1692.59 -> as you go through you can look at all
1694.66 -> the different ones and it's about
1696.1 -> understanding how to set your worksheet
1698.23 -> up and once everything is set up and as
1700.63 -> you understand Microsoft Excel more it
1702.85 -> just makes your life a lot easier when
1704.8 -> you're kind of processing all this all
1706.84 -> this data together but then as one thing
1710.26 -> changes it just will fix your
1711.82 -> percentages or amounts very very quickly
1713.95 -> for you so that's just kind of an
1716.56 -> introduction to your formulas and
1718.54 -> functions if you're starting off basic
1721.18 -> with some of your spreadsheets you can
1723.25 -> use these basic ones and as you learn
1724.96 -> more start to start looking at some of
1727.03 -> the other ones so the last thing I
1728.98 -> wanted to show you today in this
1730.9 -> beginners Microsoft Microsoft Excel
1733.45 -> tutorial is how to create a great chart
1736.48 -> to kind of display your information
1739.44 -> so I'm just gonna show you how to graph
1741.67 -> or chart your information really quickly
1744.34 -> I'm gonna go do a different video on
1746.95 -> this to kind of expand it but something
1750.73 -> before we get to that and I hadn't
1752.26 -> pointed it out yet and if you're used to
1753.64 -> Microsoft Information are the products
1756.43 -> that tell me up top here so if you're
1758.71 -> ever looking for something in here if
1760.39 -> you just click in here so for instance
1762.52 -> if I'm looking for a charts if I start
1764.17 -> typing anything it's gonna show me the
1766.75 -> information right up top here so if you
1769.9 -> can't find something in the tabs or in
1772.75 -> the ribbon I just go ahead and start
1774.64 -> typing what you're looking for and it's
1776.29 -> gonna find it for you here okay so
1778.9 -> that's just a handy feature through all
1780.4 -> the Microsoft products but so when we
1783.4 -> put a chart in that's gonna be under the
1785.14 -> insert here now I'm going to show you
1787.87 -> one way here just a simple way here
1789.61 -> today for this beginners tutorial and
1791.2 -> I'm gonna just want to chart the title
1793.42 -> and the worldwide gross on so what I'm
1796.559 -> gonna do is I'm gonna highlight this
1799.41 -> right through here so I'm gonna
1801.66 -> highlight all these different titles
1804.42 -> here I'm gonna hold down control so what
1806.73 -> holding down control allows me to do is
1808.53 -> it the slot allows me to select
1810.72 -> different parts of it so I held out
1813.42 -> control and I could have two different
1815.309 -> areas highlighted and that's what I want
1817.23 -> to chart in here so I'm gonna just go
1819.66 -> ahead and click on recommended charts
1822.299 -> here so you can kind of see it gives you
1824.73 -> some examples right away here you can go
1828.57 -> to all charts if you wanted to look
1830.549 -> through if I wanted a pie chart for this
1833.429 -> example I'm just gonna go to a normal
1835.29 -> bar graph like I said I'll do a
1836.7 -> different video all about graphing to
1839.309 -> show you more information on it but I'm
1841.47 -> just going to go ahead and hit OK and so
1844.11 -> real quickly what it did it took it took
1847.02 -> that information that I selected and put
1849.419 -> it into a graph now it might not be but
1852.179 -> for me it's not finished yet because I
1853.86 -> maybe I want to add a title so I just
1855.39 -> double click in here and I can add a
1857.549 -> title so if it was top grossing movies
1861.24 -> here and I'll just leave it there and so
1863.88 -> I've added a title but what you've
1865.59 -> noticed here on if you wanted more
1868.02 -> things so if you wanted your axes if I
1870.15 -> click on this for chart elements you can
1872.1 -> see I have that maybe I want a title on
1874.23 -> the side so maybe I wanted to I'll put
1877.86 -> in all to say in billions here and I can
1882.48 -> just start adjusting so make sure my
1885.03 -> charts are coming out the exactly the
1888.54 -> way I want to so you can look at the
1890.429 -> different formatting options if I wanted
1892.559 -> to change it you can hover over so maybe
1895.41 -> if I like this one a little bit better I
1897.12 -> can click on this one and then it's
1899.85 -> adjust adjusted so really simple to
1903.09 -> start some basic charts on this one so
1905.52 -> if I was putting it down below I can
1907.169 -> drag this around and maybe I wanted to
1910.11 -> see what everything was going to look
1911.73 -> like when I print it you can see right
1914.64 -> now uh since I have the chart selected
1916.77 -> that's what it's going to be printed
1918.51 -> right here if I click off of it and go
1920.97 -> to back to my print and now it's the
1924.21 -> whole page right here and now notice
1926.94 -> that I might have to make some
1928.14 -> adjustments because some of the some of
1930.22 -> the information is off the page I'm
1932.02 -> missing some of the years so maybe I
1933.49 -> want to make some adjustments to my
1934.809 -> columns or choose a different type of
1936.909 -> page to print on so this is just your
1939.669 -> kind of your general overview of
1941.289 -> Microsoft Excel for beginner just if you
1943.75 -> haven't used it before in showing you
1945.309 -> some of the power behind it I'm gonna
1946.96 -> have some other some other videos about
1949.27 -> Microsoft Excel to maybe help you
1952.029 -> increase how much you could use and how
1953.799 -> effectively you could use it if you did
1956.2 -> like it they hit that like button give
1958.99 -> me any ideas what you might like to see
1961.12 -> in Microsoft Excel tutorial just write
1963.07 -> it in the comments down below thanks for
1964.99 -> watching this week and I'll see you next
1967 -> time on teachers tech
Source: https://www.youtube.com/watch?v=k1VUZEVuDJ8