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


Avoid date errors

Table Properties in Microsoft Access One of the better ways to avoid date errors in Microsoft Access is the use the table properties feature. In table properties you can set up a validation rule and display validation text. This method restricts how data is entered at source. Avoid date errors By default, the data type

Read More


Interactive Forms

How to create interactive forms in Microsoft Word The first step in creating an interactive form is to make sure that the developer tab is active in your version of Microsoft Word. Select the File tab and then options. Now select the Customise Ribbon option and tick the developer tab so that it is on.

Read More


Multiple Scenarios

Create Multiple Scenarios in Microsoft Excel The Scenario Manager in Microsoft Excel is part of the What IF Analysis tools feature found on the Data tab of the Ribbon. Users can add different scenarios all with different data sets, and then see the impact through the Scenario Manager. Actual It is recommended to create an

Read More


Custom filters

Custom Filters in Microsoft Project To create your own custom filters, select the View tab of the Ribbon and then filters. In the filters area, select New filter, and in the presenting dialogue box, type your criteria. In the video, the tutor demonstrates how to create two custom filters. The first filter searches for tasks

Read More


Multiple presentations

Combine Presentations To add multiple presentations to one file, select Custom Shows from the Slide Show part of the ribbon. The custom show feature enables users to select a random number of slides to create a specific show. Each show runs independently of the main presentation and does not include all the slides.  Hyperlinks Once

Read More


Drop down lists in Access

Lookups in Microsoft Access There are several places to create a drop down list in Microsoft Access. The lookup lists are very useful in avoiding typos and stopping disallowed entries being added to a database. Combo Box Lookup The Combo box drop down list is one of two display options available within lookup properties. The

Read More


Remove Columns

How to remove columns in Microsoft Word To add or remove columns in Word the first stop is the Layout tab on the Ribbon. The Columns feature displays several options. Once you select the number of columns required they are displayed on the ruler. To move between columns you will have to insert a Column

Read More


What is the Bradford factor?

The Bradford factor is a tool used by HR to track, monitor and review absenteeism. The tool was developed in Bradford university and is used widespread in business. Bradford Formula The Bradford factor is quite a simplistic tool. Each sick day is recorded, and each separate sick occurrence is also recorded. Once all the data

Read More


HR Tracker

Tracing HR Trends The HR Tracker can be used to track sickness, absent staff, holidays, and lateness. Basically, whatever you want to track you can use conditional formatting in Microsoft Excel to help analyse it. Conditional Formatting Each word or letter can be formatted to display a colour in Excel. In this case, blue =

Read More


Email merge from Outlook

Email merge Email merge is part of the mail merge feature that comes with Microsoft Word and other word processing packages. Mail merge is often started from Word, where the first step is to connect the email message or document to a data source. However, mail merge can be started from the data source directly.

Read More


Link cells together

Join cells together in Libreoffice Calc There are two main ways to link cells together in Calc, using the Concatenate function or using the & symbol. Both methods will pull data from separate cells and join them together. If you require spaces between the cell information, add open quotes and then a space, followed by

Read More


Design a room

How to design a room in Microsoft Visio Using Microsoft Visio makes designing a room easy and simple. The first step is to create the room shape. Once the outside dimensions are added, add doors and windows. Electrical sockets and furniture are added next. Make sure the furniture measurements are correct, this can be done

Read More


Split Tasks in Microsoft Project

Splitting Tasks There are several ways to split a task in Microsoft Project, using the ribbon, using resource usage or resource levelling. Splitting a task may be required if there is over allocation issues or sickness. Split Tasks using the ribbon To split a task using the ribbon, select the Home tab and then the

Read More


Access Templates

Templates What is a template? A template is a preformatted design and build of a database. Templates are found in the File and New area of the Access backstage view. There are many pre-loaded Access templates which are always good to look at to get ideas or use if you have understanding of how Access

Read More


Templates in PowerPoint

Template or Theme What are templates in PowerPoint? A template is a master copy of a design, structure, or both. Microsoft PowerPoint provides a multitude of different templates ready for use. These templates have both design and a suggested structure. Templates are accessed via the File tab on the ribbon and the new option. Once

Read More


Fix Errors in Excel

This is a Microsoft Excel tutorial covering error messages and how to fix them. The errors covered are: Name, N/A, Div/0, Value and not an error exactly but hashtags. The Value Error The tutor starts off by demonstrating the Value error. The value error occurs when there is a text string present in a formula.

Read More


Calculations in Word tables

This is a Microsoft Word tutorial covering, how to add up in Word tables, how to calculate, how to use functions in a Word table. The tutor starts off by creating a small Word table and places a second Word table around it to act as a numbering table. The tutorial uses the Sum above

Read More


Two way lookup

This is a tutorial on LibreOffice covering, LibreOffice Calc. The tutorial explains how to use the Match and Index functions with named ranges to create a two way lookup. The tutor starts off by demonstrating how to use the match function with named cells and ranges. The tutor goes on to explain how the Index

Read More


What is Visio

This is a Microsoft Visio tutorial covering shapes connections and design, background pages and titles, flowcharts, and shapes data. The tutor starts off by creating a simple basic diagram and uses some of the drawing tools to connect shapes and add connection points. The tutor goes on to format shapes and group them. The second

Read More


Email Merge

This video explains how to merge emails. Use mail merge to send multiple emails. This is a mail merge tutorial covering email merge. The tutor starts off by starting the mail merge process from the mailing tab in Microsoft Word. The tutor attached a database source to the email document. Once the database is attached

Read More


Create labels

This is an Access tutorial covering labels and mail merge in Word. How to create labels in Access and Microsoft Word. The tutor starts off by creating labels in an Access database. The tutor selects a pre-set label style and adds the field information. The tutor mentions that if the pre-set style do not list

Read More


Mail merge with Power Automate

This video explains how to mail merge using Power Automate. This is a Power Automate tutorial covering mail merge, Excel tables and Outlook. The tutor starts off by explaining how to create a data source in Excel, using the Format as Table feature. The tutor mentions that it is very important to make sure that

Read More


Change task mode

This is a Microsoft Project tutorial covering, how to change the default task mode, how to add the Entry bar and how to view and edit the View bar. The tutor starts off by explaining different ways to change the task mode in a file. The tutor then covers how to change the task mode

Read More


Do you know how to use OneNote templates

This is a Microsoft OneNote tutorial covering, saving templates, using templates, and creating links in templates. Can you use and create templates in OneNote? The tutor starts off by creating a template with inks to an Excel spreadsheet and a Visio diagram. The tutor saves the current page as a template, calling it links. Following

Read More


Feeback forms in Access

This is a Microsoft Access tutorial covering, feedback forms, option groups, reports and report calculations. The tutor starts off by adding two number fields to a table, these fields will store the feedback data. The tutor then creates a form and uses the option group control to add two option groups. The tutor mentions that

Read More


How to count multiple items by date range

How to use the Countifs function to count multiple items based on a date range in Microsoft Excel. This is a Microsoft Excel tutorial covering, Countifs, named ranges and the Today() function. The tutor starts off by explaining how the Countifs function works and demonstrates it on an example. The tutor then recreates the example,

Read More


Sorting and numbering in a Word table

This video explains how to sort and number a Microsoft Word table. Sorting and Numbering. The tutor starts off by sorting a Word table, mentioning that it is best to the select my table has headers option. The tutorial states that each search column selected only sorts that column, moving on to the next search

Read More


Avoid text in overflow

This is a Microsoft Publisher tutorial covering, text in overflow, linking text boxes and text boxes. The tutor starts off by linking three text boxes and demonstrating text in overflow. The tutor goes on to explain how to link text boxes across multiple pages. The final part of the video covers how to identify linked

Read More


Power BI reports

This is a Power BI tutorial covering, basic reports, charts, tables and maps. The tutorial also covers how to format a chart with colours, data labels and filters. The tutor starts off by selecting a data source, mentioning that the data can be inserted into Power BI straight away or manipulated first. The tutor explains

Read More


Percentages in Excel

This is a Microsoft Excel tutorial covering, percentages, percentage difference, percentage of, percentage amount and conditional formatting. The tutor starts off by explaining how to create a percentage difference formula. The tutor demonstrates two methods. The tutor goes on to cover how to find a percentage based on sales and products produced. The video also

Read More


How to create and edit styles

This is a Microsoft Word tutorial covering, styles, edit styles, new styles and deleting styles. The tutor starts of by highlighting formatted text on the screen and creating a new style from it. The tutor goes on to create a new style from the styles pane. The tutor mentions that styles will appear in all

Read More


What is a critical path?

This is a Microsoft Project tutorial covering critical path and formatting critical paths. The tutor demonstrates how to display a critical path. The tutor goes on to explain how to show multiple critical paths by changing settings in options. The tutorial also covers how to change the trigger duration for a critical path. The tutor

Read More


Join Types in Access

This video is a Microsoft Access tutorial covering join types, relationships and queries. The tutor starts off by adding three tables to the database relationship window. The tutor creates two, one to many relationships. Following on, the tutor creates three queries demonstrating each of the three join types and the results expected. The tutor mentions

Read More


Sort shape data in Visio

This is a Microsoft Visio tutorial covering, sorting shape data, sorting shape titles and document stencil. The tutor starts off by explaining how to change the order of information that appears as a shape title. The tutor then covers how to change the order of shape data in the shape data window. The tutor uses

Read More


Vlookup in LibreOffice Calc

This video explains how to create a Vlookup and Hlookup in LibreOffice Calc. This is a LibreOffice calc tutorial covering, Vlookup, Hlookup and the IF function. The tutor starts off by creating a simple Vlookup using named cells and ranges. The tutor repeats the process to demonstrate how to create a Hlookup function. Hlookup stands

Read More


Hot spots and animated Gifs in PowerPoint

This video explains how to add a hot spot and an animated gif to a Microsoft PowerPoint presentation. The tutor starts off by showing a completed example of a presentation with hot spots and animated gif. The tutor then recreates a flowchart and saves it as an animated gif. The tutor then inserts the animated

Read More


Schedule an email

This video explains how to schedule an email in Microsoft Outlook. Delay emails. Schedule emails in the desktop or online version of Outlook. The tutor starts off by creating a new mail message and then moves the Options area on the ribbon. In options the tutor explains how to set the delay for the email.

Read More


Add Calculations to a Pivot Table

This video explains how to add calculations into a Pivot Table in Microsoft Excel. Calculations in a Pivot table. The tutor starts off by creating a simple Pivot table, adding a few fields with numbers in. The tutor then covers how to add a calculated field to work out markup and then profit. The final

Read More


Table of Contents in LibreOffice Writer

How to add a table of contents in LibreOffice Writer. Table of contents. The tutor starts off by explaining how to add a heading style to a document, and then, if required how to change the style. The tutor goes on to insert a table of contents which picks up all the heading styles and

Read More


Mail Merge Photos

This video demonstrates how to use mail merge to merge photos into a Microsoft Word document. The tutor uses an Access database as the data source and explains that the database has file paths to photos. The tutor then starts the mail merge process by adding the database as the data source. The tutor then

Read More


Signatures in Outlook

This video explains how to add a signature in Microsoft Outlook. Signatures. The tutor demonstrates two ways to add a signature in Outlook. The first option in through options and then the mail option. This area gives access to the signature feature. The tutor focusses on the second way to add a signature, which is

Read More


What is a baseline?

This video explains what a baseline is in Microsoft Project. Baselines. The tutor starts off by explaining a small project plan with links and resources added. The tutor mentions that a baseline is a snapshot of the plan for a Project. The tutor covers how to save a baseline and how to update a baseline.

Read More


What is Access

This video explains how to use Microsoft Access for beginners. What is Access. Access is a relational database package. The tutorial covers how to create and import a table of data. The tutor then explains that the data can be interrogated via a filter or more likely a query. The tutor goes on to create

Read More


Pivot tables in Libreoffice Calc

In this video the tutor demonstrates how to create two Pivot tables. One table using a named range and the second without using names. The tutor adds a chart to both Pivot tables. On the second example the chart displays on two axes. The tutor uses the options feature to activate the drill down feature.

Read More


Insert files into Word

The tutor covers how to insert files into a Microsoft Word document. Insert Objects. The tutor starts off by inserting a Word file into a word document using the Insert object feature. The tutor displays the files as an icon and then as an expanded object. The tutor goes on to insert an Excel file

Read More


CountIF function in under 60 seconds

CountIF in less than 60 seconds. Use a CountIF function to count data by category. Use CountIF with named ranges to avoid locking cells or columns with dollar signs. This is a Microsoft Excel tutorial under 60 seconds, covering CountIF and named ranges. Countif is one of Excel’s Count functions. Count, CountA, CountIF and CountIFS.

Read More


Connect to images in Visio

This video explains how to connect to images in Microsoft Visio. Microsoft Visio. The tutor inserts two images from the stock image folder in PowerPoint and copies them into Visio to use as a demonstration. The tutor then explains how connection points work covering a shape-to-shape connection and a point-to-point connection. The tutor then creates

Read More


Groups in Office 365

This video explains how to create a group in Office 365. Groups and Teams. The tutor mentions that Groups can be created in many different places. However, using the admin area is one of the better ones. The tutor starts of by opening the admin area in Office 365. The tutor then selects the Group

Read More


Update Queries

This video explains how to add an update query in Microsoft Access. Update query. The tutor covers how to do two update queries. The first update query uses a calculation to increase wages by 10%. The second update query covers how to update a date checked field. The tutor uses parameter queries to explain how

Read More


Vlookup in 60 seconds

This video explains how to create a Vlookup. This is a 60 second preview on how to create a Vlookup in Microsoft Excel. The tutor uses named cells and named ranges to explain how a Vlookup works. This is a Microsoft Excel tutorial covering Vlookup, named cells and named ranges. Vlookup in 60 secs.

Read More


Morph Transition

This video explains how to use advanced morph transition in Microsoft PowerPoint. The tutor starts off by demonstrating how to use the morph transition with the advanced effects applied. The tutor then explains how the morph transition would work without the advanced transition effects. Finally, the tutor names both shapes on show with the same

Read More


Analyze Data in Excel

This video explains how to use the Analyze Data tool in Microsoft Excel. Analyze data. The tutor starts off by selecting a small data set and then clicks the Analyze data button on the ribbon. The tool returns several options including Pivot tables and charts. In the second part of the video the tutor selects

Read More


Custom Reports

This video explains how to create custom reports in Microsoft Project. Custom reports. The tutor starts off by adding a summary table and a resource usage table. The tutor then explains how to add a couple of charts and how to filter and edit the data. The tutor also shows how to use the date

Read More


Conditional formatting in Libreoffice Calc

This video explains how to add conditions to LibreOffice Calc spreadsheets. The tutor starts off by adding three conditions to a list of figures. The conditions display Green, Yellow and Red depending on the amount in the cells. The next part of the video covers how to add a data bar. The tutor mentions that

Read More


Project app in Microsoft Teams

This video explains how to use the Project App in Microsoft Teams. Project app. The tutor starts off by demonstrating a channel with the Project app installed. The tutor then opens a new channel and adds the project app. The tutor creates several tasks linking them together and allocating resources. The tutorial covers how to

Read More


Password protect LibreOffice Calc

This video explains how to password protect cells, sheets and files in LibreOffice Calc

Read More


New in Excel

Excel Spill error

Read More


Microsoft Visio Basics | Getting started

Microsoft Visio Basics

Read More


10 Most Used Excel Functions

These are the 10 most used Excel functions. This video covers the following Excel functions: Sum, SumIF, Count, CountA, CountIF, IF, AND, Vlookup, Index and Match. 10 Most Used Excel Functions These are the 10 most used Excel functions: Use the Sum function to add up lists. The average function can be used to work

Read More


Mail Merge

Merge to a letter These videos explain how to create a mail merge document in Microsoft Word. There are three videos in total, a basic example of a mail merge using letters, envelopes and labels. This video is followed by an advanced mail merge example. In the second video you will learn how to use

Read More


Access Form controls

How to use the form controls in Microsoft Access

Read More


Microsoft Excel Maps

Excel Maps and 3D Maps

Read More


Testimonials


“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




“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