Too Many Different Cell Formats Error – Excel 2007/Excel 2010

This error can arise when you go to paste data at the end of a list where some of the following conditions apply:-
-the workbook was originally a 97 – 2003 xls format workbook,
-covers a large area or has a long list of data,
-cell formatting has been used to provide borders and fill over a large area.
This article discusses the solution. Continue Reading

The True Value of Excel Training

I a big part of what I do is Excel training particularly Intermediate, Advanced and custom courses. It is not unusual when you have just finished a demonstration or an exercise using a feature to hear a groan from somewhere in the group, followed by comments like “I could have used this last week doing report x” or “This process will save me x hours every week” or “that will enable me to do a report I didn’t think we could do” . Continue Reading

How to Create Calculated Items in Pivot Tables

Excel 2007/2010 How to Create Calculated Items in Pivot Tables Continue Reading

Calculated Fields in Pivot Tables

The following short movie illustrates preparing calculated fields in pivot tables in Excel 2010. This technique is very similar for Excel 2007. This is the first of a short series on Pivot Tables that I am preparing. Continue Reading

Conditional formatting of columns in Excel 2007

We can easily do conditional formatting of columns in Excel 2007. A common questions is how to format a row based on a value in the row Continue Reading