Started new job on Monday, mentioned today that i had done some work automating Google analytics and Excel 2007 to produce reports in a previous job. Response was along the lines oh didn’t know you could do that, that would save some time… as your the only person with any knowledge could you sort something out…

So, new company is using Excel 2010, is there a solution? and what would be the best starting point. At this point i am looking at web traffic figures, and am happy playing with some VBA, just need some pointers.

So did you lie about having done it before?

Nothing to see here….

😉

*Cheeky edit*

If you read his post, he did it in 2007 previously and is asking about 2010.

Can you not use Google’s own analytics tools – I spit out a report to my bosses each month by email, but it is all automated from the site with a custom report.

just make some shit up….they’ll never know 😀

i didn’t mention it in the interview as was of no relevance, the job was excel and cognos, just having a chat with my manager today and i mentioned that one of marketing reports could be done another way.

See, this is what happens when you give it 110%.

well i managed to find the code i used in the last job, which worked then, tried it at work and it didn’t, then installed a demo of Office 2010 on home computer and it did work???? So a little confused.

I might have to speak to IT in case they have blocked something???