Tag Archives: Office

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

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

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?

Excel – Excel shortcut tips using Ctrl, Shift and the arrow keys

SharynAvatarBlog120x120This month has been a very busy month and due to the nature of the training courses I have been running I seemed to be sharing this set of tips often.

Hence the creation of this tutorial. I thought it was about time I created this so every one can benefit! Continue reading Excel – Excel shortcut tips using Ctrl, Shift and the arrow keys

Excel training – How to create a floating chart

Floating2Recently I had the pleasure of working onsite with an Executive Assistant who needed assistance with floating charts. She totally impressed me with how she had painstakingly measured and drawn a waterfall chart in PowerPoint using the drawing tools. Her precision was amazing. I totally impressed her by showing her how she could create the same chart in less than 5 minutes using the Charting tools in Excel. Here’s how we did it. Continue reading Excel training – How to create a floating chart