Use Ms Excel as a tool for your Google Adwords Bid management methods. There are various extremely useful Excel features like Autofilter, Pivot tables, What If tools which are extremely useful for Adword managers and marketing experts.
Google Adwords provides features like exporting keyword dump, keyword csv files. These files can be imported into Excel directly through csv file or import from Web. when you have a table of data that you’re trying to analyze, pivot tables allow you to quickly extract meaningful information by easily changing columns, rows, and filters to get those useful insights. Create PivotTable dialogue box will open to confirm your data source and where you want the Pivot Table generated.
Drag/Drop fields to build reports you want to see
Collapse/Expand fields
Calculated Fields: Avg Position: (kwd1 AvgPos x Imp)+(kwd2 AvgPos x Imp) / Sum of Imp
Report Filter: Country etc, Content/ Search
Standard Filter:
Label Filter
Value Filter
Pivot Charts: Get Pictorial info about adwords
Use Shortcuts and easy ways to do things on Excel, this is very helpful. Some small things like freeze panes, using templates, formatting gives a great way to improve and has tremendous value.
Some resources
http://office.microsoft.com/en-us/excel/default.aspx
http://excel2007.tips.net/
http://netforbeginners.about.com/od/learnmsexcel/Learn_Microsoft_Excel.htm
http://www.lynda.com/
