Posts By: Tori Cushing

Google Analytics & Screaming Frog – How to Series – Part 2

Google Analytics & Screaming Frog – How to Series – Part 2

At the end of this tuTORIal you will know how to export Screaming Frog data, Google Analytics data, and then bring them together based on whichever value you choose. I will be covering: VLOOKUPs Basic Formatting Conditional Formatting Find and Replace tool Navigating in Google Analytics Navigating in Screaming Frog Many Internet Marketers have heard… Read more »

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 »