OakTree 1040

Excel 2010: Basic

  • Course Price:$275
  • Audience: Information Workers
  • Portfolio: Office
  • Related Exams:
  • Related Certifications:

Description

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: Using 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