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 […]
Excel & Google Sheets Chart Resources That Will Make Your Life Easier Read More »
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?
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
Forecasting sales is useful for many reasons, such as inventory management, investor relations, and setting expense and marketing budgets. But producing accurate forecasts can be confusing. In this post, I’ll explain how to generate forecasts using Microsoft Excel. Gathering Data To start, identify the objective. What is the purpose of your analysis? Then gather data
The cost of a Super Bowl spot in 2019 set a new record. In fact, 30-second ads that ran during the game cost about $5.25 million, according to one report. Advertisers may be willing to pay a lot to gain attention during the biggest TV event of the year, but what about ad recall? It seems
Super Bowl Ad Recall Dips For Brands That Excel Online 02/07/2019 Read More »
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
Have you ever tried to combine 30 files in Excel & it crashed? Same. Yes, we have all been there. You open a big Excel file that you know will take at least five minutes to load. You are on the edge of your seat saying, “Don’t you dare do it”… and then bam, Excel shuts
Combine 30 Excel Files in 1 Minute with Power BI Read More »
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
PPC Divination: Forecasting Uncertainty in Excel Read More »
Creating a Balanced Scorecard for your organization is a smart, strategic move. Its takes work and thought and planning that can make you feel like you climbed a mountain once it’s complete. But you can’t stop ascending now. Figuring out how to manage your scorecard over time is just as important as creating it. Your
Managing a Balanced Scorecard In Excel Vs. Software Read More »
Whether you’re aggregating or analyzing data, there are a few basic Excel shortcuts that will save time and help you work faster (check out my advanced Excel tricks here). Anyone who’s a regular spreadsheet user can always benefit from taking steps to learn Excel through courses, but if you want to level up your Excel game now, start with these shortcuts.
How Fast Are You in Excel? Here are Top 10 Excel Shortcuts To Speed You Up Read More »
