Skip to content

    In-House Excel Training On-site or Online

    Established in 2005, Blue Pecan provides tailored / bespoke in-house Excel training courses. We offer Beginners, Intermediate and Advanced Excel training. Courses can be tailored and include your working files to make them as relevant as possible.

    On-site Courses - Excel courses can be delivered on-site at your business premises.

    Live Online Courses- Excel courses can be delivered online with a live tutor via Zoom, Microsoft Teams or Webex virtual classroom software.  Please see our Excel remote training information page which will explain all you need to know about our virtual Excel classroom.

    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 Microsoft Excel including Excel 365, 2019, 2016 & 2013.

    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.

    Pricing is per group not per individual.

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

    No. of delegatesOn-site full dayOnline full day
    1 - 10£795£745
    Additional delegates+£35+£35

    All prices are excluding VAT. 

    On-site training travel expenses included for Sussex, Surrey, Hampshire, Berkshire, Buckinghamshire, Kent, Oxfordshire, London and parts of 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:

    Out Recent Blog Posts and YouTube Video Tutorials

    Convert Numbers into Words in Microsoft Excel – With or Without Currency | VBA Included in Download

    In this Microsoft Excel video tutorial I explain how to convert numbers into their words equivalent. You can do this using a VBA custom function. A version of this function is available on Microsoft’s website: https://support.microsoft.com/en-us/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98 I found this version of the function, although very good, had some spacing and wording issues; it also only… Read More »Convert Numbers into Words in Microsoft Excel – With or Without Currency | VBA Included in Download

    Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List

      In this video tutorial I demonstrate how to show/hide rows or columns or tables based on a drop-down list selection. This particular technique requires VBA code which I supply via the link above. Click here to download the featured file (including code). Video Table of Contents 00:00 – Introduction 00:49 – Create the data… Read More »Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List

    Dynamic Amortization Schedule Excel 365 Template | EMI Calculator with Repayment Schedule in Excel

      In this video I demonstrate how to build an amortization schedule in Microsoft Excel. An amortization schedule displays principle and interest payments for each month over the term of a loan. The schedule is fully dynamic in that it expands and contracts to display the correct number of rows for loan’s tenure. The functions… Read More »Dynamic Amortization Schedule Excel 365 Template | EMI Calculator with Repayment Schedule in Excel