A lot of the time when someone is asking me charts questions it’s simply a matter of not being able to find the setting option or not knowing if the option exists. I am going to share a few tips and tricks that I have in my toolbox that may help you better display your data using charts or even just save you time. I will cover how each differs between Excel and Google Sheets … [Read more...] about Excel & Google Sheets Chart Resources That Will Make Your Life Easier
Search Results for: excel
Excel Tips for the Time-Crunched Marketer
When you’re working with enormous amounts of data in Excel all day long, you’re constantly thinking of ways you can speed up your work without sacrificing quality. When you’re performing routine reporting and budgeting, or data analysis and data visualization, your time is valuable. Let’s spend less time and gain more results. Who’s with us? In this webinar, … [Read more...] about Excel Tips for the Time-Crunched Marketer
How to Make Your Excel Skills Superhero Worthy
Excel is a crucial tool for any PPC marketer. Between building accounts, analyzing data, and applying macros, Excel saves you valuable time and makes your job just a little bit easier. That's why it's important to continually brush up on your skills and make sure you use Excel to your full advantage. Here's two resources that can help you do that! The first one is to download … [Read more...] about How to Make Your Excel Skills Superhero Worthy
How To Build An Ad Copy Proposal Template In Excel
One of the most useful documents in the “Useful Stuff” folder I keep on my desktop is an Ad Copy Proposal Template. It’s not the sexiest Xcel file you’ve ever seen, but it is simple, efficient, and I make copies of it nearly daily (I write a lot of ad copy). I’m going to walk through why I love this doc and how to build your own. You’ll find that putting the time into building … [Read more...] about How To Build An Ad Copy Proposal Template In Excel
PPC Divination: Forecasting Uncertainty in Excel
You’ve heard it before. Whether it’s a new idea you’re gearing up to pitch, or a request handed down to you from upper management. "Show me numbers!" Thus, you have carefully examined and prepared data that show exactly what has happened in your accounts to-date, what’s worked and what hasn’t, and you are equipped to recommend next steps for future success. You know your … [Read more...] about PPC Divination: Forecasting Uncertainty in Excel
Time-Saving PPC Excel Shortcuts That Work
Have you been itching for some more time back in your life? Think about all the time you spend in Excel…and imagine that time cut in HALF. Drooling a little? We thought so. We have a whole host of PPC Excel shortcuts to add to your repertoire and give you a few hours back to spend on the things that matter. Like giant projects in your account. And snuggling your dog. In this … [Read more...] about Time-Saving PPC Excel Shortcuts That Work
3 Essential Excel Formulas to Automate PPC Reports
This guest post is brought to you by Jason Pellissier, Paid Media Manager at Nebo. See Jason live at Hero Conf Austin, April 16-18. The daily life of a PPC manager can be summed up with one word: Reports. Day of week reports, hour of day reports, keyword reports, the number seems to always be increasing with less and less time in the day to actually do them. Because time … [Read more...] about 3 Essential Excel Formulas to Automate PPC Reports
Troubleshooting Lookup Functions in Excel
Last week, Hanapin hosted an Excel Extravaganza, which was a compilation of 3 Excel for PPC webinars in 3 days. On day 3, Lara and I discussed bidding methods with Excel. I specifically discussed bid tables and how to use Lookup functions to automatically pull bid changes from a bid table. We discussed how to write lookup functions, specifically the Index + Match, but I want to … [Read more...] about Troubleshooting Lookup Functions in Excel
It’s Not a Circus, it’s an Excel Extravaganza!
Are you ready for a week that's Excel everything??? This week, we’re celebrating the program that is the peanut butter to grape jelly, the cheese to macaroni, and the...ok, you get it :) Excel is an essential tool in any PPC marketer’s life and since we live and breathe PPC, we're doing a week focused on the tools and functions available in Excel that can make your life … [Read more...] about It’s Not a Circus, it’s an Excel Extravaganza!
EXCEL-erate Your Learning with Hanapin’s PPC Library
Next week, Hanapin kicks off a week long celebration of Excel in the Excel Extravaganza. The whole thing includes 3 webinars and handy resources on the most essential tool in PPC. It's definitely something you don't want to miss. DID YOU KNOW YOU CAN SEARCH FOR ALL THINGS EXCEL IN HANAPIN'S PPC LIBRARY?? It's true, Hanapin Marketing has a whole section dedicated to PPC … [Read more...] about EXCEL-erate Your Learning with Hanapin’s PPC Library
Excel Tools to Unlock Hidden PPC Data
Excel is an important tool for marketers. It’s not only vital that it’s effective, but it needs to be efficient as well. The way you compile and format your data is a major factor for success, especially when the data is being analyzed. In this webinar, join Hanapin’s Rachael Law and Krista Hsieh for help with analysis and troubleshooting in Excel. We’ll help you get the most … [Read more...] about Excel Tools to Unlock Hidden PPC Data
Extracting Text in Excel for PPC
Working with text data is a necessary part of analysis but often overlooked in skill development. This leaves gaps in analysis and adds time and tedium to common tasks. Your ability to work and manipulate text greatly enhances your workflow and effectiveness. Splitting keyword, ad text, or campaign structure allows you to gain deeper insights and find new patterns. Too … [Read more...] about Extracting Text in Excel for PPC