![]() |
01670 732139 |
![]() |
steve@itseasy.co.uk |
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
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
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
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 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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
This video explains how to password protect cells, sheets and files in LibreOffice Calc
Read More
Excel Spill error
Read More
Microsoft Visio Basics
Read More
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
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
How to use the form controls in Microsoft Access
Read More
Excel Maps and 3D Maps
Read More
“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
You must be logged in to post a comment.