Tags » Microsoft Excel 2010

Microsoft Excel - width of columns in charts

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

Microsoft Excel

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

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

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

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

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

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

Microsoft Excel