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