ITEC 1050 - Using Excel: Lab 1

Using Excel: Getting Started

• An .xls file = a workbook, worksheets; Alows you to edit and format data in tabular format, use formulas and functions to analyze data and create charts.
• Parts of the excel window: title bar, menu bar, toolbars (standard and formating), formula bar, cell, column, row, active cell, worksheets tabs, scrollbars, task pane
• Active cell: setting the active cell, cell reference
• Scroll through a worksheet
• Entering data: use arrow keys or mouse to select the active cell and then type the data
• Cell data which is too long: string of characters or number.
• Autocompletion: matching data in another cell in the same column
• Select one cell; select a rectangle of cells: with the mouse or with the keyboard (SHIFT); select multiple rectangles of cells (CTRL); select all cells in the worksheet; select data in a cell (mouse or keyboard); select a row (column); select a block of rows (columns); select multiple blocks of rows (columns).
• Fill in a series: months, numbers, dates; Autofill options: copy cells, fill series;
• Browse through the worksheet tabs
• Rename a worksheet tab
• Insert/delete a worksheet: menu, right-click
• Reorder worksheets

Using Excel: Save and Open a Workbook

• Save a workbook: Save command and Save As Dialog
• Create a new workbook;switch between opened workbooks: window menu or the TaskBar
• Open a workbook; Open Dialog; Open a recently open workbook: on File menu or in the Task Pane; Close a workbook.
• Compare workbooks side by side
• Email a worksheet