November News 2017

November News 2017

November 2017 News  Welcome to our November newsletter. With 2017 drawing to a close soon, this month marks the busiest time of the year for most training providers. Here's a run down of our latest course schedule and a round up of what's happening here at Trainers...

Remove Characters from a Cell in Excel

How to Remove Characters from an Excel String Suppose you have a column of data in Excel and you want to remove let's say the last 3 chars?  120 kms 12 kms 15 kms 202 kms 1000 kms This could be a very time consuming job especially if you have a huge list! But......
Excel’s Index Match Made Easy

Excel’s Index Match Made Easy

How to Use Index Match Instead of Vlookup Why would you want to use Index Match instead of Vlookup I hear you say? Most experienced Excel users feel at home using Vlookup, it's easy, you don't have to think about it but does it always do the job? No, not always...
Sept News 2017

Sept News 2017

September 2017 News  Welcome to our September newsletter. With Summer just around the corner and Christmas looming on the horizon it's a busy time for our trainers so if you're thinking about booking an onsite workshop or a classroom course, now is the time. Latest...
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...