Tag: 3Q Tips/Tricks
How-To: Automate Data Refreshes in PPT
Dec 06 2016
Do you make many PowerPoint presentations throughout the year that include graphs and charts created...
Leverage Text Formulas to Get Advanced in Excel
Aug 02 2016
Text formulas are a powerful tool in Excel. They force you to think about how...
Get Started with Excel: Avoid Common Excel Mistakes
Jul 25 2016
It’s frustrating to feel like you’ve done everything right, only to get a bad result....
Get Started with Statistical Formulas and Forecasting
Jul 12 2016
Forecasting is a task that can be easy to get right, and easy to get...
Sharpen Your Excel Skills with Lookups, Index, and Match
Jun 29 2016
Ah, vlookup…one of the fundamentals of any digital marketer’s Excel toolbox. As we all know,...
Simplifying Excel for Digital Marketers
Jun 14 2016
Before I started my job here at 3Q, I was an Excel noob compared to...
The Subtotal Function, One of Excel’s Unsung Heroes
Jan 13 2016
Subtotals are awesome for, well, subtotaling. But they’re good for more than that – despite...
18 Tips for Better Client-Facing Documents
Oct 26 2015
Creating a beautiful client-facing document doesn’t have to be an arduous task. One of the...
Make Reports and Spreadsheets More Dynamic with Conditional Formatting
Oct 06 2015
Excel spreadsheets and reports can overwhelm users with a sea of data, but not if...
Use Excel for proofreading and QA
Aug 17 2015
Finding errors while proof reading an Excel file can feel like finding a needle in...
Two PPC Excel tips you can learn in less than one minute
May 14 2015
While Microsoft Excel may seem confusing for those viewing it for the first time, it...