Posts By: Tori Cushing

How to Use Screaming Frog with Excel

How to Use Screaming Frog with Excel

If you haven’t used Screaming Frog, you are missing out. Screaming Frog is a tool that scrapes your site and identifies common SEO issues. It then presents them in a way that is easy to export and edit in Excel. I know, my dream tool. You can get started with Screaming Frog for free! Or you… Read more »

Excel 105: PivotCharts Tutorial [Video]

Excel 105: PivotCharts [Video]

In my last post I discussed creating Pivot Tables on Mac and PC. Today we will take the next step in Excel,  PivotCharts! Ironically, I find that charts are much easier to work with. But, only if the PivotTable is set up correctly to start with. So, if you missed the creating pivot tables post… Read more »

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 »