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…
Read MoreBlog
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…
Read More
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…
Read MoreSelf-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…
Read More
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,…
Read More
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…
Read 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.…
Read More
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…
Read More
Writing Tips: Spot the Difference (3): Affect vs Effect
Writing Tips: Spot the Difference (3): Affect vs Effect This is one that I see quite a bit, people just have no idea when it comes to affect and effect. Affect To act on; produce a change in Effect A result or consequence When you affect the situation, you have an effect on it. Come…
Read MorePowerpoint help: Two instances of powerpoint
Powerpoint help: Two instances of powerpoint I discovered this problem today. With most of microsoft products, you can open more than one instance at the same time. However, in powerpoint, you cannot do this! Why? Who knows why Microsoft decided to not let you do this. But there are two ways to work around. Work-a-round…
Read More
SUBMEG 