Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: advanced excel course london excel introduction introduction to excel excel 2007 training excel course for accountants excel 2007 courses excel 2007 course excel macro course london formation cors tutorial excel provider data link excel attribute
Homepage > IT, Computing, Telecommunications > PC Applications > Excel

Excel Intermediate

in CTS - Computer Training Solutions (England)

Classes Course

Place:

Bristol, Bracknell,...

Price:

£225 + VAT Special offers 

Duration:

1 day

Start:

08/07/2008 other dates
See course programme

Requirements:

Basic knowledge of Microsoft Excel, understanding of formulae and ideally have sat our Excel Introdu...

Request free information

Course objectives:

Top quality, detailed training in all functions of Microsoft Excel.

CTS - Computer Training Solutions

Do your staff struggle when using Excel, Word or PowerPoint? Would you like to have more specialist skills in-house such as Adobe Photoshop, Illustrator or Dreamweaver? Or would you like to improve th...

Contact course provider

Request information

Contact directly and with no obligation with
CTS - Computer Training Solutions
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
I would like to receive information on similar courses.
By clicking "E-mail request / Telephone" you are accepting the Terms of Use and privacy policy similarly, you give express authorisation for the course provider to let us know whether you have enrolled on the course or not. Emagister will send you courses matching your profile for a period of 15 days.

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Normal Fast Very fast

Course details

Type Course Duration 1 day
Method / place Contact course provider Classes in Bristol, Bracknell,... where
Students per class 500
Suitability Anyone wishing to improve their Microsoft Excel skills.
Course objectives Top quality, detailed training in all functions of Microsoft Excel.
Requirements
Basic knowledge of Microsoft Excel, understanding of formulae and ideally have sat our Excel Introduction course. It is a common error to misjudge your level of ability with Excel, please ensure you are familar with all basic functions before attending this course.
Price £225 + VAT
Special offer + Support
Request this special offer here
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Excel 2003
We Teach You
Distance - £30 VAT inc.
Guaranteed response
 
Excel 2007
Sales 101 Ltd
Distance - £95 + VAT
Guaranteed response
 
Excel 2007 Training
UK Open Learning Ltd
Distance - £175 VAT inc.
Guaranteed response
Compare the selected courses

Course programme

Excel Intermediate
Attend this 1 day course to improve your Excel skills with Computer Training Solutions.  We have 3 centres in Bristol, Solihull and Bracknell and all centres offer this course between once and three times per month.
 
You will receive a full course manual, free USB disk containing your exercise files, refreshments including lunch and a certificate of completion following the course
 
VIEWING WORKSHEETS
• Customising View Options
• Displaying And Customising Toolbars
• Hiding Workbooks And Worksheets
• Freezing Panes
• Grouping And Ungrouping Worksheets

MORE FORMATTING TECHNIQUES
• Using Styles
• Conditional Formatting
• Using The Format Painter
• Using Guidelines
• Hiding And Displaying Cells

MORE FORMULAS AND FUNCTIONS
• Using The Series Command
• Using The Insert Function Wizard
• Financial functions PMT and FV
• Using The Excel Function Categories
• Correcting Formulas
• Using The Formula Error Checker
• Using The Formula Auditing Toolbar
• Using The Watch Window

ABSOLUTE REFERENCES
• Entering an absolute column and absolute row cell reference into a formula
• Entering mixed cell references into a formula

USING LOGICAL FUNCTIONS
• Using the IF function
• Nesting IF functions

DATABASE AND LIST MANAGEMENT
• Using Excel as a database
• Creating And Editing A Database
• Sorting A Database
• Using Autofilters
• Advanced Filters
• Working With Filtered Data
• Using Data Forms


CHARTS
• Chart Wizard
• Chart Toolbar
• Working With Charts
• Formatting The Chart

LINKING WORKSHEETS WITHIN A WORKBOOK
• Renaming worksheets
• Inserting and deleting worksheets
• Formatting multiple worksheets
• Creating formulas to link worksheets

DRAWING AND PICTURE OBJECTS
• Drawing Toolbar
• Working With Autoshapes
• Creating Text Boxes
• Adding Pictures
• Layering Objects
• Grouping And Ungrouping Objects

EXCEL 2003 AND OTHER APPLICATIONS
• Converting Files From Other Applications
• Copying Data From Another Application
• Embedding And Linking Objects
• Hyperlinks
• Managing Links
 
see the full course programme

on request

get more information on the programme directly from CTS - Computer Training Solutions.

Request information for free
Get direct information on how to enrol, venues and availability...

Venues and dates



Where Bristol, Aztec Centre, Aztec West,
When Start: 08/07/2008 Finish: 08/07/2008 See calendar
 
Where Bracknell, Venture House, Arlington Square, Downshire Way
When Start: 08/07/2008 Finish: 08/07/2008 See calendar
 
Where Solihull, Central Boulevard, Blythe Valley Business Park
When Start: 10/07/2008 Finish: 10/07/2008 See calendar
 
Where Bristol, Aztec Centre, Aztec West,
When Start: 12/08/2008 Finish: 12/08/2008 See calendar
 
Where Bracknell, Venture House, Arlington Square, Downshire Way
When Start: 12/08/2008 Finish: 12/08/2008 See calendar
 
Get direct information on how to enrol, venues and availability...

Teachers/ trainers

profesorado Eddolls Trevor
IT Trainer

Get direct information on how to enrol, venues and availability...

Course provider details

Description
Do your staff struggle when using Excel, Word or PowerPoint? Would you like to have more specialist skills in-house such as Adobe Photoshop, Illustrator or Dreamweaver? Or would you like to improve the efficiency of your staff? Computer Training Solutions (CTS) can provide you with the solution by providing excellent quality IT training for your staff. We aim to provide a partnership with our clients by establishing long-term relationships and becoming an extension of your development team. In order to do this we provide a complimentary consultation with a training manager to put together a tailored training plan to suit your needs. We are preferred suppliers to Nokia, Mothercare, Amey, RWE, Lloyds TSB and many more. Contact us on 0800 019 6882 to talk to a training consultant today!
Get direct information on how to enrol, venues and availability...

Information related to Excel


Words related to the courses viewed: microsoft office

emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights