Menu

    Call us on:
    07477 578417

Online training

Since not everyone is able to have face-to-face training at present, we are pleased to be able to announce some interactive short Online training sessions. We are also happy to do any of our full-day courses as full day remote training.

Our online training sessions will be conducted using Microsoft Teams or Zoom. Dates and times are at mutually convenient time.

Training files and a meeting invitation will be sent out to participants in advance of the training session.

To sign up for any online training session, ring us on 07477 578417, email to janet@jmdtraining.co.uk or fill in our contact form and we will get back to you.

Number in session Price per hour
1 to 1 £50 + VAT
2 to 4 people £75 + VAT
5 to 8 people £100 + VAT
Slots from which you could choose include:

Microsoft Word

  • Using Word tables, general Word hints and tips – 1 hour
  • Working with Pictures and Drawing Objects – Inserting, Text Wrapping, Sizing, Effects – 1 hour
  • Collaborating with Others – Sharing Documents, Comments, Track Changes – 1 hour
  • Mail merge – 1 hour
  • Using Section breaks effectively – 1 hour
  • Working with Large Documents – Heading Styles, Section Breaks, Automating Tables of Contents – 1 hour

Microsoft Excel

  • Creating a new workbook, Basic Formatting, Basic Formulas, Saving, Printing – 1 hour
  • Review of Basic Formulas, Absolute cell references (fixed cells), % of Totals, Using Quick Analysis for % of Totals and Cumulative Totals – 1 hour
  • Grouping worksheets, Calculation across worksheets, Data Consolidation – 1 hour
  • Sorting, Filtering, Conditional Formatting – 1 hour
  • Charting – 1 hour
  • Date and Text Functions – 1 hour
  • IF, Nested IF, AND, OR, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, IFERROR – 1.5 hours
  • Named ranges, VLOOKUP, XLOOKUP – 1 hour
  • Pivot Tables – 1 hour

Microsoft PowerPoint

  • Creating a new presentation, Slide Layouts, Slide Views, Moving Slides – 1 hour
  • Working with SmartArt, Animating SmartArt and Bulleted Lists – 1 hour
  • Tables and Charts – 1 hour
  • Using SmartArt, Animating bulleted lists and SmartArt, Using Drawing Tools, Manipulating Pictures – 1 hour

Microsoft Outlook

  • Calendar, Creating Recurring Appointments, Making Appointments private, Using the Scheduling Assistant – 1 hour
  • Email Rules and Alerts, Creating a Task from an Email, Creating an Appointment from an Email, Quick Parts, Email Templates – 1 hour

Microsoft Project

  • Working with Tasks, Creating a Gantt Chart, Links, Lags and Leads – 1.5 hours
  • Creating a resource sheet, Assigning resources to tasks – 1.5 hours
  • Views, Tables, Filters, Creating Reports – 1.5 hours
  • Adding costs to projects – 1 hour
  • Creating Reports -1 hour
  • Baselining a project and tracking progress – 1 hour
  • Consolidating Projects in a Master Plan, Pooling resources across Projects – 1.5 hours

Crystal Reports

  • Creating and formatting a report – 1.5 hours
  • Sorting Records, Filtering Record, Grouping Records, Summary Fields – 1.5 hours
  • Mailing labels – 1 hour
  • Charting – 1.5 hours
  • Parameter Queries – 1.5 hours
  • Formulas and Functions – 1.5 hours
  • The Section Expert and Advanced Formatting – 1.5 hours
  • Working with Subreports – 1 hour
  • CrossTab Reports – 1.5 hours

Professional Development Skills

  • Communication Skills – Questioning Techniques, Listening Skills, Aggressive, Defensive and Assertive Behaviour – 2 hours
  • Coaching Skills – the key to successful delegation – 2 hours
  • Using Outlook for Time Management – 1 hour
  • Time Management – Goals and Objectives, The SMART approach to generating goals, Identifying Goals, Prioritising Work, Urgent vs Important – 1 hour
  • Time Management – Setting goals and priorities, Urgent vs Important – 1 hour
  • Delegating – How to delegate effectively – 2 hours
  • Team Building and Motivation – 2 hours