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.
Established in 2005, Blue Pecan provides tailored / bespokein houseExcel 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.
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 ofExcel 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
Online Per Hour
2 - 4
5 - 8
9 - 10
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:
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?