# Blog

## Writing: Stage 0.1

Writing: Stage 0.1 I’ve had my writing on hold for quite a long time. Now that I’ve been working on this blog (1st birthday just over a week ago) I have been writing semi-consistently for the past year, with the last couple of months becoming even more steady. I am ALMOST ready to start looking…

## Excel Worksheet Tips: Functions Part 1 – IF, OR & AND functions

Excel Worksheet Tips: Functions Part 1 – IF, OR & AND functions I mentioned in a previous post about the IF function. I thought it would be appropriate to go into further detail about these common worksheet functions. IF The IF function is a decision-making function which performs task A or B depending on the…

## Writing Tips: Spot the Difference (6): It’s vs Its

Writing Tips: Spot the Difference (6): It’s vs Its vs Its’ Time to delve into the apostrophes. This one is commonly abused on a regular basis, probably because people are too lazy to use the apostrophe. It’s Abbreviated form of “it is”. It is a cold day today. She said it is a great place…

## Self-motivation: How to achieve your goals

Self-motivation: How to achieve your goals Many people out there have goals, objectives and dreams that they wish to achieve. The problem is, you need some self-motivation to reach them. You need an idea, a path to get there and a source of motivation to fuel your actions. So how to tackle this? Well, I’ve…

## Excel Tips: String Skills – part 2, LEFT, RIGHT and MID functions

Excel Tips: LEFT, RIGHT and MID functions Three of the most useful functions in excel are the LEFT, RIGHT and MID functions. The LEFT function returns the number of specified characters, starting from the left of the string. If you had a string as below: Thisis a test string And you used the function: LEFT(A1,…

## Writing Tips: Spot the Difference (5): There vs Their vs They’re

Writing Tips: Spot the Difference (5): There vs Their vs They’re This is probably the most common that I see on a regular basis. There Indicating a definite or abstract location. Their Indicating possession; ownership. They’re Abbreviated form of “They are” They’re going over there to collect their lunch. This is one of the more…

## Writing Tips: Spot the Difference (4): Weather vs Whether vs Wether

Writing Tips: Spot the Difference (4): Weather vs Whether vs Wether Now this one is a triple header, and is easy to confuse. Wether A castrated male sheep. Weather The state of the atmosphere with respect to temperature, wind, cloudiness, moisture and pressure. Whether Used to introduce a question, usually outlining a choice in options.…

## Excel Tips: String skills – part 1, FIND function

Excel Tips: String skills – part 1 There are MANY things that you can do in excel. These can be split into one of two groups: 1. Sheet formulae – These are formulae that are entered into cells on the worksheet. 2. Macros – These are created in the visual basic editor and are run…