Time for another round of open-mic weekend.

As you know, Chandoo.org has been running a podcast show for last few months. We have completed 14 episodes as of today. For the 15th episode, lets have an “Ask Chandoo” as the theme.

**What you need to do:**

Simple. Head over to **ask.chandoo.org** and submit your questions. You can leave me a voice-mail or post your questions

**What happens next?**

I will listen (or read) your questions and choose a handful for the session 15 of our podcast.

**What you get:**

If your question is picked up for the podcast, you will receive the 25 Excel tips e-book.

**How to find out if your question is picked:**

Simple. Tune in to Chandoo.org podcast next Thursday and you will know.

**So what are you waiting for?**

Go ahead and ask your questions.

PS: You are welcome to ask questions about Excel, data analysis, automation, my personal life, how I run Chandoo.org etc.

PPS: Preference will be given to interesting, amusing & useful questions.

## 20 Responses to “Ask me your Excel questions & You could win an eBook”

Hi Chandoo,

Why can’t I install both the 32-bit and 64-bit versions of Office 2013? What are the reasons?

Dear Chandoo,

Excel is the same old while sheet electronics. As you can use Excel to organize your data into rows and columns and to perform and various things.

Is someone working on it futuristic Excel.

Regards,

Raj

Hi! Chandoo,

It's been long time since you have created new excel course (last one I think was power pivot more than a year back). Are you thinking/working on creating new Excel course? (I am eagerly waiting).

Also, aren't you coming in New York to teach your excel magic?

Thanking you,

Samtheman

how to use what if analysis to solve real time logistics problem ?

@Arnab

can you post an example of what your after?

Hi Hui,

One example can be like this --

I have 3 towns which are pretty far from my mother warehouse say 30KM, 40KM, 50 KM

In town 1,I have 10 distributors,In town 2 I have 20 distributors and in town 3 there are 14 distributors

Now if I appoint a courier he will charge x amount

If I use my own vehicle I will incur Y amount.

Now Can I use solver to solve this problem.

Or I can use scenario manager to compare between various vendors.

This is a classic case where Solver based model can give optimum solution.

Since your reply contains only partial data about the problem, I am unable to model it.

But I suggest you to get the

excellentData Smart book by John Foreman and read it to get a good idea about these kind of problems & solving them using Excel.@Arnab

I would simply model all combinations and then add up the total and see which option is cheapest

Are you able to share some real data with us?

How to prevent overwriting of cells with drop down lists when users copy-paste from other spreadsheets?

What are the new functions of Excel 2013? What are the most interesting ones?

@Juan

Start here: http://office.microsoft.com/en-au/excel-help/what-s-new-in-excel-2013-HA102809308.aspx

Hi Chandoo,

My Question is: How to become a Good MIS Analyst in Excel ? How to perform some good analytics in excel for Contact Center of a Bank ?

Regards,

Rahim Zulfiqar Ali

what the next best alternative to excel for data analysis

In Microsoft Excel 2007, I'm trying to apply text to a cell based on the value in an adjacent cell. How can I do this?

Example : if the amount is above zero , adjacent sell value to be paid

Hi Chandoo,

How can we make date-related data increase? I mean when a day passes the next cell value in a column increases by a certain amount, then the next cell the next day and so on.

@Ahmed

You can either use

Data tablesorDynamic FormulaRefer:

Data tables: http://chandoo.org/wp/2009/09/10/data-tables/

Dynamic Formula: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

Can excel be installed in different platforms[OS] or is it specific only to windows. Do we have any open source tools which are competent enough for EXCEl. Do we have any tools which works on all types of OS?

from a group of data, I want to count last 20 records of a person, whose level is above 3 and grade as manager. Could some one please help me. The record will have mixed of name

Hi Chandoo,

I want to present a visual with comparing market estimates for 2 years by different publishers. For eg Publisher ABC says Market size for AUtomobile industry in 2014 is X billion and in 2018 is Y billion. There is publisher DEF which publishes different estimates for 2014 and 2018. How do i present this?? I have seen people making bubble charts for this. Can you help?

WHEN WE WRITE TWO WORD NAME IN ONE COLUMN AND WE SPOSE THAT MOHIT SINGH WE WANNA SINGH MOHIT IN NEXT COLUMN HOW CAN WE WRITE WITH FORMULA