fbpx
Search
Close this search box.

CP015: Handling big data, Controlling model railroad sets, Overcoming Excel obsession & more – ASK CHANDOO

Share

Facebook
Twitter
LinkedIn

In the 15th session of Chandoo.org podcast, lets answer some of your burning Excel questions.

Handling big data, Controlling model railroad sets, Overcoming Excel obsession & More - ASK CHANDOO

What is in this session?

Around last week, I invited you to ask me anything. More than 150 people responded to this call and sent in their questions. Since answering all the questions is not possible, I handpicked roughly 10 questions to answer in this episode of Chandoo.org podcast.

In this podcast, you will learn,

  1. How to fill blank cells with data from above
  2. How to work with Big data in Excel
  3. How to combine data from multiple sources & analyze it in Excel
  4. How I am managing my life after starting Chandoo.org
  5. How to create and distribute stand-alone Excel products
  6. How to control a model railroad set using Excel VBA (not fully answered)
  7. How to control a pivot report with a form control or data validation drop-down
  8. How to overcome Excel obsession
  9. How to calculate average of 4 successive numbers

 

Go ahead and listen to the show

 

Links & Resources mentioned in this session:

Filling blank cells with values from above:

Fill blank cells with values from above - quick excel tip

Here is an article that explains the process in detail.

Controlling pivot tables with form controls + VBA

Here is a detailed tutorial explaining the process.

Calculating average of 4 successive numbers

Here is an example file with solution for this problem.

Formulas & Tricks mentioned in this podcast:

Resources for working with big data / multiple data sets:

Transcript of this session:

Download this podcast transcript [PDF].

So who gets the free 25 Excel tips e-Book?

Every one. Thats right. Since I got many more questions than I could answer, the least I can do is make you awesome in a small way. So here we go.

Click here to download your copy of 25 tips eBook.

Read it, use the tips and become awesome.

Subscribe to Chandoo.org Podcast

Other options to subscribe

 

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.

8 Responses to “CP015: Handling big data, Controlling model railroad sets, Overcoming Excel obsession & more – ASK CHANDOO”

  1. Krishna Teja says:

    Hey Chandoo,
    Q8 - Excel obsession.. Can you please elaborate?

  2. Karthik says:

    Hi Chandoo, the tips are simple, innovative and amazing. Thanks for giving it away for free.. you are a star.

  3. Tom says:

    Chandoo,

    I just wanted to tell you how much I appreciate what you do. The world is lucky to have you!

    Sincerely,

    Tom (long-time reader, infrequent commenter)

  4. Chandoo says:

    Thanks Karthik & Tom for the lovely & thoughtful comments. I am glad you are enjoying the podcast.

    @Krishna,

    For me Excel is a vehicle for achieving something greater. When I was working, Excel (along with Power Point) were means to communicate my thoughts, analysis & reports with my bosses, clients & colleagues.

    Now that I am working for myself (yay, no more TPS reports to be made on Friday evenings), I use Excel mainly to create examples so that millions of users around the world can learn & become awesome in their lives.

  5. neeraj singh says:

    Hi chandoo

    i am big fan/follower of your website off late have been loosing interest honest feedback for following reason
    .>>podcast are great but i guess something like excel training is much better with you tube videos i am sure podcast would be easier to make but i feel videos were better

    >> now everything on your website is more of money money and money somewhere its loosing its charm i used to visit your site every day but now once a week

    >> not much action on your site now like before u used to come up with stuff almost everyday

    hope you being a master in excel will evaluate all i highlighted with some data in past and present

    Please take my feedback as i dont want this amazing site loose its charm as i repeat i am big fan of your work "all the Best"

    • Chandoo says:

      Thanks for your comments Neeraj.

      Answers.

      1. We have an YouTube channel where we post new videos almost every month. Podcast is another way to reach to our audience and share knowledge in a new medium. It costs nothing and there is no pressure to listen. So I am not sure how adding podcasts to everything else we do can disappoint you.

      2. We are operating a for-profit company, not a charity. We try to follow 80-20 approach where 80% of time we provide good value free content and 20% of time we ask you to pay. This is the best I can do. You are free to select any other website or resources for your Excel knowledge if you do not like this.

      3. I live a busy personal life. I have friends, family and other needs to attend too. That is why once every few months we have 1 week off when no new posts are made. Given the fact that we already have more than 500 posts, 40,000+ comments, 25,000+ forum posts, I am sure how you can find something new to learn everyday.

      Again, thanks for your feedback. Please note that this is not a free lunch. I am happy to provide lots of appetizers and drinks for free. But everything has a cost.

  6. neeraj singh says:

    Thank you for the reply !

    My comments were just like a Kid starts complaining to his "Superhero " i will cont.. to follow your website and work as i admire them also learned a lot from it.Please cont.. the good work don't take my comments in a negative way .

  7. Senthil kumar says:

    Hi Chandoo,
    Thank you very much for showing me some light (in fact a lot of light) in excel.

Leave a Reply