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 […]
