![]() |
01670 732139 |
![]() |
steve@itseasy.co.uk |
How to use AutoText in LibreOffice Writer
Read More
How to use the Status Date in Microsoft Project
Read More
How to insert new captions and reference them in Microsoft Word
Read More
Vlookup or Xlookup in Microsoft Excel. Which is better?
Read More
How to convert a bullet list into a SmartArt Graphic in one click
Read More
Microsoft Access Queries for beginners.
Read More
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
Read More
This video explains how to use Sparklines in Google Sheets
Read More
How to create a Heat Map in Microsoft Project
Read More
How to use Quick Parts and Document properties in Microsoft Word
Read More
How to insert a Form into a PowerPoint slide
Read More
How to automatically update stock levels in Microsoft Access
Read More
How to create a Power App based on a SharePoint List
Read More
Resource availability in Microsoft Project
Read More
This video explains how to set Deadlines in Microsoft Project
Read More
How to create a basic database in LibreOffice
Read More
How to link Excel to a Visio organisation chart
Read More
Linked flowcharts, cross functional flowcharts and hyperlinks in Visio
Read More
Excel visualisations. Use 3D maps to visualise data
Read More
Excel visualisations. Use 3D maps to visualise data
Read More
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 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
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
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
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
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
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, 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
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 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
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 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
“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
You must be logged in to post a comment.