html5-img
1 / 35

Excel 2007

Excel 2007. What You Should Have Learned about Excel had You Been Paying Attention. Excel 2003 Vs 2007. What’s New?. T he Quick Access Toolbar, MS Office Button, Mini Toolbar & Ribbon.

nora
Télécharger la présentation

Excel 2007

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 2007 What You Should Have Learned about Excel had You Been Paying Attention

  2. Excel 2003 Vs 2007 What’s New?

  3. The Quick Access Toolbar, MS Office Button, Mini Toolbar & Ribbon • The MS Office Button, Quick Access Toolbar and the Ribbon replace the menu, Standard and Formatting Toolbars in Excel 2003.

  4. Quick Access Toolbar • Located next to the MS Office Button, the Quick Access Toolbar offers one-click access to the most widely used office functions. • By default, there are 3 buttons Save,New, and Open. • Click on the arrownext to the toolbar, to open the customize menu • Click the checkboxnext to each feature to add and more options to the toolbar • This is a New Feature

  5. The MS Office Button replaces the File menu

  6. The MS Office Button • The MS Office Button is a New Feature of Excel 2007. • This button is the access point to • Create New Excel Workbooks • Open • Save • Print • Close • This Button replaces the File menu

  7. The MS Office Button • The MS Office Button also houses • Recently opened presentations • Convertconverts Excel files into the 2007 Format • Prepare to finalize presentations for distribution • Send which distributes presentations through facsimile or email • Publishto distribute a presentation to a server or shared workspace • Excel Options (previously located under the Tools menu)

  8. The Mini Toolbar • The Mini Toolbar is a menu of frequently used formatting tools that appears when text is highlighted in a Excel Workbook. New Feature

  9. Menus and Toolbars - 2003 menu Toolbar • In Excel 2003, different functions within Excel are accessed through the Menu Bar,StandardToolbar, the Formatting Toolbar, and the Formula Bar Formula Bar Standard Toolbar Formatting Toolbar

  10. The Ribbon Tabs: 8 tabs representing common related activities Groups: Sections containing Related items or tasks Commands: Buttons, boxes or menus relating to specific functions within Excel Formula Bar: Shows Excel Formulas • Office 2007 is arranged differently. All menus are located within tabs on a menu bar called the ribbon

  11. Key Tips • Key Tipsare shortcuts to tab and menu options on the Ribbon. • Push the alt key to show the Key Tips, then push the corresponding letter on the keyboard to activate the Key Tip. New Feature

  12. The Charts Group • The Charts group: This feature replaces of the Chart Wizard. • Instead of sorting through the Wizard, users choose a Chart Style, this opens the Chart Tools tab, which offers options for Chart Design, Layout & Formatting.

  13. The Chart Design tab • The Type group: Change Chart styles (Step 1: Chart Wizard). • The Data group: Data relationship options (Step 2). • The Chart Layout group: Chart layout options (Step 3). • The Chart Styles group: Color editing options (Step 3). • The Location group: Chart placement options (step 4).

  14. The Chart Layout tab • The Layout tab edits the layout of the chart for such items as: Objects, Labels, Axis, Background and Analysis Properties.

  15. The Chart Format tab • The Format tab offers options for formatting charts including shapes, WordArt, chart arrangement and chart size.

  16. Charts

  17. Charts • Graphic representation of data in a Worksheet • Category labels (descriptive entries) • Data points (numeric data) • Data Points are grouped into Data Series which are represented by the data in a worksheet • In order to create an effective chart, you need to know what you want the char to tell you

  18. Labels and Data Points Category Labels Data Points (each entry) Data Series (All data in row)

  19. Pie Chart • Proportional relationships What percentage of sale is represented by what product? • The total sales is the entire chart • The total sales of each product, as a percentage of sales is represented by a slice of the pie • Pie Carts are best read when there is a limited number (<7) of categories

  20. Exploded Pie Chart • Separates one or more slices of the pie for emphasis

  21. Column Charts • Uses actual numbers rather than percentages • Data represented vertically • Data is according to the X and Y axis

  22. Bar Charts • Data represented horizontally • Data is according to the X and Y axis • Bar charts have the advantage in that their long bars can better accentuate differences

  23. Creating a Chart • Charts can be • Embedded in the worksheet • As a separate chart sheet • Any data change in the worksheet will automatically change the data in the chart • Charts are created using the Chart group

  24. Create a Chart • Open the worksheet Chart • Select A1 through B7 • Click on the Insert tab, and choose Columnfrom the Chart group • Choose3D column

  25. Edit a Chart • This will open the Design tab • In the Data group, click Switch Row/Column • In the Location group, choose New Sheet • The chart is on a separate page

  26. Edit a Chart • On the Layout tab, choose Chart Title from the Label group • Choose a Title Type • Type M & M’s as the title

  27. Edit a Chart • Open the Format tab • Choose Shape Fill from the Shape styles group • Click on the first column of the chart (blue) change the color to red to match the colors listed in the legend. • Colors are chosen by clicking on a colorfrom the shape fill menu • Repeat until chart column colors match the colors listed on the legend

  28. Edit a Chart • Click the Design tab • Click Change Chart Type • Change the chart to a Pie chart • In the Data group, click Switch Row/Column • The chart should look like this

  29. Editing Charts Through the Spreadsheet • Click on cell B7 • Change the quantity ofBrownM&M’s to 10and push Enter • Note the chart changes • Repeat the process and change Blue to 24

  30. Linking Worksheets to Documents

  31. Linking an Excel Worksheet with a Word Document • Click on the M&M Chart • Copy the chart • Open a Word Document • Click Edit and Paste Special

  32. Linking an Excel Worksheet with a Word Document • Click Paste Link • ClickMicrosoft Excel Chart Object • ClickOK

  33. Linking an Excel Worksheet with a Word Document • In Word, Double-click on the sections of the pie of the chart, this will open the Chart in Excel • Change the colors to match the colors of the M&Ms • Save both the Word and Excel documents • Open the Word document

  34. Linking an Excel Worksheet with a Word Document • The worksheet and the document are linked. • If the link is broken by moving one of the items to another location (for example moving the items to another computer), the link must be re-established. • In order to keep both items portable, make sure that the link remains in tact by re-copying and re-pasting after the documents are moved.

  35. Questions? Terence Peak, M.Ed. Coordinator of Technology Training Blackboard Certified Trainer The University of the Incarnate Word (210) 829-3920 tpeak@uiwtx.edu

More Related