Home / Courses / Microsoft End User / Excel 2010: Basic

Excel

Excel 2010: Basic

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
 

Course Registration

 

1 day
$245.00

 

Course Outline

 

Request