1 / 30

Microsoft Excel

Microsoft Excel. Microsoft Excel. Excel specializes in creating and designing spreadsheets, or worksheets Worksheet – area to insert data Workbook – a set of worksheets grouped together. Microsoft Excel. By default, 3 worksheets come in each workbook

uriah
Télécharger la présentation

Microsoft Excel

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. Microsoft Excel

  2. Microsoft Excel • Excel specializes in creating and designing spreadsheets, or worksheets • Worksheet – area to insert data • Workbook – a set of worksheets grouped together

  3. Microsoft Excel • By default, 3 worksheets come in each workbook • Named at the bottom of the screen as Sheet1, Sheet2, Sheet3 • Click on to change from sheet to sheet • Right click on Sheet name to • Rename • Insert • Copy • Change Tab color • Move • (you can just click, hold, and move it into the desired location)

  4. Microsoft Excel • Cell – an individual box in a worksheet made up of a row and column intersecting • Each cell has its own properties • Columns are labeled with Letters • Rows are labeled with Numbers

  5. Microsoft Excel • Cell Reference – the cells address on the worksheet • Located in the Name Box (Top Left) • Will contain a Column Letter and a Row Number • Example – A4, B12, C7, D10 • The cell with its address in the name box is the active cell • The cell that data will be inserted into if typed • SELECT ALL - You can make the entire worksheet active by the box to the left of Column A and above Row 1

  6. Microsoft Excel • Each cell has its own properties and can have different: • Fill color • Font color • Font size and name • Horizontal Alignment • Bold, Italics, Underline

  7. Microsoft Excel • Label – Lettered heading that specifies what the data means • Value – Numbered data that appears under a label • Dates will appear as a Formatted Date by default • Example – January 5 will appear as 5-Jan • You can change the format by: • Right-click • Format cells • Select Desired Formatting

  8. Microsoft Excel • To insert data into a cell: • First select active cell • Type numbers or letters into cell • ENTER sets the data into place • To delete data in a cell: • First select active cell • Backspace will erase all cell contents OR • Right click and go to Clear Contents • If you go to Delete, it will delete the entire cell and move all other cells up or over, changing your alignment

  9. Microsoft Excel • To edit data inside of a cell: • Select active cell • Double click to insert cursor in order to edit data • You can single click on the FORMULA BAR to insert your cursor there

  10. Microsoft Excel Formula Bar – Top of worksheet where all cell data editing should take place

  11. Microsoft Excel • Range – A group of cells selected at once • Will be represented by the first cell to click and the last cell to click separated by a colon • Example – A1:B15 C10:H20

  12. Microsoft Excel • Manually Adjust Column Width – Click and hold the divider line between the main column labels • AutoFit – Double click the divider line • Sizes the column to automatically fit to the largest cell in the column • Row height will be automatically adjusted when you change a cell font size

  13. Microsoft Excel • You can insert a row or column by: • Select an entire row or column by clicking on the Column or Row label (Letter or Number) • With the entire row or column selected, Right-click and Go to INSERT • You can combine cells by the icon on the toolbar that says MERGE AND CENTER • < a >

  14. Microsoft Excel FORMATTING DATA • Each cell can have different number formatting, represented by an icon on the toolbar • Money - $ • Percentage - % • Comma – (,) – insert commas • Increase Decimal • Decrease Decimal

  15. Microsoft Excel • Create a Series (Autocomplete) – a numbered list that goes in a predetermined order • Example – 1,2,3,4… or 5, 10, 15, 20…. • To create: • First insert the difference in two cells Ex – 1,2 or 5, 10 • Select both cells • Grab the fill handle in the bottom right corner • The cursor should be a cross with no points • Click and hold, then pull until the series is completed

  16. Microsoft Excel • To cut and paste or to MOVE DATA: • Select the range • Put cursor on the box around the range (Not the fill handle) • Cursor should be a cross with arrows on all 4 points • Click and hold the box, • Drag and Drop it into place

  17. Microsoft Excel • To copy and paste: • Select the range • Right-click and go to Copy • Only make the TOP LEFT cell of the desired location active • Right-click and go to Paste • You can copy and paste by drag and drop by holding down the CTRL key when dragging and dropping • Your cursor arrow will have a small plus to the right of it

  18. Microsoft Excel • To print a worksheet: • Select the range you want to print • Set Print Area • Page Layout > Print Area • Print Preview will allow you to view the set area before you print.

  19. Excel Charts • Excel allows you to create charts out of the data in a worksheet. • Chart types are located under: • 2007: Insert Tab • 2003: Insert >Chart or Chart Wizard Icon

  20. Excel Charts • Types of charts are: • Column • Line • Pie • Bar • Area • Scatter • Stock • Surface • Doughnut • Bubble • Radar

  21. Excel Charts Steps to creating a Chart • Insert data in to worksheet • Data should line up either vertically or horizontally • Labeling data makes the chart easier to read • Highlight data to be included in chart • Select the type of chart to create

  22. Excel Charts - 2007 • Once the chart is created, a CHART TOOLS tab will appear at the top • CHART TOOLS has 3 tabs • Design • Layout • Format

  23. Excel Charts - 2007 Design Can change chart type Reselect data Change chart layout Set Chart Style

  24. Excel Charts - 2007 Layout Chart title Axis titles – Main side titles Legend – key to read the chart Data Labels – Values on each section of chart Data Table – Table at bottom with numerical values Gridlines – Vertical or Horizontal Chart Name – located at Far Right

  25. Excel Charts - 2007 Format Change Shape Styles Word Art Style Change Chart Size

  26. Excel Charts - 2003 • Chart wizard is a 3 step process • Before beginning, specify the range to chart • Step 1 – Select Chart type • Step 2 – Select range (Should be done before) • Step 3 – Format Chart • Step 4 – Chart Location

  27. Excel Charts - 2003 • Step 3, you can customize your chart appearance • Chart title • Axis titles – Main side titles • Legend – key to read the chart • Data Labels – Values on each section of chart • Data Table – Table at bottom with numerical values • Gridlines – Vertical or Horizontal • Chart Name – Chart1, double click to change

  28. Excel Charts • To edit charts, • you can click on the area to change • Right click and select the area to change • To change size of the chart: • Click on the chart, Grab handles should appear on all side and corners • Grab any of the grab handles and resize the chart as desired

  29. Excel Charts • To Move Chart: • Click on the chart, Grab handles should appear on all side and corners • Grab anywhere EXCEPT the GRAB HANDLES and drag and drop it into place

  30. Excel Charts • To Change Location of a chart • Right click and select Move chart • Chart can be moved to a different sheet as an OBJECT IN: • Chart can be inserted in a new sheet, default name Chart1, where you can specify the name of the new sheet by typing it in the box.

More Related