230 likes | 459 Views
Excel 2010. What’s New?. Lisa Friedrichsen Course Technology Author Professor, Johnson County Community College lisalfri@jccc.edu. What’s new in Excel 2010?. Ribbon Enhancement Backstage View WebApps – SkyDrive Paste Preview Conditional Formatting – Data bars Sparklines Slicer
E N D
Excel 2010 What’s New? Lisa Friedrichsen Course Technology Author Professor, Johnson County Community College lisalfri@jccc.edu
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
Ribbon Enhancement • File tab! (No Office button) • Backstage view • Create your own tabs and groups
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)
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)
Windows Live • Free programs for your PC • Online Web services • Email • Blogging • Photo sharing • SkyDrive • Website home.live.com mhome.live.com
Paste Preview • preview the data before you commit to pasting the data
Conditional Formatting – Data Bars • New icon sets (stars, boxes, triangles) • Data bars can be negative • Refer to values in other worksheets
Sparklines • Tiny charts that fit in a cell • Visually summarize trends
Slicer • Highly visual way to filter the data in PivotTables • Filter criteria is visible all the time
New Functions • Networkdays vs. Networkdays.Intl • Rank vs. Rank.Eq vs. Rank.Avg • Statistical, engineering improvements
Photo Editing • Screen shots • Picture corrections • Better artistic effects • Better compression and cropping options • SmartArt graphics
SmartArt Graphics • Visual representation of information
SmartArt Graphics • Visual representation of information
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
If time…grading tip • Compassionate, consistent, fair • Save time grading • Teach, don’t judge