Computer Training and Support
Excel 201
Saturday, 30 January 2010 16:04
administrator
"Microsoft Office Excel 2007 Level 2 (Second Edition)" by Element K
Student Course Files
Course Content
Lesson 1: Calculating Data with Advanced Formulas (3/3)
- Topic 1A: Manage Cell and Range Names
- Topic 1B: Calculate Data Across Worksheets
- ! (Bang) references data on another worksheet
- Topic 1C: Use Specialized Functions
- Topic 1D: Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data (3/10)
- Topic 2A: Create and Modify Tables
- Topic 2B: Format Tables
- Topic 2C: Sort or Filter Worksheet or Table Data
- Topic 2D: Calculate Data in a Table or Worksheet
Lesson 3: Presenting Data Using Charts (3/17 Hour 1)
- Topic 3A: Create a Chart
- Topic 3B: Modify Charts
- Topic 3C: Format Charts
Lesson 4: Analyzing Data Using PivotTables and PivotCharts (3/17 Hour 2)
- Topic 4A: Create a PivotTable Report
- Topic 4B: Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects (3/24 Hour 1)
- Topic 5A: Insert and Modify Pictures and ClipArt
- Topic 5B: Draw and Modify Shapes
- Topic 5C: Illustrate Workflow Using SmartArt Graphics
- Topic 5D: Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment (3/24 Hour 2)
- Topic 6A: Customize the Excel Environment
- Topic 6B: Customize Workbooks
- Topic 6C: Manage Themes
- Topic 6D: Create and Use Templates
Extras
- Mr. Excel Podcast
- Excel is Fun Podcast
Last Updated on Wednesday, 03 March 2010 20:02
|