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

---

Access courses

Access courses for update queries

Read More

---

Relational database in Microsoft Access

How to create a relational database

Read More

---

Access Reports

How to create reports in Microsoft Access

Read More

---

Microsoft Training Courses

Overview The Microsoft Office , Project and Visio buttons displayed below link to the course outlines for classroom based courses. If you wish an online course go to http://www.itseasytraining.co.uk You can assess your knowledge levels by completing the Excel document here Check Skill Level Once you have completed the document email to info@itseasy.co.uk You can book

Read More

---

Microsoft Access database table design

How to create a Microsoft Access database part 2

Read More

---

Access database

Access database

Read More

---

Street Map in Visio

Visio street map

Read More

---

Lookup Images in Microsoft Excel

How to lookup images in Microsoft Excel

Read More

---

Database Functions in Microsoft Excel

Database function in Microsoft Excel

Read More

---

Visio brainstorming diagram

Visio protection and charts

Read More

---

Visio linked data

This video explains how to create a flowchart using the Visio linked data wizard, pulling the data from Microsoft Excel into a Visio flowchart diagram. The video also explains how to import data from Microsoft Project in to a Visio timeline diagram. The tutorial covers how to edit data graphics in Microsoft Visio and how

Read More

---

Visio Reports

Visio reports

Read More

---

How to create a Floor Plan using Microsoft Visio

Visio floor plan

Read More

---

Visio Gantt charts

How to use Microsoft Visio Gantt charts

Read More

---

Synchronised shapes in Microsoft Visio

How to create an organisational chart and use synchronise copies

Read More

---

Cross Functional flowcharts in Microsoft Visio

How to create a cross functional flow chart

Read More

---

How to use PowerPivot in Microsoft Excel

How to use PowerPivot in Microsoft Excel

Read More

---

Microsoft Visio basics

How to use Microsoft Visio basic shapes and format them

Read More

---

PST files in Microsoft Outlook

How to create a PST files and use quick steps in Microsoft Outlook

Read More

---

Microsoft Word Basics

How to case and use the hidden text feature in Microsoft Word

Read More

---

Microsoft Project Tips and Tricks

Microsoft Project Tips and Tricks

Read More

---

Custom Fields in Microsoft Project

How to use customs fields and functions in Microsoft Project

Read More

---

How to set a Baseline in Microsoft Project

How to save a baseline, update tasks and create reports in Microsoft Project

Read More

---

Network Diagram in Microsoft Project

How to use other views in Project

Read More

---

Hot tips and time savers in Microsoft Excel

Hot tips, save money save time

Read More

---

Microsoft Project Resource Pool

How to use the resource pool and resource leveling

Read More

---

Adding resources to Microsoft Project

Adding resources in Microsoft Project

Read More

---

Microsoft Project linking tasks

Microsoft Project link types

Read More

---

MS Project Gantt charts

This tutorial explains how to create a task list in MS Project and format the Gantt chart, timeline and calendar. The video also explains how to add project fields to the print output and embed documents into tasks. Training at www.itseasy.co.uk Online courses at www.itseasytraining.co.uk

Read More

---

Microsoft Excel Intermediate course

This tutorial overview explains what is covered on the Intermediate Excel course at www.itseasy.co.uk or www.itseasytraining.co.uk (online courses). The video demonstrates the use of Names and Named ranges in Excel, how to use Conditional formatting in Excel. How CountIf and Subtotals can be used. The video also explains the IF function and Vlookup. A large

Read More

---

SumIF charts in Microsoft Excel

This tutorial explains how to create a chart on two axis and how to create a Dial chart and a Waterfall chart and a column chart that has the SumIF function and the date function driving the data. Training at www.itseasy.co.uk online courses at itseasytraining.teachable.com

Read More

---

Visio Timeline

his tutorial explains how to create a timeline in Visio and how to add milestone and interval markers. The video explains how to move milestone around and how import data from a Microsoft Project file and finally how to send a Visio timeline in to MS Project Training at www.itseasy.co.uk

Read More

---

IF Statements

Three conditional statement used in Excel

Read More

---

Data Analysis in Microsoft Excel

Data analysis tools

Read More

---

Hyperlinks in PowerPoint

Automate PowerPoint

Read More

---

Index Function with Match

better than vlookup

Read More

---

Named cells and ranges in Excel

Watch a Tutorial to explain Named cells, Ranges in Excel 2019 This tutorial explains how to create named cells and named ranges in Microsoft Excel 2019. The video covers how to create names and common mistake people make when doing so. The tutorial explains how to refer to names in formulae and how named ranges

Read More

---

Microsoft Project from start to finish

How to use Microsoft Project

Read More

---

Visio Flowcharts

Flowchart in Visio This video explains how to create a simple flowchart in Microsoft Visio. The tutorial explains how to add shapes and how to connect shapes. The video also shows how to use the connector tool to add additional connecting lines. How to add text to a connector line. How to use the off

Read More

---

Are scripted courses coming to an end?

I have often wondered why so much effort is put into the aims and objectives of a training sessions, or what you will learn statements.  In my experience it is very difficult to decide what someone else will learn in a set period of time.  Some people will achieve everything listed in the objectives and

Read More

---

How to create Pivot table calculations in Microsoft Excel

How to use pivot table calculations    

Read More

---

Pivot table grouping dates

How to group dates in Microsoft Excel Pivot tables  

Read More

---

Pivot table charts

How to add pivot table charts

Read More

---

Pivot tables grouping

How to use the pivot tables grouping feature in Microsoft Excel

Read More

---

How to use a Pivot table in Microsoft Excel

How to create a simple Pivot table in Microsoft Excel 2014

Read More

---

How to change working time in Microsoft Project

How to change working time in Microsoft Project 2013

Read More

---

Basic IF function in Microsoft Excel

Basic IF.  This video explains how to create a basic IF function in Microsoft Excel.  The video tutorial uses named ranges to explain how best to design and create an IF statement.

Read More

---

Nested IF

Nested IF statement

Read More

---

Excel Training IF and And Function

How to use an IF and And Function in Microsoft Excel Training courses with IT’s Easy Training

Read More

---

Microsoft Project Training

How to link tasks in Microsoft Project.  Microsoft Project Training provided in groups or on a one to one basis.  Consultancy also available on request.

Read More

---

Grouping Sheets in Excel

This video explains how to group sheets together in Microsoft Excel, which enables users to quickly add data formatting to multiple sheets.

Read More

---

How to use the Data Tables Feature

This video shows you how to use the Data Tables feature.  You will learn more detailed uses on the Intermediate Excel course.

Read More

---

Using the Scenario manager in Microsoft Excel

This video shows how to use the Scenario manager. There are many other uses besides the one shown, email for course details

Read More

---

How to use the Grouping feature in Excel

How to use the Group and Outline feature in Excel

Read More

---

Linking texts boxes in Microsoft Publisher

How to link text boxes in Microsoft Publisher. The following video shows how to use the link text box tool to create a flow through several linked boxes. The same procedure can be used in Microsoft Word.

Read More

---

How to use Time calculations in Excel

This video shows an example of using the Date Time format with calculations to display hours difference when it is either less than 24hrs or greater than 24hrs.    

Read More

---

How to use Vlookup in Microsoft Excel

This video show how to use the Vlookup Function

Read More

---