Skip Navigation Links

Course Length:
1 Day
Course Description:
Students will create, edit, format and print basic worksheets and charts in Excel.
Who Should Attend:
This course is designed for people preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of Microsoft® Office, Windows® 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.
Benefits of Attendance:
Upon completion of this course, students will be able to:
  • Explore the Excel 2007 environment.
  • Work with an Excel worksheet by entering and selecting the data in it. You will also save the data in the worksheet.
  • Modify a worksheet.
  • Perform calculations.
  • Format a worksheet.
  • Develop a workbook.
  • Print workbook contents.
  • Customize the layout of the Excel application window.
Prerequisites:
To effectively understand this course, we recommend that you take an Microsoft Office Windows XP Introduction course or have equivalent knowledge.
Course Outline:
  • Exploring the Excel Environment
    1. Explore the User Interface
    2. Explore the Ribbon
    3. Obtain Help
    4. Customize the Quick Access Toolbar
  • Working with an Excel Worksheet
    1. Navigate in Excel
    2. Select and Enter Data
    3. Save a Workbook
  • Modifying a Worksheet
    1. Manipulate Data
    2. Insert and Delete Cells, Columns, and Rows
    3. Search for Data in a Worksheet
    4. Spell Check a Worksheet
  • Performing Calculations
    1. Create Basic Formulas
    2. Calculate with Functions
    3. Copy Formulas and Functions
    4. Create a Mixed Reference
  • Formatting a Worksheet
    1. Convert Text to Columns
    2. Modify Fonts
    3. Add Borders and Color to Cells
    4. Change Column Width and Row Height
    5. Merge Cells
    6. Apply Number Formats
    7. Align Cell Contents
    8. Find and Replace Formats
    9. Apply AutoFormat
    10. Apply Cell Styles
    11. Apply Themes
  • Developing a Workbook
    1. Format Worksheet Tabs
    2. Reposition Worksheets in a Workbook
    3. Insert and Delete Worksheets
    4. Copy and Paste Worksheets
  • Printing Workbook Contents
    1. Set Print Titles
    2. Create a Header and a Footer
    3. Set Page Margins
    4. Change Page Orientation
    5. Set Page Breaks
    6. Print a Range
  • Customizing Layout
    1. Split a Worksheet
    2. Arrange Windows
    3. Freeze and Unfreeze Rows and Columns
    4. Hide and Unhide Worksheets
  • Appendix A: Microsoft Office Specialist: Excel 2007