Search Results for: excel

Results 1-10 of 56

Do Math On The Fly In Paste Options

November 20, 2012

But then you have to copy and paste as values and paste back it into the cells where the original numbers lived. Pfft. I don't think so. Excel gives you the ability to do math right on top of your data. I'll demonstrate by taking a set of fictional values (non-union actors) and dividing them...

Formatting Dates in Excel

November 18, 2012

You're not limited to the date formats built into Excel. You can format them however your heart desires. The underlying value (the exact date) will not change. You can tell by looking in the Formula Bar when you select a formatted date. To open the Format Cells dialog, just select the cells you want t...

How To Use Google Docs’ JOIN And SPLIT Functions

November 17, 2012

Google Docs offers two functions in its spreadsheets that Excel doesn't: JOIN and SPLIT. They are the finessed alternatives to Excel's CONCATENATE function and its scorched earth Text to Columns command. JOIN Function Let's say you want to create a regular expression (regex) that joins together (geek ...

Show Change As A Delta Symbol in Excel

November 16, 2012

When I’m working with tables or charts, I like to make labels as short as possible. So when I’m showing a change in a metric over time, like percent difference, I’ll use the delta symbol (Δ) instead of writing out “change” or “difference.” To do this, just type a capital D (I think of d […]

Replicating Google Analytics’ Time Format in Excel

January 14, 2011

Problem: I want to show Time on Site the way Google Analytics does, but it shows up in Excel as number of seconds when I export. Solution: Run a simple formula in Excel to convert, then apply number formatting as follows. Many of the reports in Google Analytics show you either time on site or time ...

Get Context for Your Keyword Research with Google Insights

August 13, 2010

still important to look at your keyword performance in context of data much broader than just your website. And Google Insights for Search is an excellent tool to accomplish that objective. Image Credit: CDC on Unsplash