What are the basics in Excel?
Welcome to this Excel Basics Blog Tutorial In this tutorial I will show you the most basics you need to know to get started using Microsoft Excel will show you the most basics you need to know to get started using Microsoft Excel. What you need to know The version of excel that i am going to use in this tutorial is excel 2016 [for] windows says that if you are using a different version of excel maybe an older version or even That a newer version or if you use Excel on a Mac there will be some minor differences but for the most part I would say that 95% of what it shows in this tutorial will be very applicable to you and your use of Excel so I recommend Excel and the icon here to start using excel now i want to like [it] wants to know if i want to open excel template or just open a blank workbook [you can see] that There are many templates to choose from.
This [a ]Welcome to the Excel Tour and it's a great way to learn some of the basics of Excel but that's why you're watching my video, so I'm going to leave that to that is Cash Flow Analysis. Email Insights is a sales invoice that has stock symbols. Here is a budget. Here it is: A Family Budget There are all kinds of great Excel spreadsheets that you can open up and start using the data that way. So I encourage you to browse and explore these templates that are available to you. In addition to the 30 or so templates [available] there's an option to find templates online, so I'm going to do a budget search and you can see that it's even more budget, you just have a family budget.
There's a whole bunch that you can choose from [from] the above categories that you can go through and you can choose the specific type of budget or spreadsheet template you want to use if you need that. It looks like the one you want to use so you can just click on it click on create and it will create a copy of that as a spreadsheet that you can open in excel and use so please take some time to explore Spend in What is available and in many cases most of the work has already been done for you? You can use someone else's template and adjust to what you need now.
Templates are very useful but having said that I really think to learn to use excel completely and properly. It's best to start with a blank workbook [so] I'm just going to click [on] [that] to select a blank workbook and open it and the first thing we need to do is in Excel 2016 We have got to know about layouts, there are certain terms that you will need to know At the very top we have a few tabs, well, we have the Home tab Insert Tab Page Layout and the more you can do with each of these tabs As you can see, that's very important. When you click on a particular tab it opens a ribbon, right? This is the ribbon for the Home tab [if] I click on the Page Layout tab I get the Page Layout ribbon Now each ribbon is divided into groups so you can see I have a Theme group.
I have a page setup a scale group to fit group and all these page layouts are on the ribbon and I go to that ribbon by clicking on the page layout tab then those are some key words you will need to know the tab ribbon group And you'll see some of these groups in the corner [there] I like to call the launch button, right? So the scale to fit group has a little launch button in the corner, the sheet options group has a lunch button in the corner Arrange group doesn't seem to have one these launch buttons basically you can click on those launch buttons so that Can you give you more [options]? [So] [What has Microsoft done? Have they tried to fit all of the page layout options on this ribbon, but of course there is a limited amount sometimes they can't and if they can't do a launch button that you can click to get even more why are some launch buttons some not [OK]? I think it's important to start with that terminology [because] I'm going to use it correctly [throughout] this tutorial [all] the layout terms you'll need to know in the spreadsheet itself.
This spreadsheet is made up of spreadsheets and columns and rows [ok] so you can see that we have column AB column C column ETC, and if I browse to the right, ok, you can see it [there] There's more to it, and it's going to the right of adding more and more columns if needed ok once it gets to Z it goes to AA column A and so on and so many columns in this spreadsheet Now what about roses? [i] row number one row number two row number three OK, so the spreadsheet is now made up of columns and rows [intersection] one column and onerow is what produces a cell so it is a cell and every cell in excel has a name ok this particular cell name is c2 and you can imagine how i got this name it is just the intersection of the columns and [row] this particular cell is named here M9 and it is [I-16] Now this may seem obvious and unimportant but it is actually [very] exciting and powerful that every cell in Excel has its name because [It] has a name that you can describe it and you can excel some things with the content in each cell. We'll be okay after a while?
Now columns are another part of a spreadsheet besides rows and cells that you need to know and that is a range Ok now a series is a group of cells that together can be a range This could be [this] Maybe it could be any thing. It's basically a group of cells that are next to each other to guess and guess? Ranges can also be named cells like it's named L7 And you name the cell on the [upper] left? So this is L7 and then you say words like this through L7 and then you say the name of the cell in the lower right 12 then N through L7. 12 This is the name of this range? Now in the back of your mind just explain how to write the name of this range, you would write l through 7 there is a colon through the symbol and then you would put n 12 so this is the name of the range you see here how to write OK, I'm going to run out of this because I really want to type in a cell so that was some background information you really need to use Excel correctly that we've covered in the layout of the ribbon.
and talked about tabs and groups and things also the spreadsheet itself contains cells and ranges rows with columns and really I should add something else you can see it's all on one sheet sheet and I'm on a sheet2 can add sheets 3 etc each of these sheets are added together which makes a workbook so that sheets or worksheets can be combined workbook ok now we all have that as a foundation let's put to our excellent use now To actually start building and working on the Excel spreadsheet
it a little more interesting so I'm going to use this slider in the lower right corner, [and] I'll just click and drag on my spreadsheet to zoom in. OK so that was it to see. It should be easy and now I'm going to click on one and enter some data in this data and as an example let's say I want to use excel to make a list of my movie collection [OK] If you're a teacher it could be anything. Maybe it's the supplies that you make.
Do you give loans to students or if you're a secretary at a school, let's say you're in charge of keeping track of the supplies at the school. but let's say I want to do a list of movies that [I] first want to do is maybe put a little title in there so I'm going to type in one and I type movie list and you'll see that my text is bigger than the cell, it goes too far to the right but you know don't worry about that just [hit] enter or return on the keyboard and i put my first data This spreadsheet has been successfully entered. It seems that the movie list of these words is spreading from A1 to B1 but in reality this is not true. The order is if both of these words are stored in A1 If I click on B1 [I] can type in B1 and hit return or enter and you will see that the movie inventory is still in A stored in 1 [ok] so they don't interact they don't interfere with each other so no need to worry your text is too wide to fit in 1 but saying so sometimes- Ever create your spreadsheet. Feeling good really helps you to use it better.
So let's talk about how can I fix it it's not really a problem but if I want to make it look a little nicer how can I fix it? well what can i do if i want to put my mouse then i can span any column or any row between any two column letters so this is column a column b put my mouse on the line two to the right or its hold very close and you will see that my mouse cursor changed to a double sided arrow, that's a good sign so now i can click and drag to make it wider Inventory was entered and I pressed enter or return it automatically moves me down in excel when you tap [enter] or tap back If you want to move the spreadsheet up you go to the spreadsheet You can hold shift and enter or return and it will go on, [okay]? then enter or shift return shiftenter or come back moves down what if you want to go to the right maybe i want to type something in b1? what i would do i tap tap tab takes you to the right so i can enter more text in there and then tap tab and enter more text there and if you want to move left just keep tabbing? [I] bet you can guess what it is.
You would tap shift and tab so that shift is basically used for the opposite whatever it would be otherwise, so return enter is normally down shift -Enter is Return Up Tab Right Shift is Left on Tab Another way you can navigate in a spreadsheet is by using the arrows on your keyboard [if] you get [up/down] [left/right] Arrows you Can just use those to move left or right down? It's a little more awkward than using enter or shift entry but it's another option and of course you can use your mouse to click where you want to go? But I'll let you know if you can learn to use excel with keyboard without using your mouse it's actually going a lot better for you. So [now I've] got my title I'm going to click on two and I'm going to type in the word title.
That's where I'll put the movie title now I'll tap the tab to go to the right and I'll put in the purchased date again tab tab again rating again price tab style and then tab location and it's in my movie Inventory [all] right with that last person I took it down when I entered, and it moved to the left I hope to put in the first record what they call it and The first record would be the first so let's say I put in star [war] again I could tap tab to go to the right I bought it 2007. It's rated PG It's worth $5 and it's science fiction and it's located in the [living] room OK so this is an example of data entry on a cell either way [by clicking] or on a cell How to enter [data] in a spreadsheet? typing and then hitting tab to go right or now enter to go down as in another example I'm going to write in another record, and I'll put some other information here and at this point let's say I see a misspelled word, and I want to fix it. What happens as I type? what was there? Ok? The reason why? When I clicked on that cell when you click on a cell what do you replace? What has already been removed? It replaces what's in there and then whatever you type.
So there's a distinction I have to tell you that there's a difference between being on a cell and being in a cell. You have to double click on it to go to [OK] Note that [happens] when I enter [that] cell I double click on it really jumped me inside the cell and now i have a cursor it's flashing and i can click or i can use the arrow keys to move the cursor where i want to do so so the cell Being in a cell in this case, I don't want to be on the cell. I don't want to replace all the text in this cell. I want to quick click twice now I've jumped inside it and I have this cursor and I can move it where I want to fix it misspelling hit return that may seem a lot small insignificant thing but excel is all about the details and all these little details will really increase the usage of excel so please bear with me and pay attention [attention] to these details and i promise to use excel more and more will be satisfactory and effective give me a few minutes to give some more records, and then i will resume the tutorial so i put some movies [here] and some records are what is called a record each of these lines and it helps you see a little better Make up just doesn't look quite right to our eyes at this point so what are some things that What can I do to make this look better?
Basically I have the top of this spreadsheet at the top it's kind of to the side, and there's nothing in it that makes it stand out and look different so I'm going to click it on the cell I'm on in the home ribbon. going to click [here] at the top on the home tab i can click on bold to give it a bold look so that will help out I can't do that in this case I don't necessarily have to click on the arrow next to it and I'll be thereThe color of the text can also change without going to any fill OK, so that's also an option. I'm also going back to black in this case.
I could italicize or underline those are all good options but that would make the text stand out a bit another thing I can do is click on cell A1 and drag I'm still mouse clicking, and until I click I'm going to drag until it doesn't cover all the contents of my spreadsheet so the content of this spreadsheet ends up at column F I don't have anything beyond that so I just clicked and dragged to get all the way Now let's see what I can do on the Home tab Home ribbon Here is a button [Align [Group] called Merge and Center and if I click on it see what it got by merging all those cells together It's a big cell now and it's [centered], right? So the Merchant Center is very helpful in doing what I [just] basically did to break down the walls of these cells and make it one big cell and then center it which is what I said earlier that's a lot of the other thing. looks better The text doesn't quite fit which bothers me so I could go to the top as I showed earlier and click to make sure everything fits but I want you to see the shortcut To do this you have a shortcut all you have to do is go to the top just go between one of the column letters and double click and if you do this what happens is automatically the column completely will be sized so that all will fit,
I can do the same for the date purchased as for the rating now notice in that case the rating column is really narrowed this is because it is now more likely to be Not required, [okay]? So I can do it with value and so forth. let me show you one more trick it's a bit of a time-saver instead of [double-clicking] between each column time look what i can do is click and drag all the way on the column letters of my data end and then double click between any two of these it doesn't matter [double-click] and now note that it automatically replaces each column with the column that I [selected] affected by that double click was and is now perfectly sized to the content in those cells, and if I browse back to the left using this slider you can see that everything is perfectly sized That's why I used a phrase there I said every column that was selected was what I did in excel that's a good phrase to think about the selection of [effect] if you want it to affect Is.
you have to select it first when you click and drag those column headings then another little shortcut little trick yes the fastest way to resize is then double click between any two column headings but you can click alternately Can and pull and see what [happens]. I'm going to resize the columns and let each column be affected because I selected each one affected by that and they are all exactly the same width so hopefully those little tricks will help you be able to have your columns resize it in a way that makes the most sense to you and the idea is to make your data look good because when it looks good it's often easier to read properly and easier to understand now sometimes the columns There are good reasons to narrow down even if all the text doesn't fit so you don't always have to make sure everything is always visible but I want you to be able to do that when you need to [OK] next time. ] need to be done I think I want to click here on the movie list and to separate it as title underline it and then below I want to separate all these column names then I will highlight them And I'll go up and make them bold and let's italicize
it now I've done so fast that you may not have noticed i just clicked on the row number and it highlighted the whole row all the way to the right and so selected it and to effect it i just chose bold and italicize and at this point all selected I hope you are now familiar with the different names of layouts in Excel. We know how to call different things like Group Ribbon Things as we also know Columns Rows and Range Sheets and Workbooks. rows and we know how to enter data and then how to select it to affect how it looks and choose to change how it looks on the screen and we also know how to adjust column widths and I've done it Didn't show that clearly so let me just do it right now note that you can affect rows too then i can make rows otherwise more than they are i can totally double click between them to resize I want to select multiple rows from one at a time can influence more, so all those techniques i showed Columns can also be used with rows, so in my opinion this all gives you a good foundation. It helps you understand the basics of using excel in a future video.
I will show you some intermediate excel. Tips and Tricks' Ways That Can Save You Time and Effort When Creating Your Spreadsheets [we] will also cover formulas and functions and this is really where most of Excel's power is found and I'll throw in some advanced Excel tips as well. More tricks, so please watch for that future video. Thank you for watching this excel basics video I hope you enjoyed it and [please] consider subscribing to my youtube channel Technology for Teachers and Students and also watch for a new video at least every Monday i hope you follow me on twitter facebook tumblr and other social media so i hope you follow me on these social media platforms and we can continue to learn together
No comments: