60 likes | 215 Views
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.
E N D
Class will start at Approximately 8:05 AM 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 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
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
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