Beginners Excel Training

Microsoft Excel, the workhorse of the office, 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 it's a very malleable tool.

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.

Our Excel training course for beginners helps you discover the application's capabilities while working through exercises to create simple worksheets.

We also provide private and in-company Microsoft Excel courses. Call us on 01273 622272 to discuss.

Excel Training Feedback

"The Excel course yesterday was superb. I was concerned that it might be a bit too basic, but I learned a huge amount. I have to compliment Maggie on her amazing ability to challenge those of us who have been using Excel for a while, whilst at the same time ensuring that complete beginners weren't left behind - she was great!"
Alison Naylor - Sussex Partnership NHS Foundation Trust 

"The pace of the Excel Training was 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

"Good exercises to practice, good workbook, good facilities and a small group."
Rebecca Fallon - Efficiency Direct Ltd 

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.

Download the Excel Beginners Training Course Outline

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

• 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

Download the Excel Beginners Training Course Outline