Blog

  • Windows 8 Training

    Following last week’s blog on the new Windows, I found this excellent video by Microsoft to help you get up and running with Windows RT, Windows 8 or 8.1. http://windows.microsoft.com/en-us/windows/how-to If you need Live On-Line Training or Classroom Training, we are here! If you are a small business or a large corporation, change can be daunting for your employees and you don’t want to risk the loss of productivity that an upgrade can…

    Read more…
  • What’s in Word Web App?

    As I have described in my previous blog, Microsoft Office Web Apps are free if you have a OneDrive account, which you can get if you have a Hotmail email account or a Windows Live account (both of which are free!) This means you have access to many of the main features of Microsoft Word, to enable you to do word processing ‘on the move’ and indeed you can work on a document with others, and see when they make any amendments – great for…

    Read more…
  • Microsoft Web Apps and SkyDrive

    Microsoft Web Apps are free and available to anyone with a free SkyDrive Account. Anyone with a free Hotmail email account or Windows Live ID can have a free SkyDrive which comes with 7 GB free storage allowing you to keep copies of files online, which allows you to access those files from any PC where you have a decent internet connection. If you sign up for Office 365 this increases to 25 GB free storage for documents in SkyDrive, where those…

    Read more…
  • Excel – VLookup to lookup Values in a List

    I’ve created a short video to show you how to use a VLookup (Vertical lookup) function to look up values from a long list and return them to a convenient table above the list. This example is about employees, but it could work equally well for Accounts, or Parts lists, Products or many other uses. If you found this blog useful, why not sign up on the right to receive my weekly blogs in your Inbox? 

    Read more…
  • How to use Date Functions in Excel

    Dates are important as part of calculations and even something like working out how old someone or something is can be done quickly and accurately using Excel functions. Working out the differences between 2 dates – such as your date of birth and today, or the date an invoice was produced and when it is paid are useful. Also, how can you tell what day of the week a certain date will or has fallen on? You can access all the date functions…

    Read more…
  • What is Microsoft OneNote?

    I’m always astonished that most Microsoft Office users have not heard of OneNote, which in my opinion is an excellent program and one I use on a daily basis – without exaggeration, throughout the day. In my video I demonstrate how to start a section of your OneNote book to plan a holiday in France.             To set up the first time use, click on OneNote in the list of Microsoft Office programs from…

    Read more…
  • Customising Styles in Word

    I am using Word 2010 and I was showing a user how to create a customised quick style which led to a few other questions, including how to delete it when it was not required. If you find this blog useful, why not sign up on the right to receive my weekly blogs in your Inbox? Use the shortcut Ctrl + Alt + Shift + S to launch the Styles dialog box. If you’re not a fan of shortcuts click on the dialog box launcher on the Styles group. Click…

    Read more…
  • Adjusting Multiple Monitors and help with text size on screens

    More people now work with more than one monitor, so they can spread their work across two or more screens. A problem I’ve come across a number of times is having them set up incorrectly, so the wrong monitor is the master (with the taskbar and Windows key), or the mouse travelling the wrong side of the monitor to get to the other screen. I’ve seen people actually lifting their monitors around to get this sorted out but you can easily adjust…

    Read more…
  • How To Create And Use Sections In PowerPoint

    As a trainer I use a number of large presentations so I can flick into pre-prepared slides whilst teaching. I also present, sometimes with others, in front of audiences. I found a new feature of PowerPoint 2010 called Sections which allows me to break up my larger presentations into ‘chunks’ or sections. In Normal View, you see thumbnails of the slides listed on the left of the screen. Click your mouse just above the first slide and right…

    Read more…
  • Have you backed up your QAT?!!

    Have you backed up your QAT?!!

    If you use Microsoft Office 2010 and you don’t know what a QAT is, read on. One of the ways to be most productive in Office 2010 is the Quick Access Toolbar, choosing the right buttons and vitally, saving those button choices so if it all goes wrong you can bring them back! The Quick Access Toolbar (QAT) sits by default at the top left of the Ribbon, and can be moved below the ribbon if preferred. One reason for moving it down is that if…

    Read more…