Blog

  • 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…
  • 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…
  • What are Pivot Tables?

    The PivotTable feature is a popular feature as it helps you see information in a way that it is grouped (and therefore condensed) into a smaller number of rows. To understand what a pivot table is take a look at this example of a long list of data. The data could be potentially up to a million rows – no-one could draw any conclusions about what it means so we can easily create a Pivot Table from the data. Good data to start with should have…

    Read more…
  • Excel – What is Business Intelligence?

    Microsoft Power BI is a suite of tools that enable you to connect to your data, analyse it and then share it easily. If you know me, you’ll have heard me raving about Business Intelligence! It’s amazing – 4 new main tools, which we teach in our One Day Classroom course. Use Pivot Tables? Love them? Then you’ll love Power Pivots…. crazy way to join tables from different files, giving you a summary of all that…

    Read more…
  • The Obvious Strategy That Will Save Your Business Money (But Are You Doing It?)

    Please humour me with a little sum before I begin. You don’t need a calculator, but just estimate how much time each of the people in your team spends using Excel each week. Then ask yourself, what would happen if you could reduce that time by 10%, 30% or even 50% and still get the same amount of work done at the end of the week. OK, humouring over – let’s get down to the cold hard facts. (You can get your calculator out now if you like.)…

    Read more…