Exceed expectations 2010.

Uploaded on:
SmartArt representation - Photo Editing. Strip Enhancement. Document tab! ( No Office catch) ... Photograph Editing. Screen shots. Picture amendments. Better imaginative ...
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? Strip Enhancement Backstage View WebApps – SkyDrive Paste Preview Conditional Formatting – Data bars Sparklines Slicer New Functions SmartArt design - 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 = consents, properties, versions Recent = around 20 Print = auto print sneak peak 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 gluing 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 outlines that fit in a phone Visually abridge patterns

Slide 14

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

Slide 15

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

Slide 16

Improved & Renamed Functions

Slide 17

Photo Editing Screen shots Picture remedies Better masterful impacts Better pressure and trimming choices SmartArt design

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 investigative, measurable capacities Enhanced solver calculations Charting improvements (>32K focuses) Display conditions in content boxes Accessibility Checker

Slide 21

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

View more...