#### Archive

Category Archives for "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, […]

## Wildcards 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 […]

## The 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 […]

## How 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 […]

## SUMIF

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 […]

## How 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, […]

## Photo 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 […]

## Photo 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 […]

## Photo 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 […]

## Photo 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 […]

## Navigating 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 […]

## Photo 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 […]

## Styles 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 […]

## Photo 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 […]