Applying conditions to AVERAGE, SUM and COUNT functions in Microsoft Excel

Applying conditions to AVERAGE, SUM and COUNT functions in Microsoft Excel

This is my first article on Microsoft Excel in over two years and continues the series with descriptions and examples of applying conditions to the popular Excel SUM, COUNT and AVERAGE functions. I started writing this article about 6 months ago when one of my friends asked me how to count the number of occurrences in a spreadsheet where a condition in another column was true. I had thought that I had already written such an article and was about to point her to it but it wasn’t there. I remember it was on my list of articles to write about Excel but I’d obviously not written it yet. Anyway,

How to use and customise gradients in Adobe Illustrator

How to use and customise gradients in Adobe Illustrator

Quite often getting gradients to do exactly what you want them to do can be a challenge. In this short article, I’ll cover gradients within Adobe Illustrator but the principles can be used in other Adobe products. First up, what is a gradient? It is the smooth transition from one colour to another colour or more colours. This is done mathematically by apply some of the target colour to the starting colour in the pixels between those colours. A gradient starting out as black and ending as white will go through many shades of grey depending on how many pixels there are between the start and end points. There are

Converting photographs to black and white or sepia using Photoshop

Converting photographs to black and white or sepia using Photoshop

I had to convert a photograph to black and white recently and I remember from many years ago having a problem trying to achieve this. It was a simple automated task in many other photo editing tools (including Photoshop Elements) but I couldn’t figure it out in the full version of Photoshop (I think it was CS2 but may have been earlier). I can’t remember when Camera Raw was introduced to Photoshop but that was where the functionality could be found (Convert to Grayscale option at the top of the HSL/Grayscale tab). It makes a good guess at a black and white conversion and you can use the sliders to

Teeth Whitening your photographs with Adobe Photoshop

Teeth Whitening your photographs with Adobe Photoshop

I have previously written about improving your photographs digitally by “removing red eye and blemishes with Adobe Photoshop“. There is another action that can make a smiling photograph look better and that is teeth whitening. Yellowish teeth are healthy teeth my dentist always said to me from a young age when I wondered why brushing them several times a day did not give me a dazzling bright white smile. Of course in reality most people will not have that toothpaste-ad sparkle but what I can’t do in real life I can make better with Photoshop. So, in this short article I will make the teeth in a photograph a bit

Red eye removal and photo healing using Photoshop

Red eye removal and photo healing using Photoshop

In this short article I will show you how easy it is using Adobe Photoshop to manipulate a photograph that hasn’t quite come out how you expect. Quite often cameras come with red eye removal flash built in but sometimes the subject still comes out with a red pupils rather than a black ones. Photoshop can sort this out for you in seconds. Another thing that quite often happens is that the photograph’s subject has a blemish such as a spot on the skin or other blemish that you’d rather remove. Photoshop’s healing tools can fix them up as if the blemish never existed, something that’s harder to do in

Getting images to a specified dimension using Photoshop

Getting images to a specified dimension using Photoshop

Quite often I have images that don’t quite fit what I want them for. Sometimes, it’s because they are too big and other times they require some cropping or resizing (or both) to obtain the size that I need. In this short article, I will show a couple of methods that I use in Photoshop to get the result I want. The main thing to remember when resizing is that you’ll probably need to resize to one dimension and crop the other. So, in this first example, I want a 960 pixel wide banner that is 360 pixels high to go at the top of a web page. To achieve

Using text within shapes and along shape paths with InDesign

Using text within shapes and along shape paths with InDesign

One of the things that we get asked to do in a design document is to get text to fill a particular shaped gap or follow a path that is not straight. In this article I will cover both of those scenarios. There could be many reasons that you need your text to follow a curved path or to fit inside a particular shape. First up we will start with the shapes and getting your text to fit inside them is really simple. You use the framing tools to set the boundaries for the text and then enter the text within the frame. In the example I have three shapes

Using conditional formatting and functions in Microsoft Excel

Using conditional formatting and functions in Microsoft Excel

This is another one of my articles about Microsoft Excel covering conditional formatting and conditional statement functions such as TRUE, FALSE, NOT, IF, AND, OR, XOR, IFNA and IFERROR. Conditional formatting allows you to display your workbook cells differently based on specified criteria (the values of cells). Conditional functions allow you to present results in your cells based on different criteria. So one is for the display conditions and the other for the values returned based on a conditional statement. Conditional formatting We will start with conditional formatting and with a very simple example. I have a spreadsheet with some (fictional) purchases I made a few years back. Column A

Manipulating and formatting text using functions in Microsoft Excel

Manipulating and formatting text using functions in Microsoft Excel

In this short article I run through some examples of using Excel’s text functions to manipulate or format data. This follows on from my other Excel related articles. Quite often I use Excel to change data to the format that is required in a database and text functions come in very handy in all sorts of situations. I also use Excel to format data into HTML code for use in web pages and I’ll give an example of that. In the descriptions below I refer to the values within the function as text, character, string or values and show them as text or other values in the examples but they

Using dates and date functions in Microsoft Excel

Using dates and date functions in Microsoft Excel

Following on from my article about using names for cells or a range of cells, I have decided to continue writing about Excel and today’s subject are Excel’s use of dates and its date functions. As I am in the UK the default way to show dates in the screenshots will be the UK format but that is just something to be aware of rather than any issue as following through with the examples on your own machine will display in default format for your location. In this article we will cover how dates are stored, their format and then go through the current date functions. I have excluded time