1 / 14

MS Excel: Interface

MS Excel: Interface. 2003. 2007. The functionality of MS Excel 2003 and Excel 2007 are similar as far as the lab assignments are concerned.

travisarnold
Download Presentation

MS Excel: Interface

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. MS Excel: Interface 2003 2007 The functionality of MS Excel 2003 and Excel 2007 are similar as far as the lab assignments are concerned. The interfaces are, however, quite different between the two versions of the software. This make Excel 2007 have a significantly new look and feel in comparison to the earlier version. MS Excel 2003 MS Excel 2007 CSE1520 Erich Leung Fall 2009

  2. MS Excel: Interface 2003 MS Excel 2003 CSE1520 Erich Leung Fall 2009

  3. 2007 MS Excel: Interface MS office Button Ribbon Tabs Ribbon Quick Access Toolbar MS Excel 2007 CSE1520 Erich Leung Fall 2009

  4. 2007 MS Excel: Basic Operations Something new to Excel 2007: • Zoom the view. CSE1520 Erich Leung Fall 2009

  5. MS Excel: Basic Operations • Footer and header • Data view and Formula view CSE1520 Erich Leung Fall 2009

  6. 2003 MS Excel: Operations for Submission Set Header and Footer Go to the spreadsheet you want • View • Header and Footer … CSE1520 Erich Leung Fall 2009

  7. 2007 MS Excel: Operations for Submission Adding the header and footer  Insert  Header & Footer CSE1520 Erich Leung Fall 2009

  8. 2007 MS Excel: Operations for Submission Adding the header and footer  Insert  Header & Footer CSE1520 Erich Leung Fall 2009

  9. 2007 MS Excel: Operations for Submission Adding the header and footer  Insert  Header & Footer CSE1520 Erich Leung Fall 2009

  10. 2003 MS Excel: Operations for Submission View formula • Tools • Options … • View • Check Formula (see formulae) Uncheck (see Data) CSE1520 Erich Leung Fall 2009

  11. 2007 MS Excel: Operations for Submission View formulas • Formulas • Show Formulas CSE1520 Erich Leung Fall 2009

  12. 2007 Formatting Cells Format Cell • Home • Format • Format cells … • Number • Or • right click • Format cells… CSE1520 Erich Leung Fall 2009

  13. 2007 Formulae In Excel, Formula/ functions are group into libraries, Depending on the kind of computation they perform CSE1520 Erich Leung Fall 2009

  14. 2007 Formulae If you do not know which group the function belongs to CSE1520 Erich Leung Fall 2009

More Related