Excel  Introduction
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 Introductory Course or gained similar knowledge in the work place.

Who Should Attend

New users of Excel who want to gain a good understanding of how to use the software efficiently in a short space of time.

Course Outline

Excel Introduction

What is a Spreadsheet?

Getting Started with Excel

Starting Excel

The Title Bar; The Menu Bar; The Status Bar; Toolbars

Scroll Bars; Active Cell, Column and Row Headers

Sheet Tabs; Menus and Submenus

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

AutoFill; Custom Lists

Saving, Closing, Opening and Deleting a Workbook

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