Home » Excel Training in Surrey | Live Online or Onsite

Excel Training in Surrey | Live Online or Onsite

Closed, Private Excel Training for Businesses

If you are a business enquiring about private, tailored Excel training for your staff, please see our Excel remote training information page which will explain all you need to know about our virtual Excel classroom.

Open, Scheduled Excel Courses for Individuals 

If you are an individual looking to join a remote scheduled Excel course, please see our scheduled Excel training page here.

Established in 2005, Blue Pecan provides tailored / bespoke in house Excel training courses. We offer BeginnersIntermediate and Advanced Excel training as well as Excel Dashboards, Power Query, Power Pivot and Excel VBA & Macros training courses. 

Live Online Courses – Excel courses can be delivered online with a live tutor via Zoom, Microsoft Teams or Webex virtual classroom software.

Onsite Courses – Excel courses can be delivered onsite at your business premises.

We offer in-house Excel training across Surrey including Addlestone, Ashstead, Banstead, Cranleigh, Camberley, Caterham, Chertsey, Cobham, Dorking, Epsom, Esher, Farnham, Frimley, Godalming, Guildford, Haslemere, Horley, Leatherhead, Oxted, Redhill, Reigate, Staines, Walton on Thames, Weybridge & Woking.

You can ask us to deliver one of our published Excel training outlines or opt for a tailored / bespoke course. We can also incorporate your working files to make the training as relevant as possible.

Our courses are compatible with any version of Excel including Excel 365, 2019, 2016, 2013, 2010 and 2007.

On-site and Online Training Prices

These prices are for in-house private training courses, scheduled for businesses or individuals.  Training can be provided onsite at your workplace or online via Zoom or MS Teams.

Half-day session: 09:30 to 16:00 or 13:00 to 16:00 or to suit. Full-day session: 09:30 to 16:00 or to suit

No. of DelegatesOnsite Full-dayOnline Per HourOnline Half-day Online Full-day
1£360£85£195£350
2 - 4£495£150£295£485
5 - 8£595£175£450£575
9 - 10£650£200£495£625
Additional delegates+£20+£5+£10+£15

All prices are excluding VAT. 

Onsite training travel expenses included for Sussex, Surrey, Hampshire, Berkshire, Buckinghamshire, Kent, Oxfordshire, London and most Essex, Dorset, Wiltshire, Somerset and Hertfordshire locations.  Please enquire.

Excel Course Outlines

Please click on the links below to see the course outline you are interested in:

Excel Tips

Worksheet Protection

Unlocking Cells

By default all cells are locked when you protect a worksheet.  If you want certain cells to remain unlocked when the sheet is protected:

  1. Select the cell or cells you want to unlock
  2. Click the Home tab  then Format | Lock Cell

Protecting the Worksheet

  1. Click the Home tab then  Format | Protect Sheet (password optional)

Convert Text into Numbers

When you import data into Excel, numbers can sometimes be imported as text.  If you need to convert the text to numbers, one of the easiest ways around the problem is to use Paste Special.

  1. Type the number 1 into any blank cell in the worksheet that contains the data you want to convert
  2. Copy the value 1
  3. Select the cells that contain the data you want to convert
  4. Open the Paste Special dialogue box and select Multiply as your option.

FAQS

Where in Surrey does Blue Pecan Computer Training Ltd deliver these courses?

Private training courses can be delivered at your business premises or remotely online anywhere in Surrey. Blue Pecan Computer Training Ltd also runs online scheduled courses open to the public.

Does Blue Pecan Computer Training Ltd offer online Excel courses?

Yes, Blue Pecan Computer Training Ltd can deliver this training onsite in Surrey or remotely via video conferencing software. We also offer scheduled Excel courses which are open to the public to enrol on.

What dates are available for Excel training with Blue Pecan Computer Training Ltd?

Please see our scheduled Excel course dates. If you want to run a private course (as a business or individual) on a date to suit you please contact us on 0800 612 4105 | email info@bluepecan.co.uk

Does Blue Pecan Computer Training Ltd offer tailored training?

Yes all our courses can be tailored: just pick your preferred topics from any of our Excel course outlines. You can also include your working files to make the training as relevant as possible.

What Excel courses are available through Blue Pecan Computer Training Ltd?

We offer Excel courses at all levels - beginners to advanced and VBA macros training. We can also tailor a course outline for you.

Training locations in Surrey, Woking, Guildford, Walton-on-Thames, Ewell, Esher, Camberley, Redhill, Leatherhead, Epsom, Weybridge, Ashford, Egham, Staines, Farnham, Horley, Godalming, Reigate, Caterham, Frimley, Cobham, Dorking, Addlestone, Ashtead, Chertsey, Oxted, Haslemere, Banstead, Cranleigh, Warlingham, Lightwater, Hindhead, Witley, Virginia Water, East Horsley, Bagshot, West Clandon, Send, Whitebushes & South Earlswood.