Excel String Tips – Part 3: TRIM and CLEAN functions When using data from the internet, either copied from a website or contained within a downloaded file, string data can be “dirty”. This could be unprintable characters or white space at either the front or end of the string. To remove excess space at the…
Read More
Writing Tips: Spot the Difference (8): e.g. vs i.e. These are two commonly used abbreviations, but on occasion, they are used incorrectly. The only way to know which one to use, you must understand what the abbreviations stand for. Both of these terms originated from latin. e.g. is the shortened form of exempli gratia, “for…
Read More
Writing Tips: Spot the Difference (7): who vs whom I don’t see whom being used very often, maybe it has been lost as a word from a forgotten time. It’s quite a tricky rule, as it’s difficult to diffentiate when to use whom opposed to who. The difference between the two comes down to the…
Read More
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
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 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 (2): Practise vs Practice This is a very common mistake, one that I had to relearn myself. Unfortunately, it seems that this has been lost in the “progression” of the English language. practise verb: be involved in a rehearsal, rehearse, practice, repeat an activity several times in order to improve…
Read More
Excel Worksheet Tips: convert numbers to text and text to numbers I use excel on a daily basis and as I come across things that I have needed to look up, I will post them here. The first thing I have come across is converting numbers stored as text into actual numbers and vice versa.…
Read More
Writing Tips: Spot the Difference (1): compliment vs complement I’ve noticed that there are many words that people have trouble telling the difference between. I thought it would be useful to help people with some of the common ones. compliment vs complement – Adam complimented Sarah on her new hair colour. “That colour complements your face, it…
Read More
Music – Rating One thing that I constantly find myself doing is rating music. For some reason, it never seems to end, most likely because I’m always scoring new music. This probably won’t be a problem in a little while, as I won’t have money to burn anymore! But I found some ways to tackle…
Read More
SUBMEG 