In my last blog post, Excel’s Greatest Time Saver: Autofill, I spoke about how useful the Autofill tool is when working with data. Excel is very smart and has […]
Excel’s Greatest Time Saver: Autofill
Autofill in Microsoft Excel is the greatest time saver tool when working with data. The Autofill feature completes a series of entries (such as days of the week, months of […]
How to Create PivotTables in Excel 2013
PivotTables are simply put, a filtering device. They are great for summarising large amounts of data values because you don’t have to write the formulas yourself to perform the calculations. […]
Format your documents with page breaks in Word 2010
Often, I find that documents are improperly formatted where users have continuously hit the ‘Enter’ key to separate paragraphs over a number of pages. It’s a common issue that […]
Compare your data with Single If Statements in Excel 2010
Single If Statements in Excel 2010 are used when you want to create a set of criteria for a set of data, and then have the cells complete a certain […]
Perfect your images in Photoshop with layer masks
Layer masks in Photoshop are used to control and manage a layer’s transparency. This is different to adjusting the opacity of a layer as it provides more flexibility and […]
QuickTuts - Applying Absolute References in Excel 2010
Absolute references in Excel are used when you need to fix or bolt down a cell reference location. If a cell which contains a formula is copied to another place, […]
Leader Tabs - Align Text the Easy Way in Word 2010
Leader tabs are an advanced feature of Microsoft Word which allows you to add marks in the document ruler which creates a custom alignment for text within your document. Instead of […]
QuickTuts - Animating SmartArt Graphics in PowerPoint 2010
Investing time into your presentations, animating SmartArt graphics and creating engaging dynamic multimedia has become crucial in the business world today. Gone are the days of flip charts or using a white […]
Dramatically Sharpen Your Communication Skills
Did you know that 0-10% of the typical employee’s total communication time is of the formal, prepared kind? So what about the other 90% of communication that’s spent on […]