Home » Training Courses » Microsoft Office and Desktop Applications Training » Beginners Microsoft Excel Training

Beginners Microsoft Excel Training

1 day - £215 + vat

Excel Training Need help NOW?! Learn Excel basics step-by-step with our Free Microsoft Excel 2007 Tutorial

Microsoft Excel is a very powerful spreadsheet application designed to save you time and make creating spreadsheets and other documents easy. This excel training course shows you the applications capabilities, before work through exercises to create simple worksheets.

Microsoft Excel Course Objectives

This introductory Excel training course will provide you with a working understanding of the basic features of MS Excel.

Excel Training Course Content

Managing files

Introduction to Excel

The Excel Screen
Toolbars and Menus
Scroll Bars
Worksheet, Columns, Rows and Cells
Saving, Opening, Closing a Workbook
Moving around the Worksheet

Entering Data

Entering Data using In-Cell and Formula Bar
Editing Data in cells
Selecting Cells
Clearing Cells

Working with Rows and Columns

Change Column Width
Change Row Height
Delete and Insert

Moving and Copying Data

Formatting Cells

Formatting using Toolbar
Formatting using Dialog
Applying Text Formats
Applying Currency Formats
Applying Date Formats
Merge and Centre
Borders and Shading
Format Painter

Working with Worksheets

Renaming Worksheets
Inserting Worksheets
Move and Copy Worksheets
Delete Worksheets

AutoFill

We have a Free AutoFill Video Tutorial in our Free Resources section

How to use the AutoFill Handle
Using AutoFill to Copy Sequence
Using AutoFill to Replicate
Customer AutoFill Lists

Using Formula and Functions

How to Enter a Formula
Working with Formula
How to Use Autosum
What are Functions
Using simple Functions (Average, Min, Max)

Printing

Print Preview
Page Set Up
Page Breaks
Printing

Simple Charts

Using the Chart Wizard to create charts
Formatting a Chart

Excel Training Course Prerequisites

Delegates attending this excel course should have reasonable general PC skills.
No prior knowledge of Excel is required for this excel training course.

Book this Microsoft excel course one to one for £450 + vat

Excel Training Course Recommended Reading

Excel 2007 Step by Step by Curtis D. Frye - buy from amazon

Download course outline as pdf.

+44 (0)1273 622272

Beginners Microsoft Excel Training course dates

19 Mar 2010
23 Jun 2010
23 Sep 2010