Blog

  • 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 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…
  • 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…
  • 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…
  • 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…
  • Excel – Pivot Table new Set Defaults feature for advanced users

    This is cool for those of you who are serious PivotTable users and want to set defaults so that you can quickly format your PivotTables as you usually do, instantly. Every pivot table row field is now getting its own column thanks to Tabular Layout and Repeat All Item Labels being turned on by default! This blog is for more advanced users, we offer training to create PivotTables on our Excel Ninjas course, or we do a Live Online 2 hour session…

    Read more…
  • Excel – Keep your headings at the top

    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 keeping your headings at the top in Excel. Column headings disappear as you scroll down a spreadsheet, which is frustrating as…

    Read more…