Microsoft Excel 2. Home Tab Learn tools to use MS Excel 2. IT Computer training. Home Tab in Microsoft Excel 2. The Home Tab in Microsoft Excel 2. You can do things like formatting, alignment, inserting and deleting rows or columns, sorting and filtering numbers, applying styles and formatting effects, finding and replacing data and much more using the Tab. The Home Tab has the following groups that you can utilize In order to understand some of these commands and functionality, we will be using a Grade Workbook from one of my prior classes. So let us jump right into it and start using the Home Tab in Excel 2. Before we begin here is a screen shot of the student grades data that we will be using for practice. Clipboard Group The first group is the Clipboard and it has commonly used commands like Cut, Copy and Paste. Using these commands you can remove text from one area of your Microsoft Excel sheet to another. When you use the Cut option, it removes the source text. However when you use Copy option, it leaves the source text in place. Using the Paste command, you can then insert the clipboard text into the new location. Using these commands, you can also copy formulas and computed data from one area of the Excel worksheet to another. In our case we have calculated the average of the Midterm test scores in cell E1. Excel training online. Excel training and videos for how to use your Systems2win Excel templates for kaizen lean six sigma continuous process improvement. We will cover how to compute the average in a later lesson. We would like to copy this formula and can use it for the Final test scores also. How do we do that Click on the cell E1. AVERAGEE6 E1. 5 After you have selected the cell, click on copy command in the clipboard group. This is shown in the screen capture. Next we would like to use the same formula for the Final test scores in column H. You can click in cell H1. Paste command from the clipboard group. This will copy the average formula to cell H1. I also went ahead and changed the column width to nine characters or 6. We will cover changing column width in a different Excel tutorial. This is shown in the two screen shots below. Font Group Moving onto the font group, here you can control the font properties of your text. You can use drop down lists to change the font type and font size. You can do actions like bold, italicize and underline text. Let us say that for our Grades Excel Workbook, we need to change the size and font of text Grades for Access 2. Before I do this I need to adjust the first row height to something like 3. The easiest way to adjust row height in Microsoft Excel is to select the row header red circle, right click on the mouse and then select a row height. These steps are illustrated in the figure below. I selected 3. 0 pixels for my row height. Next I went ahead and selected the text in cell A1 and then from Font type drop down chose Arial black. In addition I used the font size dropdown in the Font group to choose size 1. These two actions helped me emphasize the title text of my excel workbook. I have included the screen shot for your review. We would also like to change rows 3 and 4 which include my class assignments, projects and tests headings to maybe Bold. Let us show you the quickest way to do just that. Using the left mouse you can highlight both the rows by selecting the row headers red ovals. Next you can click on the bold button on the font group to highlight the text. This is shown in the figure below where the selected rows are now in Bold. One last thing I want to do using the font group in Excel 2. I want to use a yellow background and change the text to lets say red. In order to achieve this, I need to select the student names from cells A6 through A1. I can either use the mouse or the keyboard to do this. I prefer to use the keyboard so I will click on a A6, hold down the Shift key while clicking on the down arrow one at a time until I have selected all the text. Next I will choose yellow from the background color drop down list. This action is demonstrated below which changed the cells background to yellow. Next I will choose Red from the font color drop down to modify the actual text color. This is shown below in the screen capture. Research Methods And Design In Sport Management Pdf. As you can see our grade book is not looking so plain anymore. So far we have changed font type, font size, bold option, background color and font color in Microsoft Excel 2. If you still need more options to improve your font settings, you can certainly use the dialog box launcher shown by the small red square below. This will launch the Format Cells dialog box which should look familiar from prior versions of Microsoft Excel. Alignment Group We will move onto of the Alignment Group for the next set of exercises. Using the Alignment Group in Excel 2. In my case, I would like to place all the assignments, project, midterm, final test scores in the middle of my cells. This is what needs to happen. Highlight all the text from cells B4 through J1. Next choose the Center command in the alignment tab under the Home Group in Excel 2. This will affect the horizontal alignment and position all the scores in the center as shown below. Very Nice Next I want to use Top Align option under the vertical alignment section for the text Grades for Access 2. Before I do this, Im going to increase the first row height to 4. I imported a few thousand rows of data into Excel and whereas one item represented one row, Ive had to modify each item so that 11 rows represent the same item id. Help for all Office apps. Set up your Office 365 subscription. Find howto articles and video tutorials. Contact our Answer Techs for assisted support. Only for questions on programming against Excel objects or files, or complex formula development. You may combine the Excel tag with VBA, VSTO, C, VB. NET, PowerShell. Leica Programs Leica TPS user guides Link A selection of pdf user guides for the TPS400, TPS700, TPS800 TPS1200. After I have changed the row height, I will go ahead and select the text and then choose Center command from the vertical alignment area. This is what it looks like in action. You can also use the Alignment Group to control some indentation in your excel 2. This functionality is commonly used in word processing like Word 2. We will skip over this option and show you the same effect by using the Merge Center command. The Merge and Center command is a cool feature in Microsoft Excel 2. In the prior versions of Excel, I have struggled with this functionality, not anymore. Lets us take a look at this feature. U9l_FTvNzQs/S-CgW-WPM0I/AAAAAAAAABA/_BX0k3832tQ/s1600/Formulas.jpg' alt='Formula Of Ms Excel 2007 With Example Pdf' title='Formula Of Ms Excel 2007 With Example Pdf' />Notice that the text for Grades for Access 2. I can easily achieve this by using the Merge and Center command. I simply highlight the entire first row from the columns from A1 through L1, then select the Merge and Center command as visible in the figure below. When I performed the above steps, it collapsed all columns into one, center alligned my text giving the heading a nice uniform feel that we desired. Here is what this looks like on my puter screen. The last vital option under the Allignment Tab is Wrap Text. This one is quite beneficial when you have to some long text in an Excel Sheet, however you would like to keep all the contents in one cell, no problem. You will notice on the bottom of my excel sheet, I have text listed This is not the final version. Notice that it spreads across three columns. I would ideally like to wrap this text in one column. I can easily do that using the Wrap Text option, this is what you need to do. Highlight the text and then click on wrap text command button, Boom As illustrated by the following figure, all the text has been wrapped into one cell, PerfectNumber Group The next group that we will talk about is the Number group. Here we have the option to change actual formatting for our data. Lets take a look at the average row which is 1. Observe that the decimal formatting is all jumbled up. We would like to use the number formatting with 2nd place for decimal. I will select the row 1. Number.   This acion fixed the formatting issue for all of our Average scores. Formula Of Ms Excel 2007 With Example Pdf' title='Formula Of Ms Excel 2007 With Example Pdf' />How to Save an Excel Spreadsheet to Look Like a Single Page Using MS Excel. A reader writes From reading the comments on AAM, it seems many of your readers are Excel gurus. I use Excel a lot at work but feel like Im only scratchi. I About the Tutorial Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. Like most of the small businesses, I too use Excel for running various activities including preparing quotations, estimates and pricing models. In this post you.