60 likes | 189 Vues
Class will start at Approximately 8:05 A M. Welcome To: Excel Day 1. With Your Instructor: Cara Clifford (cara.clifford@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: ExcelDay 1 With Your Instructor: Cara Clifford (cara.clifford@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 2003-Module 1 Excel Essentials & Intro to Formulas • Introduction to the Excel interface • Navigating and selecting cells • Keyboard Shortcuts • Entering and editing data • Deleting and canceling data • Performing simple calculations • Saving your workbook • Spreadsheet structure and design • Creating basic formulas • Creating basic functions • Copying a formula with AutoFill • Recognizing the differences b/w Relative and Absolute references
Excel 2003-Module 2 Formatting, Spreadsheet Design, Page Setup & Printing • Inserting rows and columns • Moving and copying data • Using the AutoFill feature to complete a series of values • Formatting spreadsheet data • Applying autoformat • Using and creating templates • Worksheets - inserting, deleting, renaming, moving, copying, & grouping • Zooming in or out on a worksheet • Freezing and splitting panes • Spell checking your data • Setting print options through Page Setup • Printing your worksheets