This is a post from my blog, and I thought I should share it here for people who want to learn some Excel. Excel is an extremely powerful tool to quickly analyze performance data. Anything that you can export as a report can be analyzed using Excel. While it’s not able to handle massive amounts of data (hundreds of thousands of entries), it can quickly generate an analysis report using several basic functions. You do not have to learn any programming.
I am going to post a 3-part Excel tutorial video series, starting with Part 1 today. Over the next couple of days the other parts will be posted. The tutorials will go over the basic functions you need to build a model that analyzes your ads. At the end of the tutorial, you would be left with a primitive version of iPyxel’s Campaign Viewer. You should have already received this tool when you subscribed to our mailing list, so the purpose of the tutorials isn’t to create something similar for your use but rather for you to learn the basic Excel functions that you can apply to any data analysis you want to do.
To accompany the tutorials, I have also prepared for you the workbook that I used in the video so you can follow along. The first two tabs in blue are example raw reports that you can practice with. The tabs in green are the completed tabs that you can refer to should you get stuck.
http://www.ipyxel.com/excel-tutorial...codes-strings/
Here are parts 2 and 3. Hope you guys find this helpful!
PART 2
http://ipyxel.com/excel-tutorial-ser...rror-handling/
PART 3
http://ipyxel.com/excel-tutorial-ser...ining-reports/
-Tom
Great stuff!