July News 2017

July News 2017

July 2017 News  Welcome to our July newsletter. The last 2 months have been extremely busy with year end approaching and we are now almost fully booked for July dates. Here's a quick low down of what's been happening... Latest Post: Seamless Colour Matching in...
Use the Eyedropper to Match Colours in PowerPoint

Use the Eyedropper to Match Colours in PowerPoint

Use the Eyedropper to Match Colours in PowerPoint One of the best ways to build a professional presentation is to use a consistent colour scheme. If you’re using PowerPoint 2013 or later you will have access to a new feature called the Eyedropper tool. Making...
Microsoft Project Holiday Import Wizard

Microsoft Project Holiday Import Wizard

MS Project Holiday Import Wizard For anyone who has wanted to be able to automatically mark public holidays or work shut down weeks as non-working time in a Microsoft Project Plan calendar, there is now a free tool available for download from Thought Croft. This tool...
May News 2017

May News 2017

May 2017 News  Welcome to our May newsletter. May has seen quite a few web page changes on the Trainers Direct site particularly with the addition of online training in various areas. These can be found within each of the individual course pages and are being added to...
Use a Relative Macro to Speed up Formatting in Excel

Use a Relative Macro to Speed up Formatting in Excel

Make Formatting Super Quick - Record Relative Macros In a recent blog post we learnt how to create custom formats in Excel and how useful and time saving they can be. You can save a custom format in the default workbook to make it available globally but a lot of...
Make Changes to Excel’s Default Workbook

Make Changes to Excel’s Default Workbook

Make Changes to the Default Excel Blank Workbook Last week we looked at how to create custom formats in Excel and how useful and time saving they can be. However, sometimes in Excel, there are certain things that aren't saved globally such as custom formats or styles...
Think You’re a Word Expert? Try our Word Advanced Online Test

Think You’re a Word Expert? Try our Word Advanced Online Test

Microsoft Word is a complex Word Processing tool with many rich time saving features.  Unfortunately, most users only take advantage of a fraction of the tools it has to offer through lack of training . Think you're a know it all? Then try our advanced online test,...
Excel Custom Number Formats

Excel Custom Number Formats

Use Excel’s Custom Number Formats to Display Numbers with their Units of Measurement Alongside… e.g 50 Kg If you have a column of data that you want to show as a measurement unit such as Km, Kg, Lbs and so on, you can set up a custom format so that you...
March News 2017

March News 2017

March 2017 News  Autumn seems to be upon us all of a sudden and with the busiest part of the year on the horizon there's plenty to look forward to. We are proud to announce our latest alliance with Udemy, the world's largest supplier of online learning.  Our online...
5 Excel Hacks that Take Less than 1 Minute

5 Excel Hacks that Take Less than 1 Minute

Meet my guinea pig. She chooses to remain anonymous throughout this test so I’ll just refer to her as Penny (I had a guinea pig called Penny when I was 7 years old). So here’s the deal. I set Penny 5 tasks to do in Excel, threw down the gauntlet and told...