Professional Training Courses for Microsoft Office and Social Media
or Call NOW on 01952 581550

Blog

  • 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…
  • 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…
  • If you think education is expensive, try ignorance

    Education – is it a cost or an investment? Sometimes observations on life are so powerful that lots of people want to lay claim to the original thought. This is one such ‘disputable source’ quote; but for me, it sums up so many people’s poor appreciation of training. “If you think education is expensive, try ignorance.” There are so many critical areas of our daily lives in which we have forgotten where, or how we learned to start…

    Read more…
  • Is your business scoring Own Goals?

    Are your staff scoring own goals?  In business, you expect to be put under pressure from your competition, unforeseen market forces, customer decisions, and pressure to maintain profitability. I’m not suggesting any of these influences are welcome ones, or that life wouldn’t be easier without them – simply that they are to be expected. It would be naive of any business owner to think they can always avoid being under attack from such…

    Read more…
  • Digital Amnesia

    Not a day goes by without me uttering the words: “If it’s not saved in my Calender, it’s not happening!” You’ll often find me jotting down my shopping list in the Notes on my phone, and I’d never be able to get up in the morning if it wasn’t for the alarm on my phone. In fact, I think I’d be pretty rubbish at remembering ANYTHING if it wasn’t for my phone. And I’m not the only one. A recent article in the Daily Mail talked…

    Read more…
  • How to Compare Spreadsheets The Right Way

    How to Compare Spreadsheets The Right Way With Excel Inquire

    You know when you’ve got a few different versions of a spreadsheet, and you end up in muddle? This can happen so easily when you email spreadsheets to colleagues – then they work on them and send them back… and in the meantime you’ve made changes to the original copy! In this video I will show you a new feature in Microsoft Excel that you can use to compare differences between spreadsheets called Excel Inquire.  …

    Read more…