PowerPoint’s Summary Slide made easy

Posted Posted in PowerPoint

Once upon a time in PowerPoint (2003 and earlier versions) it was possible, just like with Word, to create a Table of Contents with the click of a button, or two.  This feature was known as Summary Slide.  Unfortunately, it was removed from PowerPoint 2007 onwards, leaving users with a not so easy process to […]

Tidy up your formatting with Format Painter

Posted Posted in Word

I often compile new documents by gathering text from documents I’ve created in the past.  It’s just so much easier and more efficient to copy and paste text you know is relevant instead of starting from scratch.  To avoid bringing across unwanted formatting, I always suggest using Word’s Keep Text Only feature, but the next best […]

Five sure-fire ways to jazz up your Excel spreadsheet

Posted Posted in Excel

Sometimes it’s the simplest things that make the biggest impact, and this is definitely the case when it comes to formatting your Excel spreadsheet. Following are five sure-fire ways to jazz up your spreadsheet, with the least amount of effort.  Remember to take into consideration the content of your spreadsheet before trying any of these […]

Smarten up your SmartArt

Posted Posted in Word

So you’ve added SmartArt to your Word document because you know how effective a graphic can be in catching your readers’ attention.  But, have you taken the next step of formatting your SmartArt so that it looks the best it possibly can? There are a number of quick and easy ways to change the overall […]

Data replication using Ctrl+D

Posted Posted in Excel

Copy and paste is a popular way to replicate data, but did you know that Excel has a shortcut which does the same thing but in less time?  The shortcut I’m talking about is Ctrl+D, and it enables you to copy all data and/or formatting located in the cell immediately ABOVE the active cell. Similar […]

Give me a (section) break!

Posted Posted in Word

Section breaks are a bit of a mystery but if there’s one thing you should know about them, it’s this: section breaks control the formatting of the pages before it.  This includes formatting such as: Headers / footers; Page orientations – portrait versus landscape; Page layouts, e.g. standard one column page versus two columns; Page numbering. […]