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 101
 

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 101

Excel 101

E-mail Print PDF

Initial Knowledge

  1. 084890dd.exe: Installs a folder named 084890Data on your C drive.  This folder contains all the data files that you will use to complete this course.
  2. 084890s3.doc: Pre-test/Post-test
  3. Excel2007ExamMapping.doc: Tells you how the skills you learn here will map to the Microsoft Certified Application Specialist (MCAS) Certification Exam.
  4. ol84-890.rtf: Outline of the course
  5. PowerPoint Slides (coming soon)

Course Content

Lesson 1: Creating a Basic Worksheet

  • Topic 1A: Explore the User Interface and the Ribbon
  • Topic 1B: Navigate and Select in Excel
  • Topic 1C: Obtain Help
  • Topic 1D: Enter Data and Save a Workbook
  • Topic 1E: Customize the Quick Access Toolbar

Lesson 2: Performing Calculations

  • Topic 2A: Create Basic Formulas
  • Topic 2B: Calculate with Functions
  • Topic 2C: Copy Formulas and Functions

Lesson 3: Modifying a Worksheet

  • Topic 3A: Manipulate Data
  • Topic 3B: Insert and Delete Cells, Columns, and Rows
  • Topic 3C: Search for Data in a Worksheet
  • Topic 3D: Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

  • Topic 4A: Modify Fonts
  • Topic 4B: Add Borders and Color to Cells
  • Topic 4C: Change Column Width and Row Height
  • Topic 4D: Apply Number Formats
  • Topic 4E: Position Cell Contents
  • Topic 4F: Apply Cell Styles

Lesson 5: Printing Workbook Contents

  • Topic 5A: Print Workbook Contents Using Default Print Options
  • Topic 5B: Set Print Options
  • Topic 5C: Set Page Breaks

Lesson 6: Managing Large Workbooks

  • Topic 6A: Format Worksheet Tabs
  • Topic 6B: Manage Worksheets in a Workbook
  • Topic 6C: Manage the View of Large Worksheets

Extras

Last Updated on Tuesday, 12 October 2010 13:37