Monthly Archives: May 2014

Excel: How to Create a Custom Function

Excel has lots of built-in functions that do everything from summing up a column or row of numbers to loan repayments, statistics, engineering, trigonometry and so much more. Every now and again someone asks how they can create their own … Continue reading

Posted in Excel, VBA, Visual Basic for Applications | Tagged , | Leave a comment

VBA: Using the IF Statement

The IF statement is one of the most important concepts to use when programming, it is simply used all the time. The IF statement helps the program make decisions based on criteria you have set. So it can decided on … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, VBA, Visual Basic for Applications | Tagged , , , , | 1 Comment

VBA: Understanding Variables

If you are getting into macros then you need to know about programming in Visual Basic for Applications (VBA) and with that you need to know about variables. VBA is a great tool for automating so many tasks in Microsoft … Continue reading

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, PowerPoint, Uncategorized, VBA, Visual Basic for Applications, word, word 2010 | 1 Comment

Removing Timings from PowerPoint Slides

One of the nice things about PowerPoint is that you can add timings to your slides so that  they can change automatically. This is great if you just want to leave it running or if you have rehearsed your presentation … Continue reading

Posted in Microsoft Office, Office 2010, PowerPoint | Tagged , , , | Leave a comment

How to Use Motion Paths in PowerPoint Including Custom Paths

If you have been using PowerPoint then you have probably added some animations to bullet points at the very least to add a bit of movement to your presentations. Many of us would like to do something a bit different from … Continue reading

Posted in Microsoft Office, Office 2010, PowerPoint | Tagged , , , | Leave a comment

How to Check for Dust on Your DSLR Sensor

If you have a DSLR camera and change the lens on it, one of the advantages of a DSLR, there is a chance you can get dust into the camera that can end up on the sensor. If you get … Continue reading

Posted in digital photography, dslr, photography | Tagged , , , | Leave a comment