Blog

  • How do you split 1 column into 2 in Excel?

    Are you still wasting time in Microsoft Excel?

    ~ HOW TO VIDEO INCLUDED! ~ I am often asked about how to split 1 column into 2, for example you may have full names in a column and want to split them into first and last so you can sort them by last name. It will be useful in many other situations, instead of using TEXT formulas. You may want to join columns such as address fields. You can also use Flash Fill to extract names from a list of emails. Here’s my new tip for you…

    Read more…
  • Are you a HR Professional wanting to improve your LinkedIn reach?

    Improve your LinkedIn Reach as an HR Professional

    ~ VIDEO INCLUDED! ~ Looking to make great strides with your LinkedIn Profile? Book onto our next course to learn how to use LinkedIn more effectively and improve your reach! Click Here To Book

    Read more…
  • 1 Simple Way To Save Time When Sending Routine Emails

    1 simple way to save time when sending routine emails

    ~ HOW TO VIDEO INCLUDED! ~ In my business, there are many times that I send out emails to clients that are all very similar. For example, after a course has been completed, I will send the evaluation comments from those who attended to the person responsible for the booking. The time that is spent on these emails that I send daily soon mounts up, which is why I wanted to share this amazing time saving trick, using the free template app…

    Read more…
  • Turn Handwriting into Text in Microsoft OneNote

    Turn Handwriting into Text in Microsoft OneNote

    The short video at the bottom of this blog shows you the amazing cabability of Microsoft OneNote to convert your written notes (even my dreadful scrawl!) into typed text, and also how the application is so useful for anyone studying or who needs to quickly type out a calculation as OneNote will do the Maths for you!       Start on the Draw ribbon and try writing with one of the coloured pens. If you have a tablet with a stylus…

    Read more…
  • STOP Revealing Sensitive Information by Email!

    STOP Revealing Sensitive Information by Email!

    The danger of staff accidentally or deliberately sending out sensitive information by email is one many companies have to guard against. It’s too easy for the busy office worker to hit ‘Send’ and realise (too late) that they’ve attached a document that should not go outside the organisation. My short ‘How to’ video shows how Microsoft’s new feature Data Loss Prevention stops this from happening by…

    Read more…
  • Excel Speaking Cells – Double Check Your Work!

    Get Excel To Double Check Your Work For You with speaking cells

    Many people struggle to get all their work done in the day, and it’s important that the figures are correct too. Often in Excel we have long lists of data, and we need to check it against an original source. It’s pretty difficult to do that accurately keeping your eye on the screen whilst you run down a list. Speaking cells is a new feature that will read the screen aloud to you, so you can accurately check your work. This short video…

    Read more…
  • Use Macros to Repeat Actions in Microsoft Excel

    Use Macros to Repeat Actions in Microsoft Excel

    Many people ask me what a macro is – and my reply is that it is a ‘recording’ of keystrokes that you can replay as many times as you like. Today’s example is what I thought was a useful shortcut key combination for something that needs to be done so many times – but I always tend to do it the long way round. So, I’ll record a macro to do it at the click of a button. Firstly, I have an unformatted spreadsheet which contains data…

    Read more…
  • How To Get Organised By Using OneNote

    Learn How To Organise Your Life with Microsoft OneNote

    Microsoft OneNote – How To Get Organised By Using OneNote Microsoft OneNote is like an electronic scrapbook, the perfect way to keep everything together on your PC including your notes (agendas, meetings, quick Action notes – which you can turn into Tasks in Outlook), related files, photos, videos and audio notes. You can use it to handwrite on a tablet and turn your scribbled notes into text, or draw shapes or even work out maths formulas.…

    Read more…
  • How To Join And Split Data In Microsoft Excel

    How To Join And Split Data In Microsoft Excel

    ~ HOW TO VIDEO INCLUDED! ~ If you need to manipulate data in Excel, this video shows you how to tackle a few key problems! Does your data appear in one column when you need it split? Or is it in several columns you’d like to combine? Either way, I will show you how to deal with this and how to move your revised data to a new location. Sometimes when you bring numerical data across you lose the leading zeros, so I demonstrate how to create…

    Read more…
  • Microsoft OneDrive – How to save and work in the Cloud

    Microsoft OneDrive – How to save and work in the Cloud

    Scroll down to watch my short ‘How To’ video at the end of this blog!    How would you benefit from storing your files, photos and videos in the cloud? Would it be useful to be able to access them from other devices than your PC – a tablet or a phone? I have documents stored in OneDrive (formally known as SkyDrive) so I can get to them anywhere I have an internet connection. Need a document on your phone whilst out of the…

    Read more…