How to use the Trunc Function in Excel

The Trunc function in Excel is used to reduce the number of decimal places on a number without rounding.

Excel provides a few different rounding functions such as Round, RoundDown and Ceiling to cater for all your rounding needs. However the beauty of the Trunc function is that you can set the number of decimal points for a number without rounding. Continue reading

Create an Organisation Chart in Visio from an Excel Spreadsheet

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. Continue reading

Use a Baseline to Measure Project Progress

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. Continue reading

See Two Presentations at the Same Time

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. Continue reading

Add a Deadline Date to a Task

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. Continue reading

Create a Splash Screen in Excel

A splash screen is a screen which loads when you open a program. A splash screen can be used to display a company logo, advertise and provide information to the user.

To create a splash screen in Excel, you need to create a userform and then use some simple VBA to show the userform when opening a workbook, and make it disappear after a certain amount of time. Continue reading

Create a Photo Album in PowerPoint

The photo album feature of PowerPoint makes it easy to create a presentation displaying photos of an event or topic that can be shared with friends and family, or saved for your own memories.

PowerPoint makes it easy to create a photo album allowing you to change the album layout, theme or picture order at any time. Continue reading

Change the Default File Location for Saving Documents

By default, Word 2007 stores your documents in the My Documents folder. However, you may want to save your documents in a different folder.

You may want to save your documents on a server so that they are accessible by all members of your office easily. It make sense to choose a location where everybody will know where to look for the files. Continue reading

Show PivotTable Report Filter on Different Sheets

The report filter is fantastic for analysing Excel PivotTable data. It allows you to filter the PivotTable using any field from your data source.

An awesome feature called Show Report Filter Pages will display each report filter result on a different sheet of your workbook. This works great when there are only a few filter criteria.

This feature always goes down well in training sessions. It allows you to quickly and easily create multiple reports on different sheets of a workbook, based on the criteria you want to use. Continue reading