Upgrading to Office 2013 – Why are the Ribbon commands hidden?

1uIf you have recently upgraded to Office 2013 you will have noticed that the Ribbon is collapsed by default, and only the Ribbon tabs are visible. As a result one of the first questions I get asked when doing upgrade training is “why are the Ribbon commands hidden and how do I get them back”? Continue reading Upgrading to Office 2013 – Why are the Ribbon commands hidden?

Outlook 2013 and 2016 – why are my folders no longer alphabetically listed?

outlookiconOutlook 2013 now offers you the freedom of reordering your folders in any order that takes your fancy.

Now you can simply drag your most used folders to the top of the folder list.  No more fussing around placing numbers and zz’s  in front of folder names. Continue reading Outlook 2013 and 2016 – why are my folders no longer alphabetically listed?

Excel – hiding, unhiding and finding hidden Columns and Rows

SharynAvatarBlog120x120You can easily hide rows and columns in Excel.  However sometimes it isn’t obvious where columns and rows have been hidden.

In this tutorial I show you how to hide and unhide columns and rows and how to easily locate where columns and rows have been hidden in a worksheet. Continue reading Excel – hiding, unhiding and finding hidden Columns and Rows

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

Excel – Copying or moving entire worksheets between workbooks

1xI’ve had a number of requests to cover copying entire worksheets between files. The number one problem seems to be when the data is pasted into the new worksheet Excel doesn’t resize the column widths to fit the pasted data. Instead the columns seem to reset themselves back to the default width. Possibly the best way to avoid this happening is to use the Move and Copy command in Excel. Continue reading Excel – Copying or moving entire worksheets between workbooks

Excel – Working with merged cells (merging and fixing problems)

1xEver tried to centre a heading over the top of a number of columns? It can be a little frustrating, especially when you can’t quite get it to sit as you would like. Last month saw me running multiple Stage 1 Excel courses and it reminded me that this problem frustrates so many. I love hearing the “oh wows” when I show the class how the Merge and Center command allows you to easily centre headings over tables of data. Continue reading Excel – Working with merged cells (merging and fixing problems)