fbpx
Search
Close this search box.

Ask me your Excel questions & You could win an eBook

Share

Facebook
Twitter
LinkedIn

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.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

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

  1. Matt says:

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

  2. Raj says:

    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

  3. samtheman says:

    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

  4. Arnab says:

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

    • Hui... says:

      @Arnab
      can you post an example of what your after?

      • Arnab says:

        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.

        • Chandoo says:

          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 excellent Data Smart book by John Foreman and read it to get a good idea about these kind of problems & solving them using Excel.

        • Hui... says:

          @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?

  5. Elizabeth says:

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

  6. Juan says:

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

  7. Rahim Zulfiqar Ali says:

    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

  8. geo says:

    what the next best alternative to excel for data analysis

  9. Rasheed says:

    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

  10. ahmed says:

    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.

  11. Athman says:

    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?

  12. Rajesh says:

    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

  13. yashika says:

    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?

  14. MOHIT says:

    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

Leave a Reply