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. […]
How to do an IF statement in Excel
An IF statement or an IF function is a way to ask a closed ended question that can be one of two answers, either true or false.
Once the result […]
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 […]
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 […]
QuickTuts - Recover Your Unsaved Documents in Word 2010
Have you ever hit ‘Don’t Save’ when you should have said ‘Yes’ to save a new file? Office 2010 has made life easier allowing you to easily find those […]
QuickTuts - Add Holidays and Time Zones to Calendar
Keeping in touch with family, friends and colleagues around the world just got easier with Outlook 2010. In this QuickTut video, Liz French goes through some simple steps to add […]
