fbpx

Blog

  • 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…
  • 1 Quick Tip – for When the Little Things Don’t Work

    One of my customers was getting annoyed because in Word his fractions character just wasn’t happening when he typed 1/2 – it stayed the same size and didn’t become a fraction at all. As an accountant, this was irritating because he needed to type that frequently. I created a short ‘How To’ video to show him what to do to set this right – it’s in AutoCorrect and someone has probably taken a tick out of…

    Read more…
  • Best Word Timesaving Tip Ever!

    Customise Your Own Keyboard Shortcuts A way to shave seconds off every single thing you do on your PC during the day is to use shortcuts. In Word you can customise your own shortcut keys and it’s easy!   You can customise keyboard shortcuts by assigning keyboard shortcuts (or shortcut keys) to a command, macro, font, style, or frequently used symbol. You can also remove keyboard shortcuts by selecting the shortcut in the Customize…

    Read more…
  • Microsoft OneDrive and Web Apps

    New Windows Start Screen Microsoft has rebranded Office Web Apps as Office Online, with the individual apps renamed to Word Online, Excel Online, PowerPoint Online and OneNote Online. Office Online rolled out recently, and Microsoft’s office.com site will be refreshed to accommodate the changes. OneDrive is a free cloud storage solution with access to the Microsoft WebApps – see my previous blog posts. Office Web Apps are currently…

    Read more…