You are here: Home » Excel Formula Generator

Archive for Excel Formula Generator

Calculator: Search & Sort Ad Copy in Excel

Excel Formula Generator Published December 25, 2011 at 8:35 am No Comments

What does this do? Below is a generator that creates a custom Excel formula. It searches up to 5 columns of data for a keyword you define. Why this is important for Search Engine Marketing (SEM)? Updating, filtering and sorting Adcopy is a very annoying important part of any Account Manager’s day-to-day tasks. In order to ensure [...]

Calculator: Excel Formula to Calculate Fiscal Week, Quarter and Year

Excel Formula Generator Published December 14, 2011 at 5:00 pm No Comments

Below is a formula generator used to take dates in Excel (assumed as A1) and convert them into the following: Fiscal Week Fiscal Quarter Fiscal Year This is particularly useful when clients use non-generic fiscal calendars and you need to assign their fiscal information to large amounts of data in Excel. The most common application I [...]

Me.