Monthly Archives: May 2019

Custom Fields

This video explains how to create custom fields in Microsoft Project. The tutorial covers creating lookup fields, IIF functions and DateDiff functions. The video also explains how to use the graphical indicators and save a modified Gantt chart view table as a new table.

Online courses at http://www.itseasytraining.co.uk

Baselines

This video explains how to save a baseline, how to run reports and design your own custom reports in Microsoft Project. The tutorial shows how to insert columns change the default tracking table and update tasks using the tracking table. The video demonstrates how to view different baselines and select other baseline views. Online courses at http://www.itseasytraining.co.uk

Network Diagram

This tutorial explains how to use the Network view, the task usage view, resources usage view, how to create a work contour and how to create you own view in Microsoft Project. The video also explains the Team Planner and the Timeline views. Online courses at www.itseasytraining.co.uk

Hot tips and time savers

This tutorial explains how to save time in Excel and therefore save money. The video covers some of the more common key commands and features such as flash fill, inserting columns, selecting data sets, time commands, saving shortcuts and instant charts.


Online courses at www.itseasytraining.co.uk


Resource Pool

This tutorial explains how to create a resource pool and how to resolve resource over allocations with resource levelling and setting overtime.

Online courses at http://www.itseasytraining.co.uk

Adding resources

This video explains how to create a resource list in Microsoft Project using the resource sheet and how to add resources to tasks using the assign resource feature. The tutorial also explains how to edit resource information by changing the Cost table settings, the Working time settings and how to embed documentation such as Word or Excel files.

Project links

Start to start, finish to finish, start to finish, finish to start

This MS Project tutorial explains how to link tasks in Microsoft Project and the four task types. The video explain how to add lead time and lag time and how to split tasks. Towards the end of the tutorial task constraints and deadlines are covered. Training at www.itseasy.co.uk Online courses at www.itseasytraining.co.uk

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

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 part of the tutorial focuses on Pivot tables, timeline, charts and slicers, including calculations. The final part is the use of the SumIF function and charts to produce a dynamic chart.

On-line courses are at www.itseasytraining.co.uk check them out.