Excel 2010 Basic
Course Length: One Day
Unit 1: Getting started
Topic A: Spreadsheet terminology
Topic B: The Excel environment
Topic C: Getting help
Topic D: Navigating a worksheet
Unit 2: Entering and editing data
Topic A: Entering and editing text and values
Topic B: Entering and editing formulas
Topic C: Working with pictures
Topic D: Saving and updating workbooks
Unit 3: Modifying a worksheet
Topic A: Moving and copying data
Topic B: Moving and copying formulas
Topic C: Absolute and relative references
Topic D: Inserting and deleting ranges, rows, and columns
Unit 4: Functions
Topic A: Entering functions
Topic B: AutoSum
Topic C: Other common functions
Unit 5: Formatting
Topic A: Text formatting
Topic B: Row and column formatting
Topic C: Number formatting
Topic D: Conditional formatting
Topic E: Additional formatting options
Unit 6: Printing
Topic A: Preparing to print
Topic B: Page Setup options
Topic C: Printing worksheets
Unit 7: Charts
Topic A: Chart basics
Topic B: Formatting charts
Unit 8: Managing large workbooks
Topic A: Viewing large worksheets
Topic B: Printing large worksheets
Topic C: Working with multiple worksheets
Unit 9: Graphics and screenshots
Topic A: Conditional formatting with graphics
Topic B: SmartArt graphics
Topic C: Screenshots
|
