Once you have created a signature it can be inserted into new messages automatically or you can choose to insert it manually. Continue reading Outlook 2010 & 2013 – adding an email signature
If 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?
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?
I just had to share this with you. A fabulous glimpse into the future. Enjoy! Continue reading A day made of glass – a glimpse of the future
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
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
I’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
Ever 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)