1 / 6

Welcome To: Excel Day 2

Class will start at Approximately 8:05 A M. Welcome To: Excel Day 2. Instructor: Glenn Romano. Resources. www.learnit.com/files www.learnit.com/handouts www.learnit.com/manuals Username: manuals Password: password. Learn iT! Is Going Social. www.learnit.com/learnitblog

tate
Download Presentation

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: Glenn Romano

  2. Resources • www.learnit.com/files • www.learnit.com/handouts • www.learnit.com/manuals • Username: manuals • Password: password

  3. Learn iT! Is Going Social www.learnit.com/learnitblog www.facebook.com/learn.it.anywhere www.twitter.com/learnitanywhere www.youtube.com/learnittraining www.linkedin.com/company/learn-it www.yelp.com/biz/learn-it-san-francisco

  4. Excel 2010-Module 3 List/Table Essentials & Charting • Overview of List design • Formatting lists as Tables • Single and Multi-level Sorting • Removing duplicates from a list or table • Filtering records in a list or table • Search by Filter • Inserting automatic subtotals in a list • Inserting data charts • Formatting and editing chart elements • Adding/removing data from a chart • Creating custom chart templates • Printing charts • Changing table and chart formatting through Themes • Inserting Sparkline

  5. Excel 2010-Module 4 Importing Data, Pivot Tables, Protecting & Linking Data • Importing data from other sources • Overview of exporting options • Creating a database query • Creating Pivot Tables from lists or tables • Filtering Pivot Tables • Using the Slicer tool within a Pivot Table • Working with Pivot charts • Applying Data Validation rules • Applying built in Conditional Formatting • Creating custom conditional formats • Inserting & editing Comments • Linking Data • Cell, sheet, and file protection

More Related