Microsoft Office Excel 2003 Tutorials (Sasha Y7)

Microsoft Office Excel 2003 Tutorials (Sasha Y7)

• 1.
  Microsoft Office ExcelTutorial 2007 -For Beginners- Aimina Zalfa Salsabila – Sasha Y7
• 2.
  To Zoom inand Zoom Out • Locate the zoom bar in the bottom, right corner. • Left – click the slider and drag it to the left to zoom out and to the right to zoom in. How to Exploring and Setting Up Your Excel Environment? To Scroll Horizontally in a Worksheet: • Locate the horizontal scroll bar in the bottom, right corner. • Left-click the bar and move it from left to right. To Change Page Views: • Locate the Page View options in the bottom, right corner. The Page View options are Normal, Page Layout, and Page Break. • Left-click an option to select it. To Add Commands to the Quick Access Toolbar: • Click the arrow to the right of the Quick Access toolbar. • Select the command you wish to add from the drop-down list. It will appear in the Quick Access toolbar.
• 3.
  To Minimize andMaximize the Ribbon: *Click the drop-down arrow next to the Quick Access toolbar. *Select Minimize Ribbon from the list. The Ribbon disappears. *To maximize the ribbon, click the arrow again and select Minimize the Ribbon to toggle the feature off. The Microsoft Office Button The Microsoft Office Button appears at the top of the Excel window. When you left-click the button, a menu appears. From this menu you can create a new spreadsheet, open existing files, save files in a variety of ways, and print. You can also add security features, send, publish, and close files.
• 4.
  To Change theDefault Excel Options: *Click the Excel Options button. A dialog box will appear. *Select a category on the left to access different Excel options.
• 5.
  How to makethe Workbook? To Create a New, Blank Workbook: * Left-click the Microsoft Office Button. * Select New. The New Workbook dialog box opens and Blank Workbook is highlighted by default. *Click Create. A new, blank workbook appears in the window.
• 6.
  To Insert Text: *Left-click a cell to select it. Each rectangle in the worksheet is called a cell. As you select a cell, the cell address appears in the Name Box. * Enter text into the cell using your keyboard. The text appears in the cell and in the formula bar. * Each cell has a name, or a cell address based on the column and row it is in. For example, this cell is C3 since it is where column C and row 3 intersect.
• 7.
  How To ModifyColumn Width? (Columns, Rows, and Cells) * Placed the cursor over the column line in the column heading and a double arrow will appear. * Left-click the mouse and drag the cursor to the right to increase the column width or to the left to the column width. *Release the mouse button. * Click the Format command in the Cells group on the Home tab. And a menu will appear. * Select ”Column Width” to enter a specific column measurement. * Then select ”AutoFit Column Width” to adjust the column so all the text will fit. How To Modify the Row Height? * Placed the cursor over the row line you want to modify and a double arrow will appear. * Release the mouse button.
• 8.
  How to insertthe rows? * Select the row below where you want the new row to appear. * Click the ”Insert” command in the Cells group on the Home tab. And the row will appear. How to insert the columns? * Select the column to the right of where you want the column to appear. * Click the ”Insert” command in the Cells group on the Home tab. And the column will appear. (Select the row or columns that you want to delete, and click the “Delete” command in the Cells Group at the Home Tab. If you want to delete)