Excel 2007 Level 1

1 Day Course
Hands On
Code DEX07L1

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

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.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Exploring the Excel Environment (4 topics)

  • Explore the User Interface
  • Explore the Ribbon
  • Obtain Help
  • Customise the Quick Access Toolbar

Working with an Excel Worksheet (3 topics)

  • Navigate in Excel
  • Select and Enter Data
  • Save a Workbook

Modifying a Worksheet (4 topics)

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

Performing Calculations (4 topics)

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions
  • Create a Mixed Reference

Formatting a Worksheet (11 topics)

  • Convert Text to Columns
  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Merge Cells
  • Apply Number Formats
  • Align Cell Contents
  • Find and Replace Formats
  • Apply AutoFormat
  • Apply Cell Styles
  • Apply Themes

Developing a Workbook (5 topics)

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheet
  • Copy and Paste Worksheets

Printing Workbook Contents (6 topics)

  • Set Print Titles
  • Create a Header and a Footer
  • Set Page Margins
  • Change Page Orientation
  • Set Page Breaks
  • Print a Range

Customising Layout (5 topics)

  • Split a Worksheet
  • Arrange Windows
  • Freeze and Unfreeze Rows and Columns
  • Hide and Unhide Worksheets

Prerequisites

To effectively understand this course, we recommend that you take a Microsoft Office Windows XP Introduction course or have equivalent knowledge.

Relevant Certifications

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections