I am preparing for my Excel MOUS and am stumbling over the data/consolidate function. My main problem is lack of an example. I took a prep course, and the instructor offered no more examples or explaination that what was in the book (which wasn't much!). Any help would be appreciated, examples especially.