Getting Up to Speed with Microsoft Office: Excel 2010

1. 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

2. Housekeeping • Maximize your CCC Confer window. • Phone audio will be in presenter-only mode. • Ask questions and make comments using the chat window.

3. Adjusting Audio • If you’re listening on your computer, adjust your volume using the speaker slider. • If you’re listening over the phone, click on phone headset. Do not listen on both computer and phone.

4. Saving Files & Open/close Captions • Save chat window with floppy disc icon • Open/close captioning window with CC icon

5. Emoticons and Polling • Raise hand and Emoticons • Polling options

6. Lynn Mann Getting Up to Speed with Microsoft Office: Excel 2010

7. Poll: Which Version of Office are you Using Now? • Office 2010 (Windows) • office:mac 2011 (Mac) • office:mac 2008 (Mac) • Office 2007 (Windows) • Office 2003

8. Poll: What is your Role on Campus? • Faculty • Staff • Administrators • Other/Not Sure

9. What Excel 2010 Brings to the Table

10. Bring Ideas to Life!

11. Find more with Fluent UI Ribbon New in 2010: Consistent Across Apps and Fully Customizable

12. Find more with Backstage View

13. Streamlined Printing

14. 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 TechnetBlog

15. Paste with Live Preview • Contextual paste options that allow preview before commitment

16. 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

17. Chart with Sparklines • A sparkline is a small intense, simple, word-sized graphic with typographic resolution. -- Beautiful Evidence, Edward Tufte, May 27, 2004

18. Demo: Pictures and Sparklines • Add Sparklines to data • See picture tools in action Use Sparklines to show data trends Visit Microsoft Office

19. Pivot Tables Enhancements • Repeating labels • Show Values As • Interactive controls in a PivotChart

20. Filter with Slicers • Visual controls that allow interactive filter of your data

21. Conditional Formatting Options

22. 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 TechnetBlog

23. Work Flexibly from Anywhere

24. Excel 2010 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 Excel Web App Source: Microsoft http://educationwebcasts.com

25. Key Features of Excel Web App Source: Microsoft http://educationwebcasts.com

26. Office 2010 Mobile • Touch friendly user interface • Sync with Sharepoint 2010 Mobile • High Fidelity Editing

27. Save & Send

28. 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

29. Work Together

30. Co-Authoring • Simultaneously Edit in Excel, web app Learn More Co-Authoring Webcast

31. Additional Resources • 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

32. Q&A Lynn Mann Additional Questions? Email me at lmann@msjc.edu

33. Evaluation Survey Link Help us improve our seminars by filing out a short online evaluation survey at: http://www.surveymonkey.com/s/Sp11_Excel2010

34. Thanks for attending For upcoming events and links to recently archived seminars, check the @ONE Web site at: http://onefortraining.org/ Getting Up to Speed with Microsoft Office: Excel 2010