1 Day – £225 + vat

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

Beginners Excel Training Course Content

Managing files

Excel Training Introduction

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

Entering Data in Excel

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

Working with Rows and Columns in Excel

• Delete and Insert
• Change Column Width
• Change Row Height

How to Move and Copy Data

Formatting Cells in Excel

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

Using Worksheets

• Rename your Worksheets
• Inserting New Worksheets
• Moving and Coping Worksheets
• Deleting Worksheets

Using AutoFill

• How to use AutoFill
• Customer AutoFill Lists
• Using AutoFill to Replicate
• Using AutoFill to Copy Sequence

Formulas and Functions

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

Printing in Excel

• Page Set Up
• Page Breaks
• Print Preview
• Printing

Charts in Excel

• Using the Chart Wizard to create charts
• Formatting a Chart

Beginners Excel Training Course Prerequisites

Delegates are not expected to have any prior knowledge of Excel at all. But attendees should have reasonable general PC skills.