fbpx

Blog

  • The 5 biggest Excel SINS of 2018!

    As a trainer, I get to see inside a lot of companies and sometimes the confessions from delegates on our courses are horrifying! Of course, no-one is born knowing how to use Excel … and so many people self-educate as they find a ‘gap’ in their knowledge. But the problem with this is you are often missing out and doing things the long way around. Or worse still, as some of these sins show us, employees are actually placing their…

    Read more…
  • How to ask your boss for IT Training

    It is never an easy conversation to have with your boss when you know that budgets are tight, everyone is feeling the pinch, there is pressure from the top downwards, and you feel that you and your colleagues just need a little help or training. In a perfect world, where the distractions are not there, and common sense plays a little more part in the perspective it would be obvious that better-trained staff deliver a better result – but that…

    Read more…
  • Excel – How to fill a series of dates down a column

    We provide our delegates with ongoing inspiration and support via short ‘How to’ videos that you can watch and learn from. The latest tips are little things that speed up your work, making you super-efficient. You’ll be well on your way to becoming a productivity Ninja! This week’s tip is about how to quickly insert today’s date and create a series of dates down the column. You may want to copy this date down using…

    Read more…
  • Nesting Excel Formula – MATCH, ISNA and IF to find which items are missing from a list

    Here’s a video I’ve recorded for our delegates who have completed Excel Level 3 Gurus course. It shows how to ‘nest’ 3 formulas to find if an item appears in a different list. That’s a useful thing to be able to do, so I take you step by step through how to build the formula. Try it yourself!

    Read more…
  • What’s the best program for creating Organisational Charts & Flow diagrams?

    One of my favourite customers called me in yesterday with a problem. They have to produce a diagram which shows their customer how the documentation created links together as a series of text boxes with hyperlinks to SharePoint files. However, there are a lot of items and when printing this on an A3 piece of paper, the writing in the boxes is too small for the customer to read. It’s possible to zoom in if viewing online, but on paper (and…

    Read more…
  • Excel – How to compare 2 lists

    We provide our delegates with ongoing inspiration and support via short ‘How to’ videos that you can watch and learn from. The latest tips are little things that speed up your work, making you super-efficient. You’ll be well on your way to becoming an Excel Guru with this one! This week’s tip is about how to compare 2 lists of data and see what’s in both lists (or what’s missing). It involves using complex…

    Read more…
  • How to turn training into profit

    Nowhere is the idea of value for money in training more succinctly described than the saying, ‘if you think education is expensive try ignorance.’ It speaks volumes, but it also misses one very crucial point! The average cost of a driving lesson today is £24 and most would agree that it is money well spent – if you are learning to drive. In fact, after taking the average of 47 hours worth of lessons (as recommended by the Driving…

    Read more…
  • Attacking Toothache

    Do you ever wonder why in some areas of life people will always go to an expert, and in others they will be happy to give it a go themselves? I suppose a lot depends on the value (perceived or otherwise) that is placed upon doing the job really well, and whether the benefits received are worth the risk or cost. For example, even if you had ample evidence that I was handy with a drill, you would still choose a dentist to look after your teeth.…

    Read more…
  • Excel – splitting a column into two

    We provide our delegates with ongoing inspiration and support via short ‘How to’ videos that you can watch and learn from. The latest tips are little things that speed up your work, making you super-efficient. You’ll be well on your way to becoming a productivity Ninja! This week’s tip is about how to split one column into two. You may want to sort a spreadsheet by Last Name but only have a Full Name column of data. In…

    Read more…
  • Thinking of buying e-learning?

    Some of the advances I’ve seen have been game-changing, others are more akin to revolutionary, and some just a result of natural progression.Now I don’t claim to be a visionary, and neither am I old-fashioned. In fact, I am very much one of those people who started my career in the pre-digital age, then learned and embraced each new development as it came along. Technology has been the key driver behind most of the advancements in business…

    Read more…