Exceed expectations 2010 .


45 views
Uploaded on:
Category: Medical / Health
Description
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
Transcripts
Slide 1

Exceed expectations 2010 What\'s New? Lisa Friedrichsen Course Technology Author Professor, Johnson County Community College lisalfri@jccc.edu

Slide 2

What\'s new in Excel 2010? Lace Enhancement Backstage View WebApps – SkyDrive Paste Preview Conditional Formatting – Data bars Sparklines Slicer New Functions SmartArt representation - Photo Editing

Slide 3

Ribbon Enhancement File tab! (No Office catch) Backstage view Create your own tabs and gatherings

Slide 4

Backstage View File menu, (Save, Open, New, more… ) Info = authorizations, properties, versions Recent = around 20 Print = auto print review Share = email, PDF, XPS, Fax Help, Add-Ins, Options (Tools|Options)

Slide 5

Backstage View

Slide 6

WebApps & SkyDrive Excel Web App = Web-based adaptation of Excel Edit live information in an exercise manual by utilizing a program Workbook must be put away in a Sharepoint webpage or in Windows Live SkyDrive (Windows Mobile 6.5 = cell phone program)

Slide 7

Sky Drive

Slide 8

Windows Live Free projects for your PC Online Web administrations Email Blogging Photo sharing SkyDrive Website home.live.com mhome.live.com

Slide 9

Office Live

Slide 10

Office Live – Web Apps

Slide 11

Paste Preview see the information before you focus on sticking the information

Slide 12

Conditional Formatting – Data Bars New symbol sets (stars, boxes, triangles) Data bars can be negative Refer to values in different worksheets

Slide 13

Sparklines Tiny diagrams that fit in a phone Visually compress patterns

Slide 14

Slicer Highly visual approach to channel the information in PivotTables Filter criteria is noticeable constantly

Slide 15

New Functions Networkdays versus Networkdays.Intl Rank versus Rank.Eq versus Rank.Avg Statistical, designing upgrades

Slide 16

Improved & Renamed Functions

Slide 17

Photo Editing Screen shots Picture revisions Better creative impacts Better pressure and trimming alternatives SmartArt illustrations

Slide 18

SmartArt Graphics Visual representation of data

Slide 19

SmartArt Graphics Visual representation of data

Slide 20

Other… Microsoft SQL Server PowerPivot for Excel Add-in PivotTable Enhancements, Search box Table Enhancements, table headers Better logical, factual capacities Enhanced solver calculations Charting upgrades (>32K focuses) Display conditions in content boxes Accessibility Checker

Slide 21

If time… evaluating tip Compassionate, reliable, reasonable Save time reviewing Teach, don\'t pass judgment

Recommended
View more...