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