Excel Introduction 2007
One-Day Course

Course Overview

This course is designed to give the delegate a good understanding of the basic concepts of spreadsheet design, commands, data manipulation and presentation.

Delegates Requirements

It is essential that the delegate has attended a Windows Introduction Course or gained similar knowledge in the work place.

Who Should Attend

New users of Microsoft Excel who want to gain a good understanding of how to use the software in a short space of time to make them more efficient.

Course Outline

Excel Introduction

What is a Spreadsheet

New Features in 2007

Increased Workbook File Size

Cell Styles

Table Styles

New Conditional Formatting

Sort by Cell/Font Colour

New Chart Features

Page Layout View

Old Feature, New Location

Getting Started with Excel

Starting Excel

The Title Bar; Using the Ribbon;

Active Cell, Column and Row Headers

Sheet Tabs; The Status Bar; Menus and Submenus

Contextual Tabs

The Quick Access Toolbar

Short Cut Keys; Dialogue Boxes; Exiting Excel

Getting Assistance with Excel

Using the Office Assistant

Getting Help Without the Office Assistant

Manipulating the Help Window

Finding Out What is On the Screen

Starting a Workbook

Creating a New Workbook

Moving Around the Sheet

Scrolling; The Mouse Pointer

Selecting Cells with the Mouse

Selecting Cells with the Keyboard

Spreadsheet Data Types

Entering and Editing Data

Editing Long Entries

Undoing Incorrect Edits

Working with Worksheets and Cells

Using Go To

Drag-and-Drop, Cut, Copy and Paste

Using the Office Clipboard

Using Find and Replace

Building Formulas

Simple Calculations and Priorities

Creating and Manipulating 3D Formulas

Functions and the Function Wizard

Relative and Absolute Cell Referencing

Using AutoCalc and AutoSum

Data Series

Formatting Cells

Auto Format and Styles

Changing Cell Alignment

Applying Borders, Fonts and Colour

Formatting Numbers

Resizing Columns and Rows

Clearing a Worksheet

Structuring the Worksheet

Inserting and Deleting Rows and Columns

Inserting and Deleting Worksheets

Printing Worksheets

Print Preview

Changing the Page Setup; Printing

TO BOOK A COURSE
Telephone 01794 521449