1 / 34

Getting Up to Speed with Microsoft Office: Excel 2010

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.

ophira
Download Presentation

Getting Up to Speed with Microsoft Office: Excel 2010

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related