EBAOMS EXCEL TRAINING

  Study the spreadsheet below: If you look at Row 1, you'll see that the "Shopping Bill" heading stretches across three cells. This is not three separate cells, with a color change for each individual cell. The A1, B1 and C1 cells were merged. To merge cells, do the following.   Type the words Shopping Bill into cell A1 of a spreadsheet.   Highlight the cells A1, B1 and C1   On the Alignment panel of the Excel Ribbon, locate the "Merge and Center" item:   Click on "Merge and Center". Your three cells will then become one - A1, to be exact!

  Now that your spreadsheet is coming along nicely, you'll want to save your work. To save your spreadsheet, do the following.   Click the File tab in the top left of the excel, This one:   When you click the File tab, you'll see the options list appear:   Click save as then choose Browse then the following dialogue box will appear:   Type your name and then click save to finish save your document.   1.12 CURRENCY SYMBOLS IN EXCEL   Look at the following spreadsheet, which you'll shortly be creating: The C column has a heading of "Price Each". The prices all have the currency symbol. To insert the currency symbol, do this:   Enter some prices on a spreadsheet (any will do) and highlight the cells.   With the cells highlighted, locate the Number panel on the Excel Ribbon bar (on the Home Tab):   Click the drop-down list that says General. You'll then be presented with

  In the previous lesson, you saw how to change the font and font size in Excel. In this lesson, we'll look at how to change the color of a cell.   Change the Background Color of a Cell   To change the background color of cells, you first must highlight the ones you want to alter. We'll start with the cells A2 to A5. So, highlight these cells on your spreadsheet.   With the cells A2 to A5 highlighted, locate the Font panel on the Ribbon at the top of the Excel: (The image below is from Excel) Locate the Paint Bucket and click the arrow just to the right of it. You'll see some colors appear:  Move your mouse over any of the colors and the cells will change automatically. You can then see what the new color looks like. Click with the left mouse button to set the color you want. If you don't like any of the colors displayed, click on "More Colors". Once you have the number cells formatted in a different color, click on the

If you've been following along with the previous tutorials, you should now have a spreadsheet that looks like this: Choosing a Font in Excel   You can pick a different font for the data you enter cells, as well as choosing the size you want. The color of the font, and the cell background, can be changed, too. Themes have been introduced, so that you can format your spreadsheets more easily. You'll meet these later. First, we'll see how to change the font type.   Highlight cell A1 on your spreadsheet by simply clicking into it. Locate the Font panel on the Excel Ribbon at the top of the page:   The font in the panel above is set to Calibri. To see more fonts, click the black down arrow:   The good thing about this Excel is that when you move your mouse over one of the fonts on the list, the text in your selected cell (A1) will change automatically. This is just a preview, though. When y

  You saw that by clicking inside of a cell it makes it active, so that you can make changes. We want to Centre all our numbers and the text. Here's the spreadsheet we have: So, we need cells A1, A2, A3 and A4 to be active. In Excel, you can do this by highlighting the cells.   Place your mouse over cell A1.   Your pointer should now be in the shape of a white cross.   When your pointer changes to the white cross, hold your left mouse button down and drag to cell A4.   Let go of the left mouse button when cells A1, A2, A3 and A4 are highlighted.   The image below shows what you are aiming for.     The cells highlighted in the image above have a different color to the normal white color of a cell. When you highlight cells, you can do things to all the cells as a group.   To Centre the text and numbers in our highlighted cells, try this: From the Excel Ribbon at the

In the previous part, you created a simple Excel spreadsheet. You'll now learn how to edit text in a cell. To change the text in cell A1, you can just click inside of the cell and start typing. Anything you had their previously would be erased. But if you just want to edit the text (if you've made a spelling mistake, for example), then this is no good. If you want to keep most of the text, and just make minor changes, then you need to do something else. In the image below, you can see what's known as the Formula Bar. The Formula Bar is like a long textbox that you can click inside and start typing. Here's what it looks like in Excel: To edit a Cell in Excel, first click inside the cell you want to edit (A1 for us). Then click inside the formula bar. Notice where your cursor is now: The image above shows that the cell A1 is active, but the cursor is inside of the formula bar. With the cursor in the Formula Bar, try changing the text "Numbers" to "Add