1 / 19

Excel Help Index

Excel Help Index. Some of the entries have multiple slides Opening Excel Entering Data Column/Row Manipulation Header and Footer Cut/Paste Creating Borders Charts Insert Image Add, Subtract, Multiply, Divide Averages. Back to Excel Help Index. Excel Document When Upon Opening.

moesha
Download Presentation

Excel Help Index

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Help Index • Some of the entries have multiple slides • Opening Excel • Entering Data • Column/Row Manipulation • Header and Footer • Cut/Paste • Creating Borders • Charts • Insert Image • Add, Subtract, Multiply, Divide • Averages

  2. Back to Excel Help Index Excel Document When Upon Opening

  3. Entering Data Back to Excel Help Index Column Identifier Alpha Entering Data Row Identifier Numeric An individual cell is identified by using the column identifier and the row identifier. This cell’s identity is Column B, Row 5 or Simply D5 Data is entered in individual cells . This data can be in the form of numbers, dates, and text. When data is to be entered in columns it is entered from top to bottom. When the data is to be entered in rows, it is entered from left to right. Once data is entered, formulas can be created to add subtract, average, physics equations, etc. The Rows, Columns and individual cells or groups of cells can be formatted . Clicking on the Column or row identifier select the total column or row. Clicking on an individual cell selects that cell. It is also possible to click on a cel and while holding the mouse button down and dragging a group of cells can be selected. To see the formatting choices click on a row column or cell. View next slide for Formatting choices and procedure. Columns run Vertical The intersection of a row and a Column is a cell Rows run Horizontal

  4. Back to Excel Help Index Column/Row Manipulation 1

  5. Back to Excel Help Index Column/Row Manipulation 2

  6. Back to Excel Help Index Header& Footer X X To select Header and Footer, Go to Insert/Text/Header & Footer The word Header will appear to the upper left of the spread sheet and a text box will be displayed in the center of the page. Anything typed in this space will be center aligned. There is also a hidden text box to the left of the center text box Click here to reveal it. Anything typed in this text box will be left aligned. There is also a hidden text box to the right of the center Click here to reveal it. Anything typed into this text box will be right justified. The Footer data layout is the same as the Header layout. The page number data is usually entered in the right text box in the Footer

  7. Back to Excel Help Index Copy From an Excel Document

  8. Back to Excel Help Index Paste to a Word Document

  9. Back to Excel Help Index Copy from Word Document

  10. Back to Excel Help Index Paste to Excel Document

  11. Back to Excel Help Index Creating Borders

  12. Back to Excel Help Index Chart Selection

  13. Back to Excel Help Index Chart Selection Window

  14. Back to Excel Help Index Chart Creation

  15. Back to Excel Help Index Chart Manipulation Insert Image INSERT IMAGE Inserting an image is similar to inserting an image in Word, go to Insert Tab and Insert Clip Art

  16. Back to Excel Help Index Formulas Adding 1

  17. Back to Excel Help Index Formulas Adding 2

  18. Back to Excel Help Index Averaging 1

  19. Back to Excel Help Index Averaging 2

More Related