MICROSOFT EXCEL 2007
LEVEL 1

Duration

  • 1 Day
Book Now

Entry Requirements

  • Computer literate

Students should have completed the following courses or possess Equivalent knowledge:

  • Windows XP: Introduction
  • Windows XP Professional: Level 1
  • Windows XP Professional: Level 2
  • Windows 2000: Introduction

Outline

Lesson 1: Creating a Basic Worksheet

  • Explore the user interface and the Ribbon
  • Customize the Quick Access Toolbar Analyze Tables
  • Obtain Help
  • Navigate and Select in Excel
  • Enter Data and Save a workbook

Lesson 2: Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions

Lesson 3: Modifying a Worksheet

  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Apply Number Formats
  • Position Cell Contents
  • Apply Cell Styles

Lesson 5: Printing Workbook Contents

  • Print Workbook Contents Using Default Print Options
  • Set Print Options
  • Set Page Breaks

Lesson 6: Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheet in a Workbook
  • Manage the View of Large Worksheets