Microsoft PowerPoint 2016 for Windows has all the functionality and features you’re used to, with some added enhancements and the best new features from Microsoft Office 2016. Text Highlighter PowerPoint now has a Text Highlighter similar to the one in Word, by popular demand! You can use it to pick different highlight colors to emphasize […]

Microsoft Office 2016 Quick Guides have been created for the new versions of Word, Excel, PowerPoint and Outlook for your Windows PC. Download free Quick Start Guides for an introduction to the basics in each of these apps. – Click on the links below for links to the download files. Sign up to one of

Building Custom Tables and Filters in Microsoft Project Most people using Microsoft Project have the requirement to store additional information which may not be an option in Microsoft’s standard tables.  Storing additional data in custom table fields then creates the requirement to build customised filters to help find and extract that information.  This post covers

On the View tab in the Microsoft Project Ribbon there is an option to show or hide the Project Timeline.  The Timeline allows you to easily create a high level view of your project plan that you can then share through other Office applications such as PowerPoint and Outlook. Viewing Microsoft Project Timelines You can

After a few minor upgrades in previous editions, the new version of Crystal Reports coming out now actually has some useful new features: Conditional formatting of lines and boxes – a nice, simple formatting attribute, removing the need to create multiple sections with a different lines and each section conditionally hidden to show the different

Use Match Index instead of VLookup Our Microsoft Excel training courses take your through many of the program’s built-in functions, including the combined use of Match Index. One of the most popular is the VLOOKUP function, which lets you search for and return values in an Excel worksheet as if it were a database table.

Microsoft Project’s New Report Tools Everyone’s reporting needs are different, and for years Mircosoft Project’s reporting options were very limited and looked outdated. Now however Microsoft have built impressive new reporting features into the Project software application. Building off familiar Microsoft Office components, you can now create reports with charts and tables in Microsoft Project

A common question we get from people working with Microsoft Access databases is How can I record & audit when changes were made? To create a detailed audit trail you would need to set up a one-to-many relationship for each table involved so that each table has a related table holding a history of edits. 

Date Calculations in Excel With Microsoft Excel Date Calculations, is there an easy way to work out current age using an Excel formula? Yes!   a function called DATEDIF used to work really well. Unfortunately Microsoft no longer supports this function in Excel – you can still use it, but you just don’t get any help

Learning at Work 2016 This year’s Learning at Work Week is nearly here! There is still time to take part in one of our Quick Learn events in Glasgow and Edinburgh. Contact us for details: [email protected] We deliver IT skills training courses on Microsoft Excel, Access, Project, Visio, Word, Crystal Reports, and much, much more