Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
LEARN  >  Find a Class  >  Class Summary

APEX071 - Microsoft Office Excel 2007 Level 1

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com
You will create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks.
Click here for a printer-friendly version of this page
 
Upcoming classes
Number Class Date Location Length Cost Sign up
APEX071 Feb 22, 2012 - Feb 22, 2012 Springfield 1 day $140.00 Register
APEX071 Mar 06, 2012 - Mar 06, 2012 Bloomington 1 day $140.00 Register
APEX071 Mar 12, 2012 - Mar 12, 2012 Bloomington 1 day $140.00 Register


Prerequisites

  • To effectively understand this course, we recommend that you take the Microsoft Office Windows XP Introduction course offered by LRS or have equivalent knowledge.
    •  
    Detailed Class Syllabus


    Lesson 1: Exploring the Excel Environment
  • Topic 1A: Explore the User Interface

  • Topic 1B: Explore the Ribbon

  • Topic 1C: Obtain Help

  • Topic 1D: Customize the Quick Access Toolbar


    • Lesson 2: Working with an Excel Worksheet
  • Topic 2A: Navigate in Excel

  • Topic 2B: Select and Enter Data

  • Topic 2C: Save a Workbook


    • 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: Performing Calculations
  • Topic 4A: Create Basic Formulas

  • Topic 4B: Calculate with Functions

  • Topic 4C: Copy Formulas and Functions

  • Topic 4D: Create a Mixed Reference


    • Lesson 5: Formatting a Worksheet
  • Topic 5A: Convert Text to Columns

  • Topic 5B: Modify Fonts

  • Topic 5C: Add Borders and Color to Cells

  • Topic 5D: Change Column Width and Row Height

  • Topic 5E: Merge Cells

  • Topic 5F: Apply Number Formats

  • Topic 5G: Align Cell Contents

  • Topic 5H: Find and Replace Formats

  • Topic 5I: Apply AutoFormat

  • Topic 5J: Apply Cell Styles

  • Topic 5K: Apply Themes


    • Lesson 6: Developing a Workbook
  • Topic 6A: Format Worksheet Tabs

  • Topic 6B: Reposition Worksheets in a Workbook

  • Topic 6C: Insert and Delete Worksheets

  • Topic 6D: Copy and Paste Worksheets


    • Lesson 7: Printing Workbook Contents
  • Topic 7A: Set Print Titles

  • Topic 7B: Create a Header and a Footer

  • Topic 7C: Set Page Margins

  • Topic 7D: Change Page Orientation

  • Topic 7E: Set Page Breaks

  • Topic 7F: Print a Range


    • Lesson 8: Customizing Layout
  • Topic 8A: Split a Worksheet

  • Topic 8B: Arrange Windows

  • Topic 8C: Freeze and Unfreeze Rows and Columns

  • Topic 8D: Hide and Unhide Worksheets


    • Appendix A:
  • Microsoft Office Specialist: Excel 2007
    •
     
    Microsoft Partner Gold LearningPrometricEC-Council
    Microsoft Certified ProgramsAdditional Certification Courses