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