Search Results for: excel

Results 1-10 of 55

Real-World Example Of Advanced Filters in Excel [VIDEO]

June 25, 2013

then a client who needed a reporting dashboard for their PPC campaigns wanted me to do something that required me to use advanced filters. Download Excel File If you'd like to download the Excel file I used, you can access it here. Feel free to kick it around and test out some of the filters I demonst...

My Biggest Pivot Table Annoyance (And How To Fix It)

June 23, 2013

[caption id="attachment_1192" align="aligncenter" width="700"] Zomg anNOYing[/caption] If you use pivot tables in Excel a lot like I do and you've ever had to pivot data with long entries, such as URLs (like from a Screaming Frog export or a content report from your analytics software), Exce...

How To Create Pivot Tables In Excel [VIDEO]

December 23, 2012

menu change the report layout to one that's less cramped The Video Download File If you want to follow along, you can download the Excel file I used in this video. There's a tab with the raw dataset, as well as one with the final pivot table. Learn More You have several options to le...

Warning: Skype Bug Sabotages Excel 2010

December 18, 2012

id="attachment_978" align="aligncenter" width="600"] ewww.com[/caption] Last week I wasted an entire afternoon because of an errant bug in my Excel that prohibited me from being able to use Excel's Paste Special dialog. When I'd select Paste Special, I'd get this useless menu: After reinst...

How To Replicate An Moz Historical Domain Analysis Report

November 28, 2012

5: Click the Export button. [caption id="attachment_660" align="aligncenter" width="580"] Click for larger image.[/caption] Make It Sexy In Excel Step 1: Open the csv file in Excel and save it as an xlsx file. Here's what it will look like. (Eww) [caption id="attachment_661" align="aligncen...

How To Create Internal Links in Excel

November 26, 2012

It's safe to assume most people know how to create links in Excel that point to Web pages. Personally, I prefer to use the shortcut Ctr-K (Mac: Command-K), but you can also choose Hyperlink from the contextual menu. (Select the text or object and right-click it to get the contextual menu.) However, Ex...

Auto Increment Lists By Dragging In Excel

November 25, 2012

[caption id="" align="alignnone" width="3000"] Did someone say drag? ??[/caption] One nice option you have in Excel is the ability to drag series values down, saving you the time of entering individual values for well-known lists. Here are a few data types you can drag to auto increment: numbers ...

Change Dashes To Zeroes In Excel

November 23, 2012

I might be alone in this, but I hate seeing hyphens in lieu of 0’s in tables and charts. Here’s what it looks like: To change these dashes to 0’s select either the column or axis and press Ctrl/Command-1 to open formatting options. The formula, if you will follows this structure: Positive; Negative; Zero; […]

Clean Up Data Labels From The GA API

November 21, 2012

We couldn't just call it Revenue like normal people? There is an easy way to remedy this, and there are the awkward processes you'll read in the Excel help files and support site. Ima teach you the easy way! Caveat There's one nuance you need to know first, which is you can't use the same heading ...