Many users of Office 2010 ask me how they can open two Excel or Word files at the same time and view them in separate windows, one on each screen. Continue reading Excel and Word 2010 – How do I open two files and view them in separate windows?
SOLUTION: Gain more screen “real-estate” by changing your display settings. Continue reading Office – Changing the screen to gain more screen real estate
I love the Headings feature on the Navigation pane in Word 2010 and 2013. However I did find it a little frustrating when I first used it as the only Headings showing in the pane were the headings that were formatted with Word’s standard styles – Heading1, Heading2, Heading3, etc. Continue reading Word – How can I see customised Style Headings in the Navigation pane?
Let’s face it, upgrading to a newer version of MS Office offers so many fabulous features that we really shouldn’t grizzle. However I’m sure you will agree with me that one of the most frustrating things about upgrading to is trying to locate the command buttons you use most often. And just when you think you their new location sorted you lose them again! Continue reading Upgrading – customising the Quick Access Toolbar and Ribbon
Previous versions of Outlook offered the ability to organise your messages by colour. You could quickly turn on Rules that would distinguish messages from an individual Sender or on a certain Subject and then change the colour and format of the message as it arrived into your Inbox. Therefore making it very quick and easy to identify key messages. Continue reading Outlook – applying colour to messages as they arrive into your Inbox
Categories allow you to quickly organise your Outlook items using colour coding. If you have recently upgraded from an earlier version of Outlook you may have made use of coloured flags to organise your items. Coloured flags are now replaced by Categories. Continue reading Outlook Categories – using colour to organise messages, tasks and appointments
Today I delivered Office 2010 upgrade training and during the session I was asked to demonstrate how to add the file name and path name of a Word document into a Header or Footer. Unfortunately this isn’t a simple “one-click” process so I thought it would be an excellent tutorial to share.
If you were familiar with Pivot tables in Excel versions prior to Excel 2007 you will be very used to working with the blue lines of the Pivot Table and the ability to drag and drop data right on to the Pivot Table.
In Excel 2007, 2010, 2013 and 2016 Pivot Tables are now quite different. The blue lines are gone, along with the wonderful drag-and-drop feature. Continue reading Excel – How do I change my Pivot Table back to the classic (version 2003 and earlier) display?
This is because, by default, Word places 10pt spacing after each paragraph.
I’ve had a few requests for help with animation in PowerPoint 2010 and 2013. It seems that the options on the new Animations tab are causing a bit of head scratching. I’ve created a wee tutorial to explain how to add an animation, change the display options and add multiple animations to a single object. Continue reading PowerPoint – How to add animations in PowerPoint (inc adding multiple animations)