Beginners Excel Training - 1 day - £195 + vat - dates
Beginners Excel training uk
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 Formulae
- 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 Recommended Reading
Microsoft Excel 2000 Bible - John Walkenbach – buy from amazon
Office Excel 2003 – buy from amazon
home book this course resources 01273 622272 info@siliconbeachtraining.co.uk
Microsoft Office and Sage Accounts are skills needed in most modern businesses, we offer a full range of beginners courses, and for more advanced delegates we provide VBA for Access and VBA for Excel training courses.