QUESTIONS? 1-866-931-4878

Category: Excel

Control Shift Enter Example
Posted on August 11, 2010

CSE Excel Formulas: Find Specific Words With-in a Column of Keywords

CSE Formulas are a lost science to the vast majority of Excel Users.  CSE stands for Control+Shift+Enter.  CSE formulas allow you to perform array calculations.  Let’s see how it works: To calculate

Posted on November 20, 2009

Create 100’s of Unique Geo-Location Ad Creative in Minutes

There is a fantastic formula in Excel which I find myself using quite often when creating ads for Geo-Targeted campaigns.  Its called: Substitute SUBSTITUTE(text,old_text,new_text) To demonstrate how it works, here is an