Got data in an Excel spreadsheet that you want to use to create an organisation chart. Visio makes it easy to create an organisation chart from an Excel spreadsheet.

This feature works very well in business situations to collect data from others who do not have Visio on their machines. By using an Excel template you can collect organisational data and incorporate it in your Visio diagram.

Below is some sample data stored in an Excel spreadsheet.

To create an organisation chart in Visio from this Excel data;

[Read more…] about Create an Organisation Chart in Visio from an Excel Spreadsheet

Set a baseline for your project so that you can track its progress against the original project plan. A baseline is a reference point for the project schedule. It can be used to measure the project progress in certain categories.

The baseline saves nearly 20 reference points in 5 different categories for all the tasks in your project. These are the Start Dates, Finish Dates, Durations, Work and Cost. For an effective baseline you should ensure that these estimates are accurate in your project before you set the baseline.

[Read more…] about Use a Baseline to Measure Project Progress

Are you looking to try and work faster in Microsoft Word. There are many great tools to improve productivity and save time in Word.

Check out these 5 top Microsoft Word tricks to save time and effort when working on your documents.

[Read more…] about 5 Time Saving Microsoft Word Tricks

It is very easy to see two presentations at the same time in PowerPoint. This can be useful to compare the two presentations.

It may be that you need to compare last years presentation to this years, or to check a colleagues version against yours. Whatever the reason, fortunately, there is a feature to view the presentations side by side on screen at the same time.

[Read more…] about See Two Presentations at the Same Time

Add a deadline date to a task to keep track of it’s finish date against the deadline. As Microsoft Project updates the schedule a warning will appear if the task is due to miss it’s deadline date.

Using a deadline is considered a better approach than using a constraint. By using a deadline, Project continues to schedule tasks and displays a warning for any potential problems. But a constraint is inflexible and limits the scheduling of the project.

[Read more…] about Add a Deadline Date to a Task