Beginners Microsoft Excel Training

Often the workhorse of the office, Excel has a wide range of functions, from tracking simple to-do lists, to tracking the process of projects and managing large and complex financial reports and company accounts.

Microsoft Excel is a an extremely powerful spreadsheet application designed to save you time - and most users do not realise the full range of functionality available to them.

This beginners Excel training course shows you the applications capabilities, before work through exercises to create simple worksheets.

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

We also provide private and in-company Microsoft Excel courses. Call +44 (0) 1273 622272 to discuss.

VIDEO: Using AutoFill in Excel

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 Prerequisites

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

What our Clients Think About our Excel Training

The pace was of the Excel Training very good and there was lots of opportunity to practice and consolidate learning

Hazel Henderson - ES Downs & Weald PCT

Clear and concise teaching, refreshed my knowledge of Excel, friendly atmosphere, taught in a relaxed manner, but still taught everything that was expected.

Peter Manville - Shoreham Port Authority

Lots of new things to learn. I think I have increased my usage of Excel from 10% of its capacity to nearly 50%!

Anya Ledwith - Carbon Clear Limited

Excel Training Course Content

Managing files

Introduction to Excel

• The Excel Screen
• Using the Ribbon
• The quick Access Toolbar
• Saving, Opening, Closing a Workbook
• Moving around the Worksheet

Entering Data

• Entering, editing and deleting data
• Undo and Redo
• Filling Cells
• Cut Copy and Paste
• Using the Windows Clipboard

Working with Rows and Columns

• Inserting and Deleting Columns and Rows
• Change Column Width
• Change Row Height
• Hide and Un-Hide Columns

Formatting Cells

• Highlighting Methods
• Formatting Text
• Formatting Numbers
• Alignment of Cells
• Merging Cells
• Wrapping Text
• Borders and Shading

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

Viewing Data

• Zooming a Workbook
• Freezing Panes
• Splitting a Window

Using Formulae and Functions

• How to Enter a Formula
• What are Functions
• Using Sum/Average/Max/Min
• Copying Formulas
• Relative and Absolute References

Printing

• Setting up the Page for Printing
• Using Different Views
• Adding Headers and Footers
• Using Print Titles
• Setting and Clearing Print Areas

Simple Charts

• Creating Simple Charts
• Changing Chart Type
• Formatting a Chart

Excel Training Course Recommended Reading

Learn Excel 2007 Essential Skills with The Smart Method: Courseware Tutorial for Self-instruction to Beginner and Intermediate Level