Exceed expectations 2010 - PowerPoint PPT Presentation

excel 2010 l.
Skip this Video
Loading SlideShow in 5 Seconds..
Exceed expectations 2010 PowerPoint Presentation
Exceed expectations 2010

play fullscreen
1 / 21
Download
Download Presentation

Exceed expectations 2010

Presentation Transcript

  1. Excel 2010 What’s New? Lisa Friedrichsen Course Technology Author Professor, Johnson County Community College lisalfri@jccc.edu

  2. What’s new in Excel 2010? • Ribbon Enhancement • Backstage View • WebApps – SkyDrive • Paste Preview • Conditional Formatting – Data bars • Sparklines • Slicer • New Functions • SmartArt graphics - Photo Editing

  3. Ribbon Enhancement • File tab! (No Office button) • Backstage view • Create your own tabs and groups

  4. Backstage View • File menu, (Save, Open, New, more…) • Info = permissions, properties, versions • Recent = about 20 • Print = auto print preview • Share = email, PDF, XPS, Fax • Help, Add-Ins, Options (Tools|Options)

  5. Backstage View

  6. WebApps & SkyDrive • Excel Web App = Web-based version of Excel • Edit live data in a workbook by using a browser • Workbook must be stored in a Sharepoint site or in Windows Live SkyDrive • (Windows Mobile 6.5 = smartphone browser)

  7. Sky Drive

  8. Windows Live • Free programs for your PC • Online Web services • Email • Blogging • Photo sharing • SkyDrive • Website home.live.com mhome.live.com

  9. Office Live

  10. Office Live – Web Apps

  11. Paste Preview • preview the data before you commit to pasting the data

  12. Conditional Formatting – Data Bars • New icon sets (stars, boxes, triangles) • Data bars can be negative • Refer to values in other worksheets

  13. Sparklines • Tiny charts that fit in a cell • Visually summarize trends

  14. Slicer • Highly visual way to filter the data in PivotTables • Filter criteria is visible all the time

  15. New Functions • Networkdays vs. Networkdays.Intl • Rank vs. Rank.Eq vs. Rank.Avg • Statistical, engineering improvements

  16. Improved & Renamed Functions

  17. Photo Editing • Screen shots • Picture corrections • Better artistic effects • Better compression and cropping options • SmartArt graphics

  18. SmartArt Graphics • Visual representation of information

  19. SmartArt Graphics • Visual representation of information

  20. Other… • Microsoft SQL Server PowerPivot for Excel Add-in • PivotTable Enhancements, Search box • Table Enhancements, table headers • Better scientific, statistical functions • Enhanced solver algorithms • Charting enhancements (>32K points) • Display equations in text boxes • Accessibility Checker

  21. If time…grading tip • Compassionate, consistent, fair • Save time grading • Teach, don’t judge