Skip to content

In-House Excel Training – Live Online

    Blue Pecan offers online, remote desktop training in Microsoft Excel in a virtual classroom.  Using Zoom, Webex or Team video conferencing software we are able to provide interactive Excel courses with a live tutor. As with all our Excel courses, remote or onsite, you can either follow one of our published outlines or ask us to tailor a course outline for you.

    Remote Training : What You Need in Order to Participate

    Delegates will need the following things in place to participate in the remote training:

    – A PC/laptop with Microsoft Office installed.
    – A webcam, so the tutor can see you – most laptops have a built-in webcam, but for a desktop PC you will probably need a separate one.
    – A microphone*, so the tutor can hear you – again most laptops have a built-in microphone, but for a desktop PC you will probably need a separate one.
    – A speaker or headphones*, so you can hear your tutor – again most laptops will have built-in speakers, but for a PC you will probably need separate one.
    – An internet connection.

    *A combined microphone and headphone set would work perfectly with the video conferencing software and the remote training we offer.

    A second screen is preferable so that you can view the tutor’s demonstration on one screen and your work on another.  However, this is not essential and we will give you instructions on how to display both on one screen.

    On the day of the training, we will email you a link that will enable you to join the training session.  You do not need to install anything on your computer prior to receiving this email.

    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

    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.