- Home
- How To…
IFERROR
The IFERROR formula in Excel returns a value you specify if a formula results in an error, if there is no error it returns the value of the original formula. The IFERROR function is relatively new to Excel (I believe it started in Excel 2007). For a similar workaround to some VLOOKUP formula error results, […]
Continue readingWildcards in Formula
A wildcard character is a character that can be used as a substitute for another character or characters. I use wildcards in formula mostly in reference or look-up formulas like COUNTIF or SUMIF for example. The wildcards can be used to look up words beginning with or ending with criteria. Note : It can […]
Continue readingThe ABCs of good meetings
Have you ever walked out of a meeting wondering What was that meeting about? Why was I needed there? What did we discuss? Was that just another meeting about a meeting? What was the point of that meeting? Having worked both for and with a variety of companies and people with varying skills, knowledge and positions […]
Continue readingHow to get filename in Excel
As a follow on from the last post, I was asked how to get filename in Excel using similar formulas. This can be done with the formula below. =MID(CELL(“filename”),(SEARCH(“[“,CELL(“filename”))+1),(SEARCH(“]”,CELL(“filename”))-6-(SEARCH(“[“,CELL(“filename”))))) Really simple isn’t it? I bet you were wondering how you didn’t figure it out yourself!! This combines 3 formulas, MID, CELL, and SEARCH. I’ll […]
Continue readingSUMIF
The SUMIF formula is a really useful formula for adding the values in cells based on set criteria. This post will build on what you have seen already in the IF Statements post and will use the example of game scores. To demonstrate this, we will use an example of a list of scores each […]
Continue readingHow to auto fill sequential letters in Excel
This week I was asked how to auto-fill sequential letters in Excel. What do I mean by this? If you type 1 in a cell and drag it down Excel can populate the cells with sequential numbers (2, 3, 4, 5, 6, 7, 8, etc). A user needed a list of sequential letters (a, b, […]
Continue readingPhoto Editing Tutorial 3 : Zombie
This is the third in the series of photo editing tutorials. This time, we will take an image of a head and transform it to a zombie. In the above image I have put the end result side by side with the original image to show the difference. There are many ways of achieving […]
Continue readingPhoto Editing Tutorial 2 : Color and Black And White Part 2
The Story So Far If you have not already seen it, refer to the first part of this tutorial series which can be found here. You will need to know the basics of layers and zooming and erasing before changing the color image below to the image below that which is black and white, but […]
Continue readingPhoto Editing Tutorial 2 : Color and Black and White
In this, the second series of photo editing posts, we will take an image created in the last series of a hand on a beach holding an apple. Then we will make the whole image black and white except for the apple. Our before and after photos look like this. This is a style […]
Continue readingPhoto Editing Tutorial : Finishing Touches
The Story So Far…. Note – This is not the first post in this series relating to a photo editing tutorial. If you haven’t already done so, please read the earlier posts below: Introduction Lasso, Transparency & Layers Zoom & Erase In this first example, have taken a photo of my arm holding and apple […]
Continue readingNavigating Tabs Shortcut
This tip is aimed at those of you who use keyboard shortcuts, or are interested in trying them out. A lot of people may already be familiar with using the Ctrl key and a lettered key for shortcuts (Ctrl+B for Bold, Ctrl+I for Italics, etc.), another really useful Ctrl shortcut is Ctrl+PgUp/PgDn. Combining the Ctrl […]
Continue readingPhoto Editing Tutorial : Zoom & Erase
The Story So Far…. Note – This is not the first post in this series relating to a photo editing tutorial. If you haven’t already done so, please read the earlier posts below: Introduction Lasso, Transparency & Layers In this first example, over the next couple of posts, we will be taking a photo of […]
Continue readingStyles In Word
Note : This applies to MS Word 2010 and later. For earlier versions of Word the steps involved maybe different. Styles in Word allow you to quickly format sections of your document – headings, subheadings, paragraphs, indents, etc. When putting together a large document, I use the Styles mostly to highlight headings and subheadings. One […]
Continue readingPhoto Editing Tutorial : Lasso, Transparency and Layers
The story so far…. Note – This is not the first post in this series relating to a photo editing tutorial. If you haven’t already done so, please read the earlier post below: Introduction In this first example, over the next couple of posts, we will be taking a photo of my arm holding and […]
Continue readingThe Scroll Button
If you are using a mouse with your computer/laptop you may already be familiar with the left button and the right button, but do you use the middle button much? Talking to different people at different levels of computer skill, I was surprised by the number that did not use the middle button, or know […]
Continue reading