Tags » Microsoft Excel 2010

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

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