Tags » Microsoft Excel 2010

Microsoft Excel – referencing a cell in a chart title

When working with charts in Microsoft Excel, you may want the title to reference a cell in your spreadsheet so that if the information changes in that cell, the chart title will also change.  128 more words

Microsoft Excel

Microsoft Excel – creating a work week series based on a Monday to Saturday working week

If you type in a date in Microsoft Excel and drag down, the subsequent cells will show subsequent dates and when you look at the Autofill options, you will see options for selecting for filling… 106 more words

Microsoft Excel

Microsoft Excel - Conditionally format blank cells

To conditionally format blank cells: Select the data range that you want to format. From the Home tab, click the Conditional Formatting dropdown and click… 71 more words

Microsoft Excel

Microsoft Excel – showing the Field List in a PivotTable in alphabetical order

By default, when you insert a PivotTable into an Excel workbook, the field list is shown in the order of the column headings in the original data set. 108 more words

Microsoft Excel

Microsoft Excel - The RANK, RANK.AV and RANK.EQ functions

The RANK function in Excel ranks numbers in order. In this example, people have scored their favourite film personalities, and I want to rank those personalities in order of preference. 230 more words

Microsoft Excel

Microsoft Excel – changing date format dd.mm.yyyy to dd/mm/yyyy

Some countries have their date format as dd.mm.yyyy and if they send you a workbook containing dates, you may want to format them as dd/mm/yyyy for your own purposes. 130 more words

Microsoft Excel

Microsoft Excel - Conditionally format blank cells

To conditionally format blank cells:

Select the data range that you want to format.

From the Home tab, click the Conditional Formatting dropdown and click… 71 more words

Microsoft Excel