Analyzing Marketing Data in Excel

On Tuesday's episode of Call for Help, I show tips from the new book - Excel for Marketing Managers. The segment walks through how to take text-based survey data, import to Excel. The tips include taking a random sample, using formulas to average the responses, and using a pivot table to discover trends.

The show notes from the episode contain the complete details.

New Challenge - Uses for FactDouble Function

After a long hiatus, I have posted a new challenge out at the http://www.mrexcel.com/challenge.shtml page. I am looking for anyone who has ever used the FactDouble function to solve a real-world problem.

Fame, fortune, and an autographed book await anyone who knows the answer.

Four Ways to Summarize Data

On today's episode of Call for Help, I walk through four ways to produce a summary of sales data by customer. The episode includes SUMIF, Pivot Tables, Data Consolidate, and Data Subtotals. For complete details, see http://www.mrexcel.com/tip124.shtml.

PodZinger Searches the Audio of Podcasts

This is an amazing thing. I heard about PodZinger on a recent edition of Inside the Net.

These guys took technology that was developed for some spying project and decided to commercialize it to help people search the audio content. Basically, you can now do a text search for anything that I have said in the last 16 weeks of Learn Excel from MrExcel Podcasts.

It works fairly well for search. When their algorithm hears a word and isn't absolutely sure it is a word, they replace it with "--". So at the beginning of each podcast, you will see... "Welcome back to the Mr Excel podcast, I'm Bill --", because they can't believe I would be saying Jelen.

But - if you search for MIN or MAX or SUM, you can probably find the podcasts where I talked about those. Give it a spin - use the PodZinger search box at http://www.mrexcel.com/search.shtml

Great Games for Excel

On today's episode of Call for Help, I show a bunch of cool games and diversions that you can play in Excel. From a simple dice simulation, to 3D tic tac toe, Mastermind, and even arcade-type games like Snake and Excellon, there are a wide variety of cool games for Excel. Complete details on how to download each game are in today's show notes.