Showing posts with label Data Consolidation. Show all posts
Showing posts with label Data Consolidation. Show all posts

Saturday, 16 January 2010

SPREADSHEET TIPS & TRICKS: Consolidating Data Lists...

Do you work in sales & trading? Have you ever had the head of your desk approach you and say, "Could you just run me a quick report to find out how many clients have dealt with us during 2009?"... Have you said "Yes" but thought to yourself, "Do I look like a spreadsheet jockey? Why is he getting me to do that? And more importantly; How on earth do I do that...?"

First, the excel tip, then the career advice...