If you are anything like me you will be happy about this news. I currently have a Mac, iPad, tablet, PC and Windows phone. In the past it has been frustrating not being able to access my files on the iPad. Check out what Microsoft have done for iPad users.
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?
PROBLEM: Wasting time repetitively applying the same formats
within a document.
SOLUTION: copy the formats instead!
Continue reading Office – Use the Format Painter to copy formatting (but not the text)
To save repeatedly entering your name and contact details at the foot of an email, create an email signature.
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?
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
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 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
Saving document parts as Quick Parts not only saves time it promotes consistency through-out your documents. A standard paragraph of text can be recorded and quickly dropped into a document at any time. Continue reading Word – Quick Parts and Building Blocks: How can I modify a Quick Part?
Recently 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