How to use AutoText in LibreOffice Writer

How to use AutoText in LibreOffice Writer

Read More


How to use the Status Date in Microsoft Project

How to use the Status Date in Microsoft Project

Read More


How to insert new captions and reference them in Microsoft Word

How to insert new captions and reference them in Microsoft Word

Read More


Vlookup or Xlookup in Microsoft Excel. Which is better?

Vlookup or Xlookup in Microsoft Excel. Which is better?

Read More


Basic Queries in LibreOffice Base Database



Read More


How to add video and sound in LibreOffice Impress



Read More


How to convert a bullet list into a SmartArt Graphic in one click

How to convert a bullet list into a SmartArt Graphic in one click

Read More


Microsoft Access Queries for beginners.

Microsoft Access Queries for beginners.

Read More


How to Link Excel data to a Visio Timeline. Import Project data into Visio

How to Link Excel data to a Visio Timeline. Import Project data into Visio

Read More


How to create a Heat Map in Microsoft Excel

How to create a Heat Map in Microsoft Excel

Read More


This video explains how to use Sparklines in Google Sheets

This video explains how to use Sparklines in Google Sheets

Read More


How to create a Heat map using LibreOffice Calc



Read More


How to use LibreOffice Draw to work out a Critical Path



Read More


How to create a Heat Map in Microsoft Project

How to create a Heat Map in Microsoft Project

Read More


How to use Quick Parts and Document properties in Microsoft Word

How to use Quick Parts and Document properties in Microsoft Word

Read More


How to insert a Form into a PowerPoint slide

How to insert a Form into a PowerPoint slide

Read More


How to automatically update stock levels in Microsoft Access

How to automatically update stock levels in Microsoft Access

Read More


How to create a Power App based on a SharePoint List

How to create a Power App based on a SharePoint List

Read More


How to create relationships in a Base database. LibreOffice



Read More


Resource availability in Microsoft Project

Resource availability in Microsoft Project

Read More


This video explains how to set Deadlines in Microsoft Project

This video explains how to set Deadlines in Microsoft Project

Read More


How to create a basic database in LibreOffice

How to create a basic database in LibreOffice

Read More


How to link Excel to a Visio organisation chart

How to link Excel to a Visio organisation chart

Read More


How to create a basic database in LibreOffice



Read More


How to use Solver in Libreoffice Calc



Read More


How to use Solver in LibreOffice Calc



Read More


Linked flowcharts in Visio



Read More


Linked flowcharts, cross functional flowcharts and hyperlinks in Visio

Linked flowcharts, cross functional flowcharts and hyperlinks in Visio

Read More


Excel visualisations. Use 3D maps to visualise data

Excel visualisations. Use 3D maps to visualise data

Read More


Excel visualisations. Use 3D maps to visualise data

Excel visualisations. Use 3D maps to visualise data

Read More


Excel visualisations. Use 3D maps to visualise data

Excel visualisations. Use 3D maps to visualise data This is a Microsoft Excel tutorial covering Excel visualisations, 3d maps and video. The tutor starts off by explaining how 3D maps work, covering adding data fields to the map tool and filtering if required. The tutor mentions that for the feature to work you need a

Read More


Excel visualisations. Use 3D maps to visualise data

Excel visualisations. Use 3D maps to visualise data This is a Microsoft Excel tutorial covering Excel visualisations, 3d maps and video. The tutor starts off by explaining how 3D maps work, covering adding data fields to the map tool and filtering if required. The tutor mentions that for the feature to work you need a

Read More


Excel visualisations. Use 3D maps to visualise data



Read More


Multiple headers and section numbering in Microsoft Word



Read More


How to create a date range form in Microsoft Access



Read More


move Excel data to Microsoft Project



Read More


How to link data with Paste Special



Read More


Customize the Quick Access toolbar



Read More


Critical path analysis in Microsoft Visio



Read More


How to print titles on every page in Libreoffice Calc



Read More


Set titles to repeat on every page



Read More


This video explains how to use bookmarks and fields in Microsoft Word



Read More


Create a sales database part six, concatenate reports in Microsoft Access



Read More


How to create effort driven tasks in Microsoft Project



Read More


How to add an outline numbered list in LibreOffice Writer



Read More


Work Breakdown Structure in Microsoft Visio



Read More


PowerPoint for beginners. Microsoft PowerPoint tutorial



Read More


Mail merge for beginners in Microsoft Word



Read More


How to sort a table in Microsoft Word



Read More


How to create a sales database part five, command buttons



Read More


Text Compare add in for Microsoft Excel, compare two lists



Read More


How to add columns and sections in LibreOffice Writer



Read More


How to create an S Curve chart in LibreOffice Calc



Read More


This video explains how to save a baseline in Microsoft Project



Read More


This video explains how to create an input form in Microsoft Access



Read More


How to create multi-level validation lists in Microsoft Excel



Read More


Validity lists in LibreOffice Calc. Conditional validity lists



Read More


This video explains how to link PowerPoint to Word



Read More


This video explains how to link PowerPoint with OneNote



Read More


Create a directory and merge to individual files in Microsoft Word



Read More


Visio basics, Shape data and Data Graphics



Read More


This video explains how to create a sales database part three



Read More


How to adjust Indents in Libreoffice Writer



Read More


This video explains how to use progress lines in Microsoft Project



Read More


How to use named cells and ranges in Microsoft Excel



Read More


Basic concepts in Microsoft Visio, getting started guide



Read More


Add a video to every slide in Microsoft PowerPoint



Read More


How to create a sales database in Microsoft Access part two



Read More


Data analysis in LibreOffice Calc with Goal Seek



Read More


How to adjust Indents in Microsoft Word



Read More


How to fix paste special issues in Microsoft Excel, Word and PowerPoint



Read More


This video explains how to link files and sheets in Microsoft Excel



Read More


This video explains how to use constraints in Microsoft Project



Read More


This video explains how to create a sales database in Microsoft Access



Read More


How to use marketing shapes and diagrams in Microsoft Visio



Read More


How to use forms in LibreOffice Calc



Read More


How to create a catalog of photos in Microsoft Publisher



Read More


This video explains how to trim a video in Microsoft PowerPoint



Read More


How to find Tabs in Microsoft Word



Read More


How to automatically update a time sheet in LibreOffice Calc



Read More


How to use Timelines in Microsoft Project



Read More


Use the Weekday function to populate a time sheet in Microsoft Excel



Read More


How to create a relationship with Power Pivot in Microsoft Excel



Read More


How to create a lookup form in Microsoft Access



Read More


Organisational Charts in Microsoft Visio



Read More


How to add columns and sections in LibreOffice Writer



Read More


How to add two Themes in one presentation. Microsoft PowerPoint Themes



Read More


How to fix Footer problems in Microsoft Word



Read More


How to create a fixed duration task in Microsoft Project



Read More


This video explains how to post to social media automatcially using Powe…



Read More


Compare two lists

How to compare two lists in Microsoft Excel One method to compare a lists is to use the match function. The Match function combined with ISNA and an IF staement provides a great solution when checking one list against another. Match Function The match function works by checking an item against a list, if the

Read More


Resource Pool

Introduction A resource Pool is a set of resources that are made available across multiple projects.  In Microsoft Project sharing resources from a Pool is available from the Resources tab of the ribbon. How to create a resource pool The first step in creating a resource pool, is to add a resource list without any

Read More


Link Word to PowerPoint

Linking There are three ways to link Word to PowerPoint. Embed an object, if it is not to large, Paste special and link or use the hyperlink feature to link to a Word document. Object Inserting an object is a simple process, select the insert tab and then object. In the displayed dialogue box select

Read More


Sums and Functions

FORMULAE Spreadsheet formulae usually contain numbers, arithmetical operators and cell references.  They can be typed in directly or Excel can help build them for you.  You can use all the standard mathematical operators in your formula; e.g. () + – / *. A spreadsheet is an excellent platform to work out sums and functions. ENTERING

Read More


Shape Connections in Microsoft Visio

BASIC DIAGRAMS  The following example shows some of the basic drawing principles. To add shapes simply drag them on to the drawing canvas. Shape connections, types and methods of changing connections are covered later. Several shapes are positioned onto the drawing canvas. When you drop the shape on the grid it will snap to the

Read More


Saving a template in Microsoft Project

Saving a template in Microsoft Project, saves time, focusses teams and keeps plans standard. Templates in Project are stored in either the personal templates folder or a network folder. Use Project options to change folder location. Template setup Design the task list and add the links. Embed any external documents. Once the task list and

Read More


Scheduling in Visio

Timeline One of the scheduling tools in Microsoft Visio is the timeline tool. The timeline has block intervals, today marker, elapsed time indicator and much more. Timelines have an expand feature which focuses in on a date range. The Shape data window displays % complete and other related data. Gantt Chart The Gantt chart template

Read More


Link Excel to Visio

Link and Excel spreadsheet to a Visio Flowchart The first step to linking Excel data to a Visio flowchart is to create a blank flowchart. On the Ribbon, select the Data tab and Quick Import from Excel. A wizard starts and once the correct file is selected, the data links appear along with the data

Read More


Gantt Chart in Visio

How to create a Gantt Chart in Microsoft Visio The Gantt Chart feature is under the Scheduling category in Microsoft Visio. There are three options: A Calendar, a Timeline and a Gantt Chart. Select the option required.. Timescale The timescale and date formats are set on the first screen in Gantt Chart options. The number

Read More


Task Priority

Task Priorities in Microsoft Project Changing task priorities in Microsoft Project is a simple task. The first step is to open the task information dialogue box. The default task priority is 500 but the range allowed is 1 – 1000. A task with a priority of 1000 is a task that would not move during

Read More


Testimonials


“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA




“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd




“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group




“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services