Tags » Microsoft Excel 2010

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

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