Excel Tutorial Series (Part 3): Filtering Unique Entries and Combining Reports

February 1, 2012 4 Comments by Tom Fang

This is the 3rd and final part of this Excel tutorial series. If you haven’t watched the previous 2 parts, please go watch those first: Part 1 and Part 2.  Remember to download the Follow Along Workbook to follow along with the tutorial. If you’ve already completed Part 1 and Part 2, use the same file that you worked on for this part. We will now take the work you’ve done and bring the two reports together.

Excel Tutorial Series

Once you’ve completed the series, you should see how with just a few basic functions, you can do a lot in Excel. I hope you are able to takeaway the methodologies taught in this tutorial and apply it to whatever data analysis needs you may have. Please don’t hesitate to leave any questions you may have for Excel in the comments section.

  • Pingback: Excel Tutorial Series (Part 2): Index, Match, and Error Handling | iPyxel Creations | Straight-to-the-point internet marketing services and software

  • jac

    I have a problem with the N column thats supposed to go 1,2,3,4,5 down to 12. I have the exact same formula but it shows up as blank. No error or number, just blank.

    please help.

  • David

    Hi, what a great series! Quick question, on the completed final output workbook from your excel spreadsheet, why don’t you include the ad body copy?

    Thanks!

    • http://www.ipyxel.com/ Tom Fang

      Thanks David.

      Actually the reports don’t include ad headline and body copy. The only reason we could retrieve the so called headline is because when we created those ads, we used the headline as the creative name also. Hope that makes sense.