Microsoft Office 2007 - Excel

1. Microsoft Office 2007 - Excel An electronic document that stores various types of data.

2. Microsoft Office Button • The Microsoft Office Button - • Create a new workbook • Open an existing workbook • Save, save as – know your audience before saving • Will show what is not compatible • Print • Send • Close • The Quick Access Toolbar • Add tools by right clicking • The Mini Toolbar

3. Microsoft Office 2007 - Excel • The Office Button – Excel Options • Customizable options • Popular – mini toolbar, color schemes, default options for workbooks • Formulas – modify calculations work with formulas, check for errors • Proofing – format and correct text • Save – how the workbook is saved, run auto save periodically • Advanced – editing, copying, pasting, printing, displaying, formulas, etc • Customize – add features to the Quick Access Toolbar

4. Microsoft Office Excel 2007 The Excel Ribbon - 7 tabs – (includes commands and groups) • Home Formulas Add-ins • Insert Data • Page Layouts Review

5. Microsoft Office 2007 - Excel The Home Ribbon – common formatting an editing commands The Insert Ribbon – insert common objects, charts, links, images and more The Page Layout Ribbon – layout spreadsheets for printing

6. Microsoft Office 2007 - Excel The Formulas Ribbon – access to different formulas (no memorizing) The Data Ribbon – access external data, sorting and filtering, and managing data The Review Ribbon – proofing and review tools

7. Microsoft Office 2007 - Excel The View Ribbon – different views, and zoom the view The Add-In Ribbon – any add-ins which contains the functions available *Don’t forget you can access the use the keyboard combinations to access the ribbon menu items. Press and hold the ALT key to activate the keys *Dialog Box of Options – additional options available on some Ribbons

8. Microsoft Office 2007 - Excel To Create a New Workbook (a workbook automatically creates 3 worksheets) New Blank Workbook or choose from hundreds of templates • Choose the Office Button and select new to create a new workbook or • Choose Open to select a saved workbook A list of recently opened workbooks will show under Recent Documents Two ways to edit data - double click on the cell and edit directly or click on the cell and change the data in the Function Bar To enter data click the active cell or the formula/function bar

9. Microsoft Office 2007 - Excel Manipulating Data Within the Workbook • Copy and Paste - Cut and Paste – Undo and Redo • Auto Fill – fill a cell or series of data in a workbook into a selected range of cells. Fill in one cell to copy data Fill in the first two cells to auto fill a series *Try to auto fill the days of the week or the months in a year

10. Microsoft Office 2007 - Excel On a new worksheet Enter the following information: Cell Data A5 - READING/ELA A6 - All Students A7- African American A8 - Hispanic A9 - White A10 - Economically Disadvantaged A11 - *Limited English Proficient A12 - *Special Education Formatting the Spreadsheet – • Manually or automatically resize cells • Bold A5 cell contents • Right Justify – cells A6 – A12

11. Microsoft Office 2007 - Excel Enter the following information on the same worksheet Cell Data A13 - WRITING A14 - All Students A15- African American A16- Hispanic A17 - White A18 - Economically Disadvantaged A19 - *Limited English Proficient A20 - *Special Education Using the Format Painter format these cells like the first group

12. Microsoft Office 2007 - Excel Insert Cells, Rows – Columns - Worksheets • Place the cursor in the row below where you want the new row, or in the column to the left of where you want the new column • Click the Insert button on the Cells group of the Home tab • Click the appropriate choice: Cell, Row,  or Column • Right click on the number 13 on Row 13 • Choose Insert Delete Cells, Rows – Columns - Worksheets • Place the cursor in the cell, row, or column that you want to delete • Click the Delete button on the Cells group of the Home tab • Click the appropriate choice:  Cell, Row, or Column

13. Microsoft Office 2007 - Excel • Add the following column heading beginning with B5 – J5 • Grade 3 through Grade 11 - Use the Auto Fill option • Enter the following information:

14. Microsoft Office 2007 - Excel • Formatting Data – Home Ribbon • Cells must be selected to adjust formatting • Several ways to change formatting • Home tab – Cells Group (any text to be formatted must be highlighted) • Try different Cell Styles – notice the Live Preview • Formatting Cells and Worksheet tabs • *Data must be highlighted to change

15. Microsoft Office 2007 - Excel • Calculations and Formulas • Excel FormulasA formula is a set of mathematical instructions that can be used in Excel to perform calculations.  Formals are started in the formula box with an = sign. There are many elements to and excel formula. • References:  The cell or range of cells that you want to use in your calculationOperators:  Symbols (+, -, *, /, etc.) that specify the calculation to be performedConstants:  Numbers or text values that do not changeFunctions:  Predefined formulas in Excel • To create a basic formula in Excel: • Select the cell for the formula • Type = (the equal sign) and the formula • Click Enter

16. Microsoft Office 2007 - Excel • Calculate with FunctionsA function is a built in formula in Excel.  A function has a name and arguments (the mathematical function) in parentheses.  Common functions in Excel: Sum:  Adds all cells in the argumentAverage:  Calculates the average of the cells in the argumentMin:  Finds the minimum value Max:  Finds the maximum valueCount:  Finds the number of cells that contain a numerical value within a range of the argument • To calculate a function: • Click the cell where you want the function applied • Click the Insert Function button • Choose the function • Click OK

17. Microsoft Office 2007 - Excel • The function library is a large group of functions on the Formula Tab of the Ribbon.  These functions include: • AutoSum:  Easily calculates the sum of a rangeRecently Used:  All recently used functionsFinancial: Accrued interest, cash flow return ratesand additional financial functionsLogical: And, If, True, False, etc.Text: Text based functionsDate & Time: Functions calculated on date and timeMath & Trig:  Mathematical Functions • Conditional Formatting – Home Ribbon • Highlight Cell Rules –

18. Microsoft Office 2007 - Excel To view the charts available click the Insert Tab on the Ribbon. • Charts allow you to present information contained in the worksheet in a graphic format. Excel offers many types of charts including: Column, Line, Pie, Bar, Area, Scatter and more.  Create a ChartTo create a chart: • Select the cells that contain the data you want to use in the chart • Click the Insert tab on the Ribbon • Click the type of Chart you want to create

19. Microsoft Office 2007 - Excel Modify a Chart • To move the chart: • Click the Chart and Drag it to another location on the same worksheet, or • Click the Move Chart button on the Design tab • Choose the desired location (either a new sheet or a current sheet in the workbook) or • Right click on the chart and choose Move

20. Microsoft Office 2007 - Excel To change the data included in the chart: • Click the Chart • Click the Select Data button on the Design tab • Adjust the selected data on the worksheet

21. Microsoft Office 2007 - Excel To reverse which data is displayed in the rows and columns: • Click the Chart • Click the Switch Row/Column button on the Design tab To modify the labels and titles: • Click the Chart • On the Layout tab, click the Chart Title or the Data Labels button • Change the Title and click Enter

22. Microsoft Office 2007 - Excel • Convert Text to Columns – Data RibbonSplit data in one cell into two or more cells. Do this by utilizing the Convert Text to Columns Wizard. • Highlight the column to split the data • Click the Text to Columns button on the Data tab • Choose Space check box. Finish the Wizard.

23. Microsoft Office 2007 - Excel • Review - View - Page Layout