Microsoft Excel Basics Tutorial - Learning How to Use Excel. If you have Microsoft Office installed, but have never touched Excel before because you either didn’t know how to use it or didn’t know what it could do for you, then you MUST read this post on learning how to use Excel! Microsoft Excel is a powerful spreadsheet application that can be used for anything from a simple database all the way up to a full fledged Windows application full with windows forms, macros, and add- ons. You can use Excel to calculate a car loan payment, graph data, manage customer records, keep an address book, etc. Excel is currently used by most large financial institutions for daily financial data analysis. It has a huge range of financial functions, formulas, and add- ons that allows you to use Excel to store and analyze data in a simple, quick way. In this tutorial, we’re going to go through the basics of Excel: creating workbooks, using worksheets, entering data, using formulas, etc so that you can become comfortable with the software and begin to learn on your own by playing around with it. First Steps Into Excel. First, let’s open Excel and take a look at the interface of the program. Open Excel and a new workbook will automatically be created. A Workbook is the top level object in Excel. It contains Worksheets, which hold all the actual data that you will be working with. A workbook starts off with three worksheets, but you can add or delete worksheets at any time as long as there is at least one worksheet in a given workbook. Now depending on the version of Excel you are using, the following screen may look completely different. Tutorial using MS Office Word standard toolbar and learning about the icon function buttons; for classrooms or information technology; for career tech classes. If you have Microsoft Office installed, but have never touched Excel before because you either didn't know how to use it or didn't know what it could do fo. FREE Essential System Components + Add-ons. ALL downloads featured here are on my
Microsoft has changed the interface wildly from Office 2. Unfortunately, I have to pick a version to write this tutorial in and I’m currently choosing Excel 2. Office 2. 01. 3 just makes the look more clean, but the overall layout is still the same. ![]() Across the top, you have the Excel ribbon with multiple tabs and also a bunch of little icons at the top in the Quick Access Toolbar. These little icons let you perform very common Excel functions like adding or deleting rows in the worksheet or freezing panes, etc. If you want to customize the ribbon interface, i. Excel, you can do that by clicking on File and then clicking on Options. Now click on Customize Ribbon at the bottom left and you’ll be able to add or remove any possible option you could possibly want. By default, it shows you the popular commands, but you can click on the dropdown to see all the possible options for different tabs. Also, one option I really like is choosing Commands Not in the Ribbon from the dropdown. That way you can easily see which commands are already not on the ribbon and then add any you feel you’ll need. At the bottom of the screen, you’ll see three sheets, named Sheet. Sheet. 2, and Sheet. This is the default number that every Excel workbook starts off with. On older versions of Excel the task pane was located on the right side of the screen, however that has now been removed and all the functions have been moved to the File tab. This is where you can perform many common tasks such as opening a workbook, creating a new one, printing and more. Getting Started with Excel. The best way to learn anything is to actually do something useful and Excel is the best example of this! Let’s say you are a high school or college teacher and you want to keep track of your student’s grades, calculate their average and tell them the lowest grade they would need to get on their final exam in order to pass the class. Sounds like a simple problem and it is (once you get the formula in your head)! Excel can do this for you very quickly, so let’s see how. First off, let’s enter some data into the cells in Excel. In Excel, the columns are labeled starting from A and continuing to Z and beyond. A cell is simply a particular row number and column, i. A1 is the very first cell in an Excel worksheet. Let’s type Students into well A1 and then type A through E as the student names continuing down column A as shown below: Now let’s enter Test 1, Test 2, and Test 3 into cells B1, C1, and D1 respectively. Now we have a 5. Right now our table doesn’t look very nice since the text and numbers are aligned differently and the headers are not visually separate from the data. First, let’s center all the data so that things look nicer. Click on cell A1 and drag your mouse down to cell D6 to highlight the entire data set: Then click on the Home tab and click on the Center Justify button. The grid is now nicely centered with all the data directly underneath the headings. Now let’s look more at how we can format Excel cells. Let’s change the color of the first row to something else so that we can clearly separate the header from the data. Click on cell A1 and drag the mouse while holding the button down to cell D1. Right click and select Format Cells. Now there are two options you have at this point. You’ll notice in the image above, a normal right- click menu that starts with Cut, Copy, etc, but you’ll also notice a kind of floating toolbar right above the menu. This floating menu is kind of a popular options toolbar that lets you quickly change the font, change the text size, format the cell as money or percentage, lets you change the background or font color and add borders to the cell. It’s convenient because you don’t have to open the Format Cells dialog separately and do it there. If you have to do some more advanced formatting not available in the quick toolbar, then go ahead and open the dialog. In this tutorial, I’ll show you the dialog method just so we can see it. In the Format Cells dialog, click on the Patterns tab and select a color from the palette. I chose yellow to make it distinct. Click OK and you’ll now see that the color has been changed for the selected cells. Let’s also add some borders between the cells so that if we decide to print out the Excel sheet, there will be black lines between everything. If you don’t add borders, the lines you see in Excel by default do not print out on paper. Select the entire grid and go to Format Cells again. This time go to the Border tab. Click on the Outside and Inside buttons and you should see the small display box directly below the buttons change accordingly with the borders. Click OK and you should now have black lines between all of the cells. So now we’ve formatted our grid to look much nicer! You can do this type of formatting for your data also in the way you feel appropriate. Using Formulas and Functions in Excel Now let’s get to the fun part: using Excel functions and formulas to actually do something! So we want to first calculate the average grade for our 5 students after their 1st three exams. Excel has an average function that we can use to calculate this value automatically, but we’re going to do it slightly differently in order to demonstrate formulas and functions. Add a header called Sum in column F and Avg in column G and format them the same way we did the other header cells. Now first we’ll use Excel’s sum function to calculate the sum of the three grades for each student. Click in cell F2 and type in “=sum(” without the quotes. The = sign tells Excel that we plan on putting some type of formula into this cell. When you type in the first parenthesis, Excel will display a little label showing you what types of variables this function takes. The word SUM is a built- in function in Excel which calculates the sum of a specified range of cells. At this point after the first parenthesis, you can select the range of cells you want to sum up! No need to type the cells one by one! Go ahead and select cells B2 to D2 and you will see that the formula is automatically updated and is in blue. After you select the range, type in the closing parenthesis (Shift + 0) and press Enter. And now you have the sum of the numbers! Not too hard right!? However, you might say that it would be a royal pain to do this for a set of 1. Well, there’s an easy way to copy your formula automatically for the other students. Learn Microsoft Word Review Tab - MS Review Tab Tutorial . You can have the Spelling and Grammar feature, the Research option, Thesaurus and Translation functionality to help you improve your documents. You can easily check the spellings, punctuation errors and grammar using this tool. Here is the screen shot. The first thing we are going to try is to check the spelling and grammar of a document. You can either click on Change if you would like to accept the suggestion made by Microsoft Word. This amazing feature helps you find synonyms and also antonyms of any specific word. In the following screen shot, I have added a comment that is shown in red. This helps to keep all the comments organized from different authors. Moving onto the next group section which is the Track changes group. We can easily manage additions, deletion, any comments and formatting changes in an efficient manner using this feature. Notice all the revisions are summarized on the left side of the document and broken down into insertions, deletions, etc. OK at times, it is necessary to review different versions off the same document especially if there are several people working on it at the same time. I’m going to compare two Course Syllabi that I have been working on for a class that I am teaching. You can select the Protect Document option under the Protect group. Here is the command shown on the ribbon in Microsoft Word 2. This will launch the Restrict Formatting and Editing dialog box as shown below. I will select the editing restrictions option that is number two and then click on us start forcing protection. In the start enforcing production, I will select password, enter my password and click OK. Create your first document using Word 2. Have you heard the word? Up to speed with Word 2. Web Design Dallas.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |