1 / 20

Excel 2010 Overview with Tom McLaughlin: Enhancing Your Skills

Join Tom McLaughlin for a comprehensive overview of Excel 2010, from navigating the Ribbon to using new features like Sparklines and Slicers. Learn how to customize toolbars, manage pictures, and optimize your workflow with handy tips and tricks.

brandon-nixon
Télécharger la présentation

Excel 2010 Overview with Tom McLaughlin: Enhancing Your Skills

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. Welcome! Overview of Excel 2010Presenter: Tom McLaughlinb-admin, mct, ctt, mcse, a+, n+, s+

  2. The Old and The New… Excel 2007: Excel 2010: * Remember you can minimize the Ribbon (Cntl+F1)

  3. The File Menu/Backstage… 2010 2003 2007

  4. The Ribbon… • No more Menu or Toolbars • Dialogue/Options is available • New yellow warning strip

  5. The Quick Access Toolbar Customize your own toolbar for future usage. Select “More Commands” for more icons/options. Right click any icon in the Ribbon to add or remove the option.

  6. Info/Options Panel… Document Properties Versions is behindthis dropdown menu Inspect Document and Compatibility

  7. The Recent Menu • Pin to lock • Quick Access

  8. The Print Menu… Select Printers here The Preview Pane Select Pages here Notice drop down menusthe give more options Preview Pages Margin Printing

  9. Save & Send options… Send as Attachment Send as PDF

  10. Office Options Window • Turn off Mini Toolbar • Change Theme color • Advanced was old “tools menu” • Arrange QAT positions

  11. New Copy & Paste in Office! • New Copy and Paste • Preview before select

  12. SmartArt… • Management • IT department • Contractors

  13. Picture Tool Bar Remove Backgrounds Artistic Effects Compress Pictures Shadows and Frames Wrapping Text Bring Forward or Send to Back Cropping Exact Size

  14. New Formula Bar in Excel • Excel now has an adjustable formula and Name bar!

  15. Excel Sparklines… • Excel’s new Sparklines • Sums up rows or columns in linear or graphical view • Embedded to cell

  16. Excel Slicer… • Excel’s new Slicer • Tabular view of your data • Live time Sorting

  17. Three Rules of Excel… Three Rules of Excel: Always click the cell/item where you are working. When in doubt, right click mouse for menu. Pay attention to the mouse icon. Normal, Move, Edit, Autofill, Resize, Select

  18. Live Demo…

  19. Questions & Answers… • www.digitalsmiles.com/office • Google: “Office 2010 Notes” (or 2007) • Contact Tom at: tom@digitalsmiles.com • Thank you!

  20. Thank you! An Overview of Excel 2010Instructor: Tom McLaughlintom@digitalsmiles.com

More Related