Download
welcome to excel day 1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Welcome To: Excel Day 1 PowerPoint Presentation
Download Presentation
Welcome To: Excel Day 1

Welcome To: Excel Day 1

156 Views Download Presentation
Download Presentation

Welcome To: Excel Day 1

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Class will start at Approximately 8:05 AM Welcome To: Excel Day 1 Instructor: Cara Clifford (cara.clifford@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