Mac Tips – Speed up a slow Mac One thing that is always quite easy to diagnose in a Windows based computer is when the system begins to run slow, it’s usually a simple task to determine what has gone wrong. With a Mac, it’s not that simple. With Apple wanting to keep the MacOS…
Read More
Writing Tips: Spot the Difference (9): The Grammar Nazi I was looking at some of the searches on google that have brought visitors to my blog and I wanted to see if those searches were actually finding my blog. After putting in one of the searches, I came across a site which I find pretty…
Read More
Excel VBA Tips: Introduction Within excel, there are two sides to the program. The “front end” is the worksheet area where data is entered and the “back end” is the visual basic editor side. There are many different things that excel can do to help save time and allow you to become more productive. Why…
Read More
Excel Worksheet Tips: Hyperlinks When you have multiple sources of data and you wish to reference them all in one worksheet, it can get a bit messy to put all the data on one worksheet. Maybe you want to link to a web page? No problem! Creating hyperlinks in excel 1. Create some text which…
Read More
Mac Tips – Ctrl + Alt + Del on Mac There are times when you are using a program and all of a sudden it hangs and stops responding! After pressing: the left mouse button, the right mouse button, the spacebar, the enter key, the escape key and the backspace key, you realise that the…
Read More
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
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
SUBMEG 