 |
01670 732139 |
 |
steve@itseasy.co.uk |
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
How to add video and sound in LibreOffice Impress
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
How to use LibreOffice Draw to work out a Critical Path
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
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
How to use Solver in Libreoffice Calc
How to use Solver in LibreOffice Calc
Linked flowcharts in Visio
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
Multiple headers and section numbering in Microsoft Word
How to create a date range form in Microsoft Access
move Excel data to Microsoft Project
How to link data with Paste Special
Customize the Quick Access toolbar
Critical path analysis in Microsoft Visio
How to print titles on every page in Libreoffice Calc
Set titles to repeat on every page
This video explains how to use bookmarks and fields in Microsoft Word
Create a sales database part six, concatenate reports in Microsoft Access
How to create effort driven tasks in Microsoft Project
How to add an outline numbered list in LibreOffice Writer
Work Breakdown Structure in Microsoft Visio
PowerPoint for beginners. Microsoft PowerPoint tutorial
Mail merge for beginners in Microsoft Word
How to sort a table in Microsoft Word
How to create a sales database part five, command buttons
Text Compare add in for Microsoft Excel, compare two lists
How to add columns and sections in LibreOffice Writer
How to create an S Curve chart in LibreOffice Calc
This video explains how to save a baseline in Microsoft Project
This video explains how to create an input form in Microsoft Access
How to create multi-level validation lists in Microsoft Excel
Validity lists in LibreOffice Calc. Conditional validity lists
This video explains how to link PowerPoint to Word
This video explains how to link PowerPoint with OneNote
Create a directory and merge to individual files in Microsoft Word
Visio basics, Shape data and Data Graphics
This video explains how to create a sales database part three
How to adjust Indents in Libreoffice Writer
This video explains how to use progress lines in Microsoft Project
How to use named cells and ranges in Microsoft Excel
Basic concepts in Microsoft Visio, getting started guide
Add a video to every slide in Microsoft PowerPoint
How to create a sales database in Microsoft Access part two
Data analysis in LibreOffice Calc with Goal Seek
How to adjust Indents in Microsoft Word
How to fix paste special issues in Microsoft Excel, Word and PowerPoint
This video explains how to link files and sheets in Microsoft Excel
This video explains how to use constraints in Microsoft Project
This video explains how to create a sales database in Microsoft Access
How to use marketing shapes and diagrams in Microsoft Visio
How to use forms in LibreOffice Calc
How to create a catalog of photos in Microsoft Publisher
This video explains how to trim a video in Microsoft PowerPoint
How to find Tabs in Microsoft Word
How to automatically update a time sheet in LibreOffice Calc
How to use Timelines in Microsoft Project
Use the Weekday function to populate a time sheet in Microsoft Excel
How to create a relationship with Power Pivot in Microsoft Excel
How to create a lookup form in Microsoft Access
Organisational Charts in Microsoft Visio
How to add columns and sections in LibreOffice Writer
How to add two Themes in one presentation. Microsoft PowerPoint Themes
How to fix Footer problems in Microsoft Word
How to create a fixed duration task in Microsoft Project
This video explains how to post to social media automatcially using Powe…
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
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.