I was working with a client the other day creating column charts of data where the horizontal axis was made up of dates. We wanted to make the columns wider, but trying to format the data series to change the width was not possible. 84 more words

## Tags » Microsoft Excel 2010

#### Microsoft Excel – totalling or averaging a column containing an error value

If one of your cells in Excel has an error value then using the Autosum button to total or average the numbers in the cells will also result in an error. 190 more words

#### Microsoft Excel - inputting mobile numbers in a specific format

I was recently asked how to get mobile numbers in the format XXXX XXX XXX in an Excel worksheet. The answer is leave the column in which the mobile numbers are to be input formatted as… 48 more words

#### Microsoft Excel – changing time from 1400 to 14:00

Sometimes we are given a column of times in a worksheet but they don’t look formatted as we went them to be, e.g. 1400 instead of 14:00. 164 more words

#### Microsoft Excel – adding together data from two or more worksheets or workbooks using Pivot Tables

I teach adding together data from several worksheets or workbooks using the **SUM** function or by the use of **Data – Consolidate**. Yet another way of doing this is to use the PivotTable and PivotChart Wizard. 186 more words

#### Microsoft Excel – conditional formatting on combination of two words

I often demonstrate how to conditionally format based on looking for particular text in a cell, but what if two (or more) words have to be in the text string. 108 more words

#### Microsoft Excel - finding all birthdays within a particular month

If you have a column containing dates of births, it is easy to find all birthdays falling within a particular month by filtering the data. 90 more words