Tags » Microsoft Excel 2010

Microsoft Excel - creating bulleted lists

I had a client who wanted to use bullet points in a cell. This can be done by going to the Insert tab, then from the… 148 more words

Microsoft Excel

Microsoft Excel - making a PivotChart static

A PivotChart is connected to the PivotTable used to create it so every time you make a change to the PivotTable, the PivotChart automatically changes too. 89 more words

Microsoft Excel

Microsoft Excel – using named cells instead of absolute cell references and updating formulas based on them

Recently I was training a group of people who had large workbooks with a lot of formulas containing absolute cell references. I taught them how to name cells which not only saves the need to use absolute cell references but works right across the workbook. 286 more words

Microsoft Excel

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