Introduction to Excel

1. Introduction to Excel Applications of Spreadsheets CT 202

2. What is an Electronic Worksheet good for?

3. An Excel Chart Sheet

4. Loading and Exiting Excel • Highlighting an option in the Microsoft Office program group

5. Loading and Exiting ExcelMicrosoft Office Excel 2003 application window

6. Windows icons Menu bar Name box Formula bar Ask a Question box Standard and Formatting toolbars sharing one row Work Area Task Pane Status bar Components of Excel’s application window

7. Cell pointer Column Frame Area Mouse pointer Vertical scroll box Row Frame Area Worksheet Window Icons Worksheet cell Horizontal scroll box Active sheet tab Inactive sheet tab Tab Split box Tab Scrolling arrows Sizing corner Components of Excel’s worksheet window

8. Displaying a Right-click Menu for a Cell

9. Displaying Menus, Toolbars, & the Task PaneCustomize dialog box: Options tab Customize toolbars Customize Menu bar

10. Displaying Menus, Toolbars & Task PaneStandard Toolbar and Formatting Toolbar

11. Displaying Menus, Toolbars & Task PaneCustomizing the application window Standardtoolbar Task pane Formattingtoolbar

12. Creating Your First Worksheet • You create a worksheet by entering text labels, numbers, dates, and formulas into the individual cells. To begin entering data, • move the cell pointer to the desired cell in the worksheet • type the information that you want to appear in the cell • complete the entry by pressing Enter or by moving the cell pointer to another cell.

13. Moving the Cell PointerDragging the vertical scroll box Keep dragging the vertical scroll box (right) up until Row 24 is visible (as shown at the left).

14. Entering Text and Numbers • Excel accepts two broad types of cell entries: • Constants do not change unless you edit them. • Text values (aka labels) • Numeric values (numbers) • Date and time values • Formulas produce a calculated result, usually based on a reference to one or more cells in the worksheet. • The results of a formula change if you change the contents of a cell referenced in the formula.

15. Entering TextTyping text into the Formula bar Your entry appears in the Formula bar as you type. The cursor or insertion point shows where the next character typed will appear.

16. Entering TextOptions dialog box: Edit tab Select these options to change the behavior of the cell pointer after pressing the Enter key.

17. Entering TextEntering text into a worksheet

18. Entering DatesEntering date values into a worksheet

19. Entering NumbersEntering numbers into a worksheet

20. Entering a Formula • If you start an entry into a cell with an equal sign (=), Excel identifies it as a formula rather than data. • A formula consists of: • arithmetic operators • Include +, -, *, and / for addition, subtraction, multiplication and division. • references to cells

21. Entering FormulasTyping a formula expression into the Formula bar The Expression is built in the Formula Bar. Notice that the blue-highlighted cell address”C3” in the formula expression corresponds with the cell outline immediately above.

22. Entering FormulasEntering formulas into a worksheet

23. Entering FormulasCompleting the worksheet

24. Entering a Formula • The order of the elements in a formula determines the final result of the calculation. • Excel evaluates a formula from left to right according to the order of operator precedence. • Multiplication and division take place before addition and subtraction.

25. Editing a Cell's ContentsDisplaying a new workbook

26. Editing a Cell's ContentsCreating an inventory worksheet Ensure that you type the dollar sign when entering values in the price column

27. Editing a Cell's ContentsPerforming in-cell editing The formula bar is activated for editing as denoted by the appearance of Enter and Cancel buttons The insertion point flashes in the cell when Excel is ready for editing

28. Editing a Cell's ContentsEditing an entry in the formula bar Drag the I –beam mouse pointer from left to right over the letter “M”.

29. Selecting and Erasing Cell ContentsSelecting a group of cells to erase The Name box shows that the active cell is A9, displayed with a white background in the highlighted selection

30. Selecting and Erasing Cell ContentsSelecting cells using the mouse The active cell in this selection is D5, the first selected cell. The Name box shows that four rows (4R) and one column (1C) are currently selected in the worksheet. After clicking cell D5, keep the mouse button depressed and drag the mouse pointer down to cell D8. Once the desired cells are highlighted, you may release the mouse button.

31. Using Undo and RedoSelecting cell A5

32. Using Undo and RedoDisplaying reversible commands There are two actions listed on the drop-down menu that can be “undone” in the worksheet.

33. Getting Help • Excel provides a number of onscreen Help options • Office Assistant (F1 key) • Answers specific questions • Contents • Scroll through topics and related subtopics • Index • Searches on a key word • What’s This? Pointer (Shift + F1) • Displays a description of any feature on the screen.

34. Managing Files Be sure to save your work • Protects against unexpected occurrences that can disrupt your work and/or destroy your file • For important documents, consider saving your file every fifteen minutes • Use a file name that is short, easy to remember, and concisely describes the contents

35. Beginning a New WorkbookDisplaying solutions in the templates dialog box When you choose the “Complete Install” option during setup, Excel 2003 provides the General and Spreadsheet Solutions tabs for organizing your workbook templates .

36. Beginning a New WorkbookNew workbook based on the Sales Invoice template The Sales Invoice template contains a single worksheet tab named “Invoice.”

37. Lists the files that you have most recently worked with The currently selected folder is displayed in the Save in drop-down list box. Excel’s default working folder for storing files The “Advantage” folder is the default folder for storing the student data files . Each folder item represents either a local folder or a shortcut to a remote storage . Lists common desktop shortcuts Provides access to the resources on your computer Enter the workbook’s file name in this drop-down text box Selecta workbook file type from this drop-down list box Lists files and folders stored on your intranet or Internet web server Saving and ClosingSave As dialog box

38. Saving a Workbook • Important to save your work frequently. • Excel automatically stores the file in the default Excel file format (and adds the .xls extension to the filename). • Save a file by selecting in the menu bar: • File, Save • File, Save As

39. Closing a File and Exiting Excel • Choose • File, Close • The current workbook closes after Excel asks if you want to save your work (if you haven’t already.) • File, Exit • Excel closes after asking if you want to save your work.

40. Saving and ClosingNavigating the storage areas using the save-in drop-down list box Along with the resources shown in the My Computer list area, the Save in drop-down list box provides access to other storage areas, such as “My Network Places” and FTP locations.

41. Saving and ClosingThe Program Files folder of the author’s hard drive (C:)

42. Opening an Existing Workbook • After you create and save a workbook, you can reopen the workbook and resume working with its data. • To open a file quickly from the Open dialog box, double-click the file’s icon in the list of files. • If you double-click the filename, you might end up in Rename mode.

43. Opening - Existing WorkbookViewing the student data files for Microsoft Office Excel 2003 tutorial

44. Opening -Existing WorkbookOpening the EX0143 workbook

45. Creating a Workbook FolderCreating a new folder in the Save As dialog box