Blog

  • 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…
  • OneNote for note-taking

    Microsoft OneNote is an extremely useful piece of software – not just for anyone in an office based occupation. In this blog I’ll show you how one engineer I trained to use the program kept his work organised and saved himself hours of time using OneNote on his phone whilst mobile then opening the program on his desktop when he returned to the office to do his ‘paperwork’. Not only did he have a record of every job he’d done that day,…

    Read more…
  • Excel – How to add Conditional Formatting

    I often get asked about how you can utilise Microsoft Excel in your daily routine, to help you work more efficiently. I recently showed a delegate how to use Conditional Formatting on a list of personnel, where typically you might want to see who was off sick more often than other staff, or who had taken more holidays. I thought you might be interested to see how this can work. I created a short ‘How to’ video which is about 2 minutes long…

    Read more…
  • When should you upgrade?

    Upgrades: Get all of the gains, and bypass the pains! Some upgrades are necessary, even critical, for a business; while others tend to be optional or merely a matter of preference. In either case, there is a preconception (based on previous experience) that there will be interruption, disruption and hassle as a result of the process. Windows 10, for example, gives much higher levels of security meaning it is seen by most as a critical upgrade…

    Read more…
  • Excel – Simplify your budget spreadsheets with one click!

    Excel spreadsheets shortcut tip

    Don’t get lost in your budget Excel spreadsheets anymore! With this very useful shortcut you can streamline the information in your workbook to reveal what is relevant, simplifying your data within seconds. It’s always useful to see all the data in finance spreadsheets like a cash flow forecast or a profit and loss account, but sometimes you just want to see the important numbers. Any type of spreadsheet which contains formulas can…

    Read more…
  • The 9 steps to Training a clear IT vision!

    In the land of the blind, the one-eyed man is King!

    In the land of the blind, the one-eyed man is King! Being ‘the expert’ is quite a burden to carry and one that is rarely beneficial to the carrier or those it is being carried for. In fact, it always leads to misinformation. I’m not talking here about the professional ‘expert’ whose job it is to understand everything to the nth degree and teach others, but the office ‘expert’ whose real job is something else. This is the person who…

    Read more…
  • This is not the time to start resting on your laurels

    As the Olympics draw to a triumphant close for the GB team, there are so many lessons that we can all glean from the experience. People often think that you only learn from your mistakes, but that doesn’t make any sense at all does it? In fact, it would be a huge mistake just to revel in victory and not study in detail what made it happen. The very phrase ‘resting on your laurels’ could not be more appropriate for this example because it…

    Read more…
  • How to Harness the Power of Your Team

    Cloud computing from 30,000 feet Last week I was working in the cloud while soaring gently above them! In an example of just how quickly technology is moving forward, it seems that another useful function on our smartphones, laptops and tablets has now become redundant. The ‘flight-safe’mode is now defunct and unnecessary, and in-flight WiFi has arrived. So, while on a short break to visit my grandchildren for a week (the raison…

    Read more…