Blog

  • 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…
  • Oooops I didn’t mean to send that! Recall an email in Outlook…

    Outlook 2010 Tips I don’t know about you but I’m always pressing Send on an email then realising that I didn’t attach the file I meant to send with it. Can an email be recalled in Outlook?         There is a way to retrieve the email, and this is what you need to do:       Open the message you sent. It will be in Mail, in the Sent Items folder. On the message tab, in the Move group,…

    Read more…
  • God Mode and 7 Other Brilliant Windows 7 Features

    Aero Flip 3D You may have been used to using Alt + Tab to flick between open programs previously but in Windows 7 you can use Aero Flip by using Windows + Tab. Try it, it’s neat! Windows Button The Windows button can be opened by clicking it with a mouse or use the keyboard button. It opens a list of all programs on the PC, and these can be clicked holding the Ctrl key down and dragged onto the Taskbar or right click and select Pin to Taskbar.…

    Read more…