Category Archives: Upgrading to Office 2010

Excel and Word 2010 – How do I open two files and view them in separate windows?

SharynAvatarBlog120x120I love working with two screens! Having the ability to have more than one window fully visible is just such a pleasure.

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?

Office – Changing the screen to gain more screen real estate

SharynAvatarBlog120x120PROBLEM: Needing more screen and less Ribbon (great for tablets).

SOLUTION: Gain more screen “real-estate” by changing your display settings. Continue reading Office – Changing the screen to gain more screen real estate

Word – How can I see customised Style Headings in the Navigation pane?

1wI 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?

Upgrading – customising the Quick Access Toolbar and Ribbon

Office2010Let’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

Outlook – applying colour to messages as they arrive into your Inbox

1oPrevious 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

Outlook Categories – using colour to organise messages, tasks and appointments

1oCategories 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

Word – adding the document filename and pathname in a Header or Footer

SharynAvatarBlog120x120Today 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.

Continue reading Word – adding the document filename and pathname in a Header or Footer

Excel – How do I change my Pivot Table back to the classic (version 2003 and earlier) display?

PivotTableIf 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?

PowerPoint – How to add animations in PowerPoint (inc adding multiple animations)

SharynAvatarBlog120x120I’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)