BASIC EXCEL 2007

1. BASIC EXCEL 2007 Mrs. Macias Computer Science Summer 2008

2. MS EXCEL 2007 • Organize data • Complete calculations • Graph data • Professional looking reports • Publish organized data to the Web • Access “Real-time” data from Web sites

3. 4 MAJOR PARTS OF EXCEL • (1.) Workbooks and Worksheets- • Workbooks are a collection of worksheets • Worksheets – enter, calculate, manimpulate, and analyze data. • Worksheet = spreadsheet • (2.) Charts – Excel can draw many types • (3.) Tables - organize and sort data • (4.) Web Support – save worksheets in html format so can be viewed/manipulated using a browser

4. Project #3 – Worksheet with an Embedded Chart • Overview • Enter text into the worksheet • Add totals to the worksheet • Save the workbook that contains the worksheet • Format the text in the worksheet • Insert a chart in the worksheet • Save the workbook a second time using the same file name • Print the worksheet

5. General Project Guidelines – Excel • (1.) Select titles and subtitles for the worksheet – Remember less is more. • (2.) Determine the contents for rows and columns. • (3.) Determine the calculations that are needed. • (4.) Determine where to save the workbook.

6. General Project Guidelines – ExcelCont’d • (5.) Identify how to format various elements of the worksheet. (Appearance) • (6.) Decide on the type of chart needed. • (7.) Establish where to position and how to format the chart itself.

7. CREATE SHORTCUTS/(ICONS) ON YOUR DESKTOP • START • ALL PROGRAMS • MS OFFICE • WORD – RIGHT CLICK • SEND TO • DESKTOP (CREATE SHORTCUT) • REPEAT FOR EXCEL, POWERPOINT, AND MAVIS 15

8. OPEN UP EXCEL • MAXIMIZE EXCEL • MAXIMIZE WORKSHEET IF NOT ALREADY • When starts it creates a new blank workbook called Book1. The workbook is like a notebook with various worksheets. • Blank workbook has three blank worksheets. You can add more and change the name on the tabs as necessary.

9. PARTS OF EXCEL WORKBOOK • Document Window • Ribbon • Mini Toolbar and Shortcut Menus • Quick Access Toolbar • Office Button

10. WORKSHEET • Organized into a rectangular grid containing vertical columns and horizontal rows. • A column letter above the grid, also called the column heading, identifies each column. • A row number on the left side of the grid, also called the row heading, identifies each row. • The intersection of each column and row is a cell. • Cell reference = coordinates of the intersection of a column and row. For example, cell D11 is located in column D and row 11.

11. ACTIVE CELL • The cell in the worksheet where you currently are located and can enter data. • Excel tells you where you are or the active cell by: • (1.) heavy border around the cell • (2.) active cell referencein the “Name Box.” • (3.) highlighted row and column

12. GRIDLINES • The horizontal and vertical lines running through the worksheet. The gridlines make it easier to see and identify each cell in the worksheet.

13. Mouse Pointer • Looks like block plus sign whenever located in a cell in the worksheet. • Looks like block arrow whenever you are outside the worksheet or drag cell contents between rows or columns.

14. WORKSHEET WINDOW • Normal view – default view • To the right and below the WS are: • Scroll bars • Scroll arrows • Scroll boxes • Tab split box

15. STATUS BAR • Status bar – presents info about the ws, the function of the button the mouse is pointing to, or the mode of Excel. • Mode indicators – Ie. Enter, Ready; appear on the status bar and specify the current mode of Excel • Enter – Excel is in the process of accepting data through the keyboard into the active cell • Ready – Excel is ready to accept the next command or data entry

16. KEYBOARD INDICATORS • Show which “toggle” keys are engaged • For example, scroll lock, number lock, Insert, etc. • Appear to the right of the mode indicator

17. Ribbon • Tabs • Groups • Commands