Please download the latest flash player

CourseOCN Introduction to Excel

Course Details

Venue: Commerce House, Stoke on Trent  
Duration: One Day (9.30am - 4.30pm)
Trainer: Eileen Venables  
Cost: £185.00+VAT - Members         
     £230.00+VAT - Non-Members  

Course Objectives
This one-day course aims to provide delegates with the confidence, knowledge and practical experience to be able to use Excel for numerical analysis & the presentation of information. This entirely ‘hands-on' course will give those attending a solid foundation in the understanding of spreadsheet usage and formatting so users can choose the features they are most likely to use in their specific job. This course provides time for a considerable amount of materials to be covered, but also to allow time for practical exercises and consolidation of the work covered.  No previous knowledge of Excel is required, however a good understanding of Windows is required to allow the course to progress at the correct speed. This may be gained by attendance of the Windows course or prior experience.

Outline
THE SCREEN

• Row and Column Headings
• The Active Cell
• Cell Address and Formula Bar
• Mode Indicator
• Sheet Tabs
• Renaming Sheet Tabs
• Changing the View
• Inserting & Deleting a Sheet

   CREATING A NEW SPREADSHEET

• Open a New Workbook File
• Open an Existing Workbook
• Saving a Workbook
• Closing Workbooks
• Moving in the Worksheet

   ENTERING TEXT AND LABELS

• Text Entry
• Alignment
• Align Text Using the Button Bar
• Align Text Using the Menu Bar
• Centre Headings over Columns

   ENTERING AND FORMATTING VALUES

• Entering Values
• Formatting Values using the Button Bar
• Formatting Values using the Menu Bar

   ENTERING FORMULAE

• Spreadsheet Mathematics
• Circular References
• Editing Calculations

   WORKING WITH RANGES

• Selecting a Range using the Mouse
• Selecting a Column or a Row
• Selecting a Range using the Keyboard
• Selecting Non-Continuous Areas

   USING BUILT IN FUNCTIONS

• Auto Sum

   TEXT ENHANCEMENTS

• Changing Fonts and Attributes
• Text Enhancements
• Wrapping Text within Cells

   FORMATTING THE SHEET

• Column Width
• Resizing Columns
• Row Height
• Borders and Shading
• Format Painter
• Headers and Footers

   MOVING AND COPYING

• Cut or Move Cells
• Copy Cells
• Paste Cell Contents
• Drag and Drop
• Auto Fill
• Fill Right/Left or Down/Up

   PREVIEWING AND PRINTING A DOCUMENT

• Previewing a Document
• Printing A Document

   CHARTS AND GRAPHS

• Introduction to creating charts
• Modifying chart

Course Details

Course Date: 3 October 2012 Cost For Members: £185 + VAT Cost For Non-Members: £230 + VAT

Book a place at this course

To book a place at this course, input the number of delgates attending and press add to cart

x Delegates

Shopping Basket

Your Shopping Basket is empty

Event Calendar

<< May 2013 >>

S	M	T	W	T	F	S
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29• Debt Collecting by Telephone • OCN Procedures & Operations in International Trade - POINT	30• BCC Import Procedures	31

Mouse over dates to view events

Events open to all members

Event Location Guide

Stafford (South) Area

Stoke (North) Area