1 / 6

Welcome To: Excel Day 1

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

takoda
Download Presentation

Welcome To: Excel Day 1

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 1 Instructor: Glenn Romano (glenn.romano@learnit.com)

  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 1 Excel Essentials & Intro to Formulas and Functions • Introduction to the Excel 2010 Interface (The Ribbon, The Backstage View& The Quick Access Toolbar) • Zooming in and out of a worksheet • Navigating and selecting cells • Keyboard Shortcuts • Entering and editing data • Deleting/replacing cell data • Performing simple calculations • Saving the workbook file • Checking compatibility with older versions of Excel • Overview of the Formulas Ribbon • Building basic Formulas • Using simple Functions • Copying formulas/functions with the AutoFill command • Using Relative and Absolute cell references in calculations

  5. Excel 2010-Module 2 Formatting, Spreadsheet Design, Page Setup & Printing • Inserting rows and columns • Inserting rows & columns • Moving & copying data • Using AutoFill to complete a series of values • Introduction to worksheet Themes • Formatting worksheet data/using Cell Styles • Using Excel templates/creating custom templates • Managing worksheets: inserting, deleting, renaming, move/copy • Grouping worksheets • Freezing or splitting panes • Creating custom views • Spell checking your worksheets • Setting print options through Page Setup • Using the Page Layout view • Printing your worksheet

More Related