Since some people are still unable to have face-to-face training, or might prefer not to spend a whole day in training, we are pleased to be able to announce some interactive short Online training sessions – suggested topics are below but we are happy to accommodate other alternatives at your request. We are also happy to do any of our full-day courses as full day remote training.
Sessions will be conducted using Microsoft Teams or Zoom.
Training files and a meeting invitation will be sent out to participants in advance of the training session. Dates and times are to be arranged at mutual convenience.
To sign up for any session, ring us on 01747 820396 or 07477 578417, email to janet@archwayct.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