Home » Excel Training Buckinghamshire | Live Online or Onsite

Excel Training Buckinghamshire | 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 deliver in-house Excel training to businesses across Buckinghamshire including Amersham, Aylesbury, Buckingham, Chesham, Gerrards Cross, Great Missenden, High Wycombe, Marlow, Milton Keynes, Newport Pagnell, Princes Risborough & Witham.

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
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

Recorded Macros

In this video we look at recorded macros.  Our scenario involves imported sales data.  Once the sales data has been imported into Excel it needs to be formatted and subtotals and commission calculations needs to be performed. From one month to another there will be a different number of records imported so the macro will need to work on however many records there are on a sheet.

To achieve this flexibility we will need to use some shortcut keys that allow us to select or move to the edge of current data region (however many cells that region contains) and we will need to create an AUTOSUM formula that will automatically adjust the range of cells it is adding up.  Importantly the video also introduces the concept of recording using relative references.  When recording relative references the macro records movement relative to your starting position rather than actual cell addresses.


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

Private training courses can be delivered at your business premises or remotely online anywhere in Buckinghamshire. 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 Buckinghamshire 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.

Excel training locations in Buckinghamshire: Milton Keynes, High Wycombe, Aylesbury, Amersham, Chesham, Gerrards Cross, Hazlemere, Marlow, Newport Pagnell, Buckingham, Beaconsfield, Princes Risborough, Olney, Winslow, Wendover, Iver Heath, Great Missenden, Colnbrook, Chalfont Saint Giles, stoke poges, Aston Clinton, Stokenchurch, Ivinghoe-Pitstone, Long Crendon, Weston Turville, Steeple Claydon, Waddesdon, Newton Longville, Stewkley & Cheddington.