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 Beginners, Intermediate 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
including Addlestone, Ashstead, Banstead, Cranleigh
, 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 Delegates||Onsite Full-day||Online Per Hour||Online Half-day ||Online Full-day
|2 - 4||£495||£150||£295||£485
|5 - 8||£595||£175||£450||£575
|9 - 10||£650||£200||£495||£625
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:
By default all cells are locked when you protect a worksheet. If you want certain cells to remain unlocked when the sheet is protected:
- Select the cell or cells you want to unlock
- Click the Home tab then Format | Lock Cell
Protecting the Worksheet
- 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.
- Type the number 1 into any blank cell in the worksheet that contains the data you want to convert
- Copy the value 1
- Select the cells that contain the data you want to convert
- Open the Paste Special dialogue box and select Multiply as your option.
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?
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.