Transcript PPTs used for this seminar

Getting Up to Speed with Microsoft Office:
Excel 2010
Lynn Mann
May 12, 2011
For audio call Toll Free 1-888-886-3951
and use PIN/code 979827
Housekeeping
• Maximize your CCC Confer window.
• Phone audio will be in presenter-only mode.
• Ask questions and make comments using the chat window.
Adjusting Audio
1) If you’re listening on your computer, adjust your volume using
the speaker slider.
2) If you’re listening over the phone, click on phone headset.
Do not listen on both computer and phone.
Saving Files & Open/close Captions
1. Save chat window with floppy disc icon
2. Open/close captioning window with CC icon
Emoticons and Polling
1) Raise hand and Emoticons
2) Polling options
Getting Up to Speed with Microsoft Office:
Excel 2010
Lynn Mann
Poll: Which Version of Office are
you Using Now?
A. Office 2010 (Windows)
B. office:mac 2011 (Mac)
C. office:mac 2008 (Mac)
D. Office 2007 (Windows)
E. Office 2003
7
Poll: What is your Role on Campus?
A. Faculty
B. Staff
C. Administrators
D. Other/Not Sure
8
What Excel 2010 Brings to the
Table
Bring Ideas to
Life!
• Express ideas, solve problems, create amazing results
• Find more with Office’s Backstage view and Fluent UI
• At site and dynamic graphical representation of data
Work Flexibly
from
Anywhere!
• Work from virtually any place, device with Web Apps
• Use your Mobile Phone easily when on the go
Work Together
9
• Connect with People and Social Networks
• Work together effectively with co-authoring
Bring Ideas to Life!
10
Find more with Fluent UI
New in 2010: Consistent Across
Apps and Fully Customizable
11
Find more with Backstage View
12
Streamlined Printing
13
Demo: Backstage and Ribbon
Customization
 No more beach ball (Office Button) – File
(Backstage View) is back!
 Manage document options
 Create a New Tab
Making the Ribbon Mine
Visit Technet Blog
14
Paste with Live Preview
 Contextual paste options that allow
preview before commitment
15
Picture Editing Tools





Screenshots
New SmartArt graphic layouts
Picture corrections
New and improved artistic effects
Better compression and cropping
Description and list of
SmartArt graphics
Visit Microsoft Office
16
Chart with Sparklines
 A sparkline is a small intense, simple, word-sized
graphic with typographic resolution. -- Beautiful
Evidence, Edward Tufte, May 27, 2004
17
Demo: Pictures and Sparklines
 Add Sparklines to data
 See picture tools in action
Use Sparklines to show
data trends
Visit Microsoft Office
18
Pivot Tables Enhancements
 Repeating labels
 Show Values As
 Interactive controls in a PivotChart
19
Filter with Slicers
 Visual controls that allow interactive filter
of your data
20
Conditional Formatting Options
21
Demo: Sparklines and PivotTables
 Add Sparklines to data
 Add repeating labels and Show Value as
 Add slicer
Create Super PivotTables in
Excel with “Slicer”
Visit Technet Blog
22
Work Flexibly from Anywhere
23
Excel 2010 Web App
Excel Web App
•
•
•
•
Excel ‘Lite’ - View, create and edit documents with the familiar Excel
interface
Available via Windows Live, SharePoint Online, and SharePoint
Access documents from virtually anywhere
Share and work with others online
Source: Microsoft http://educationwebcasts.com
Key Features of Excel Web App
WORK
TOGETHER
USE OFFICE
ANYWHERE
Easy Sharing
Easily share documents in password-protected folders and
assign view only or view and edit permissions to those shared
with. Additional option to share with everyone (no password
required).
Co-authoring
Excel Web App and OneNote Web App enable multiple people to
edit a document at the same time from within the browser.
Cross-platform Support
IE, Firefox, and Safari browsers are supported.
Publish
Excel content and PowerPoint presentations can be published to
blogs and other web sites and will be updated in those locations
when the original document is changed.
Create and Edit
Basic editing, e.g. text changes, formula edits, some formatting
changes are supported.
High Fidelity Viewing
Office documents will render in the browsers, including mobile
browsers, just like they do in the client, without formatting or data
loss.
Integration with
Office 2010
Save to the SkyDrive/ Open from SkyDrive directly from within the
Office 2010 client applications on your computer (via Backstage)
Office Round-tripping
Maintain data and document formatting when moving between
Office client and Office Web Apps.
Source: Microsoft http://educationwebcasts.com
Office 2010 Mobile
 Touch friendly user interface
 Sync with Sharepoint 2010
Mobile
 High Fidelity Editing
26
Save & Send
27
Demo: Access, Edit and Share Files
on the Web
 Save to Skydrive
 Edit in Web App
 Share File with User
25 GB FREE Storage
Visit skydrive.live.com
28
Work Together
29
Co-Authoring
 Simultaneously Edit in Excel, web app
Learn More
Co-Authoring Webcast
30
Additional Resources




31
Excel 2010 Resources: http://bit.ly/a2DMvG
Office Mobile Overview: http://bit.ly/lhUF3H
Office Web Apps: http://bit.ly/91qbKj
Skydrive: http://bit.ly/cYxTZn
Q&A
Lynn Mann
Additional Questions? Email me at [email protected]
Evaluation Survey Link
Help us improve our seminars by filing
out a short online evaluation survey at:
http://www.surveymonkey.com/s/Sp11_Excel2010
Getting Up to Speed with Microsoft Office:
Excel 2010
Thanks for attending
For upcoming events and links to recently archived
seminars, check the @ONE Web site at:
http://onefortraining.org/