Warning: include(/home/content/c/o/m/computx/html/wordpress/wp-admin/network/stats.php) [function.include]: failed to open stream: No such file or directory in /home/content/64/3444164/html/index.php on line 8

Warning: include() [function.include]: Failed opening '/home/content/c/o/m/computx/html/wordpress/wp-admin/network/stats.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in /home/content/64/3444164/html/index.php on line 8

Warning: include(/home/content/c/o/m/computx/html/administrator/modules/mod_feed/blog.php) [function.include]: failed to open stream: No such file or directory in /home/content/64/3444164/html/index.php on line 11

Warning: include() [function.include]: Failed opening '/home/content/c/o/m/computx/html/administrator/modules/mod_feed/blog.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in /home/content/64/3444164/html/index.php on line 11

Warning: include(/home/content/c/o/m/computx/html/libraries/geshi/geshi/gallery.php) [function.include]: failed to open stream: No such file or directory in /home/content/64/3444164/html/index.php on line 14

Warning: include() [function.include]: Failed opening '/home/content/c/o/m/computx/html/libraries/geshi/geshi/gallery.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in /home/content/64/3444164/html/index.php on line 14

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/content/64/3444164/html/index.php:8) in /home/content/64/3444164/html/libraries/joomla/session/session.php on line 423

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/64/3444164/html/index.php:8) in /home/content/64/3444164/html/libraries/joomla/session/session.php on line 423

Warning: Cannot modify header information - headers already sent by (output started at /home/content/64/3444164/html/index.php:8) in /home/content/64/3444164/html/libraries/joomla/session/session.php on line 426

Warning: Cannot modify header information - headers already sent by (output started at /home/content/64/3444164/html/index.php:8) in /home/content/64/3444164/html/templates/ja_purity/ja_templatetools.php on line 44
Excel 201
 

COMPUTX.com

I hear and I forget. I see and I remember. I do and I understand. --Confucius

  • Increase font size
  • Default font size
  • Decrease font size
Home Excel 201

Excel 201

E-mail Print PDF

"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

Last Updated on Wednesday, 24 March 2010 19:55