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

Beginners Microsoft Excel Training

 SUMMER OFFER: 1 day - £215: £161 + vat

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 Training 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

• 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 training course should have reasonable general PC skills.
• No prior knowledge of Excel is required for this excel training course.

Book this Microsoft excel training 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.