1 / 6

Corinne Hoisington

Microsoft Excel 2003 for the Technology Instructor’s Soul. Understanding what’s new for you… and for your students. Corinne Hoisington. Adding Lists. Improved list functionality helps you structure worksheet data Easier to perform list arithmetic and statistical calculations

odessa
Download Presentation

Corinne Hoisington

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 2003for theTechnology Instructor’sSoul Understanding what’s new for you… and for your students Corinne Hoisington

  2. Adding Lists • Improved list functionality helps you structure worksheet data • Easier to perform list arithmetic and statistical calculations • Auto filter drop downs (Sorting) • Blue Asterisk * to insert row to list • Total Row

  3. Great Grade Book Functionality • The “Adding Lists” feature will help us as faculty to quickly design a grade book • Add students very easily without redoing formulas • Find the class Average, High/Low Grades

  4. Compare Worksheets Side by Side

  5. Side by Side Benefits • Side by Side Panes make it easier for you to grade student assignments when you can see the ‘key’ right next to their work.

  6. BINOMDIST CHIINV CONFIDENCE CRITBINOM DSTDEV DSTDEVP DVAR DVARP FINV FORECAST GAMMAINV GROWTH HYPGEOMDIST INTERCEPT LINEST LOGEST LOGINV LOGNORMDIST NEGBINOMDIST NORMDIST NORMINV NORMSDIST NORMSINV PEARSON POISSON RAND RSQ SLOPE STDEV STDEVA STDEVP STDEVPA STEYX TINV TREND VAR VARA VARP VARPA ZTEST Improved Statistical Functions Precision Improved

More Related