excel 2010 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Excel 2010 PowerPoint Presentation
Download Presentation
Excel 2010

Loading in 2 Seconds...

play fullscreen
1 / 21

Excel 2010 - PowerPoint PPT Presentation


  • 351 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Excel 2010' - Antony


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
excel 2010

Excel 2010

What’s New?

Lisa Friedrichsen

Course Technology Author

Professor, Johnson County Community College

lisalfri@jccc.edu

what s new in excel 2010
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
Ribbon Enhancement
  • File tab! (No Office button)
  • Backstage view
  • Create your own tabs and groups
backstage view
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
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
Windows Live
  • Free programs for your PC
  • Online Web services
    • Email
    • Blogging
    • Photo sharing
    • SkyDrive
    • Website

home.live.com

mhome.live.com

paste preview
Paste Preview
  • preview the data before you commit to pasting the data
conditional formatting data bars
Conditional Formatting – Data Bars
  • New icon sets (stars, boxes, triangles)
  • Data bars can be negative
  • Refer to values in other worksheets
sparklines
Sparklines
  • Tiny charts that fit in a cell
  • Visually summarize trends
slicer
Slicer
  • Highly visual way to filter the data in PivotTables
  • Filter criteria is visible all the time
new functions
New Functions
  • Networkdays vs. Networkdays.Intl
  • Rank vs. Rank.Eq vs. Rank.Avg
  • Statistical, engineering improvements
photo editing
Photo Editing
  • Screen shots
  • Picture corrections
  • Better artistic effects
  • Better compression and cropping options
  • SmartArt graphics
smartart graphics
SmartArt Graphics
  • Visual representation of information
smartart graphics19
SmartArt Graphics
  • Visual representation of information
other
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
If time…grading tip
  • Compassionate, consistent, fair
  • Save time grading
  • Teach, don’t judge