Posts By: Tori Cushing

Excel Tool to Automatically Format Your CSV Export

Excel Tool to Automatically Format Your CSV Export

Have you exported a csv from AuthorityLabs and looked at it like, “What now?”. Don’t worry, every marketer has had this moment before. That’s where we come in! Now all you have to do is copy and paste the data you want to format into the template and run the macro we developed. What are… Read more »

Excel 104: Pivot Tables on Mac and PC [Video]

Excel 104: Pivot Tables on Mac and PC [Video]

My first impression of a Pivot Table: They are scary, confusing monsters that always make your data look funky. Once I got over the intimidation of them: They are the magical, unicorn warriors of the Excel world. The main thing that Pivot Tables do is … pivot … your data. Just like you would while trying to… Read more »

101 Wednesday Recap: Basic Formulas in Excel

101 Wednesday Recap: Basic Formulas in Excel

Formulas in Excel are basically the keyboard shortcuts of any program. They make operating through large data dumps 10x faster. Do you spend time copying and pasting over and over to combine or look up data? Then this tutorial will be the start of lots of time saved. You’ll be pony status at the end… Read more »

Excel 103: How to Do Annotating in Excel

Excel 103: How to Do Annotating in Excel

Reports should be concise, clear, and pretty. One big way to help your reports be more clear is to label them clearly. Some simple tricks like adding a comment box next to a chart can really help draw in the untrained-data-eye. This is especially important when you have CEOs who hate looking at spreadsheets and… Read more »

101 Wednesday: Conditional Formatting in Excel Recap

101 Wednesday: Conditional Formatting in Excel Recap

Formatting in Excel has always been a major point of focus in our 101 Wednesdays Google+ Hangouts. Our latest wasno different. It’s pretty much the Cushing way to focus on making data pretty. It just so happens that we, and you, can use  pretty colors and icons to quickly show how well data is doing… Read more »