1 / 7

Welcome To: Excel Day 2

Class will start at approximately 8:05 AM. Welcome To: Excel Day 2. Instructor: Elizabeth ( Lissy ) Robie (erobie@learnit.com). Resources. Handouts: www.learnit.com/handouts Manuals : www.learnit.com/manuals Username: manuals Password: password Files: www.learnit.com/files

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

Welcome To: Excel Day 2

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. Class will start at approximately 8:05 AM. Welcome To:Excel Day 2 Instructor: Elizabeth (Lissy) Robie (erobie@learnit.com)

  2. Resources • Handouts: www.learnit.com/handouts • Manuals: www.learnit.com/manuals Username: manuals Password: password • Files: www.learnit.com/files • My email: erobie@learnit.com

  3. Social Media http://www.youtube.com/learnittraining https://www.facebook.com/Learn.iT.anywhere https://twitter.com/learnitanywhere http://www.linkedin.com/company/learn-it

  4. *Use www.learnitanytime.com/lissyfor 40% discount.

  5. Module 3:Lists and Charts *2010/13 only *2013 only • Lists: What is a list? • Sorting • Lists as Tables • Filtering • Removing Duplicates • Conditional Formatting (sneak peek) • Subtotals • Charts: • Column/Bar, Line, and Pie Charts • Inserting Sparklines* • Recommended Charts*

  6. Module 4:Pivot Tables and More Tools *2010/13 only • Pivot Tables • Filtering and the Slicer* • Importing data • From a text file • Text-to-Column and Concatenation • From a web page • Data Validation • Conditional Formatting • Linking Data • Compatibility Check

  7. 2007 and 2010 Versions 2007 Office Button 2010 File Menu Tab

More Related