Using Microsoft® Office Excel® 2007
  1. Creating and Manipulating Data
    • Insert data by using Auto Fill
    • Ensure data integrity
    • Modify cell contents and formats
    • Change Worksheet Views
    • Manage worksheets

  2. Formatting Data and Content
    • Format worksheets
    • Insert and modify rows and columns
    • Format cells and cell content
    • Format data as a table

  3. Creating and Modifying Formulas
    • Reference data in formulas
    • Summarize data using a formula
    • Summarize data using subtotals
    • Conditionally summarize data by using a formula
    • Look up data by using a formula
    • Use conditional logic in a formula
    • Format or modify text by using formulas
    • Display and print formulas

  4. Presenting Data Visually
    • Create and format charts
    • Modify charts
    • Apply conditional formatting
    • Insert and modify illustrations
    • Outline data

  5. Collaborating and Securing Data
    • Manage changes to workbooks
    • Protect and share workbooks
    • Prepare workbooks for distribution
    • Save workbooks
    • Set print options for printing data, worksheets, and workbooks

    This training prepares you to take Microsoft certification exam 70-602.

    Syllabus PDF (956 kb)