MS Excel Interface The functionality of MS Excel

MS Excel: Interface 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 2007 CSE 1520 MS Excel 2007 Erich Leung Fall 2009

MS Excel: Interface 2003 MS Excel 2003 CSE 1520 Erich Leung Fall 2009

MS Excel: Interface MS office Button Ribbon Tabs Quick Access Toolbar Ribbon 2007 MS Excel 2007 CSE 1520 Erich Leung Fall 2009

MS Excel: Basic Operations Something new to Excel 2007: n Zoom the view. 2007 CSE 1520 Erich Leung Fall 2009

MS Excel: Basic Operations n n Footer and header Data view and Formula view CSE 1520 Erich Leung Fall 2009

MS Excel: Operations for Submission Set Header and Footer Go to the spreadsheet you want View Header and Footer … 2003 CSE 1520 Erich Leung Fall 2009

MS Excel: Operations for Submission Adding the header and footer Insert Header & Footer 2007 CSE 1520 Erich Leung Fall 2009

MS Excel: Operations for Submission Adding the header and footer Insert Header & Footer 2007 CSE 1520 Erich Leung Fall 2009

MS Excel: Operations for Submission Adding the header and footer Insert Header & Footer CSE 1520 Erich Leung 2007 Fall 2009

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

MS Excel: Operations for Submission View formulas Formulas Show Formulas 2007 CSE 1520 Erich Leung Fall 2009

Formatting Cells Format Cell Home Format cells … Number Or right click Format cells… CSE 1520 Erich Leung Fall 2009 2007

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

Formulae If you do not know which group the function belongs to 2007 CSE 1520 Erich Leung Fall 2009