We Want Your Ideas

Posted on November 24th, 2016 in Huis , Posts by Hui - 64 comments

Chandoo.org Wants You

Over the past 9 years Chandoo has written about 2,200 posts on all things Excel and Hui has contributed another 140 posts mostly targeted at the application of Excel techniques to real life situations.

But is this really what you want to see us write about?

So in this post we’re opening the floor to you, with a single simple question:

What would you like to see discussed in future posts in 2017 at Chandoo.org ?

Your ideas can be as specific or general as you like:

One Rule only: The Idea must involve the Functionality, Use or Application of Excel !

We cannot guarantee that your idea will result in a Post, But if you don’t ask, you won’t receive

We will do our best to schedule posts where most requested and suitable skills and time is available by authors.

So, What would you like to see discussed in future posts at Chandoo.org ?

Let us know what you’d like to see in future posts in the comments below:

Written by Hui...

Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

64 Responses to “We Want Your Ideas”

  1. Kedar Jadhav says:

    Excel connection to SAP Data.

    • Josh says:

      Are you able to some of the statistical features available? In particular a multiple regression analysis.

      The regression function returns a large amount of information and a bit on how to use that information and how to interpret it could be very helpful, particularly anyone in studying or researching economics.

      Also, how to identify errors after the regression has been run.

    • Manu Grim says:

      This would be extremely helpful!

  2. Andrew says:

    some ideas

    1) how to read data from various websites into excel
    2) present environmental and sustainability key performance indicators in an interesting way
    3) create a league table in excel
    4) create a form which validates input from other data on the web (eg check a certificate number is valid from a site like http://info.fsc.org/certificate.php)

    • Mehmet Gunal OLCER says:

      Please contact me (mgolcer@yahoo.com). I prepared a "League Table". You input the results of games. Output comes as classification of the league. If you change the week number than you get the classification at the end of this week. You can ask a question to the program such as "what would be the classification of the league if the league was played in any N number of teams instead of all teams". You choose the teams which combine N teams. There are also a lot more abilities of the program.

  3. Graham says:

    Power Query / Power Pivot / DAX and the use of Excel across Office 365 suite

  4. Carl says:

    I think it would be good to see post regarding Excel and how to connect to other applications.

    Some examples:

    Other Microsoft Office Applications
    SharePoint
    Adobe Acrobat

  5. Mehmet Gunal OLCER says:

    I want to learn more about the Cloud Applications.

  6. Jan Martens says:

    Sequential numbers and arrays..
    I'm interested in formulae generating an array of numbers which can be used in array formulae . However, some formulae unexpectedly don't yield an array of values. I tried named formulae, INDEX and offset constructs without satisfying results. The final aim is to load an array in vba with Evaluate(formula).
    At your request, I ll send a workbook. Thanks.

    • NARAYAN says:

      Hi ,

      Why don't you post this as a question in the forum , where you can upload your sample workbook ?

      • Hui... says:

        @Narayan

        This isn't a "How do you solve my xxx problem" post?

        This post is about ideas and themes that people want to learn about in future posts in 2017 and beyond

        As always if people have a "I need help with ..." post they are welcome to visit the Chandoo.org Forums and start a New Thread and attach a file if required.

        • NARAYAN says:

          Hi Hui ,

          A lot of posts on this blog have arisen out of questions posed in the forum.

          Whether Jan wants a post on his ideas or an answer to his problem depends on him.

          Whether you make a blog post out of his question , where ever it is posed , is up to you.

          I am merely giving him a suggestion. It is for him to decide what he wishes to do.

  7. Vishnu says:

    I would like to see CHANDOO in 2017 with the below areas :

    Excel usage with society & daily life .

  8. Luigi Cavallo says:

    I second the database programming requests using the full range of Excel techniques. I love tables but would like to access data from relational databases within my spreadsheets.

  9. Rendi says:

    Daily Showcase of some user-submitted models that use various functionalities. I'd love to see how other people use their knowledge of Excel to build dynamic dashboards.

    • Manoj Rajendran says:

      I love this Idea. I think this can become a medium to showcase skills and creativity. With potential freelancing opportunity (an incentive to participate).

      However, I feel daily update would be a little overwhelming. if Chandoo can manage the quality and showcase only the best of class that would be amazing.

      • Rendi says:

        Yeah even if its a weekly submission format, that would be amazing. We can then see how individual Excel applications can be combined to make some amazing dashboards. 🙂

    • Vikram says:

      This seems a great idea, particularly for dashboards, as there can various innovative ways to create dashboards for addressing common reporting/analysis requirements.

  10. Bob Houle says:

    Discuss the interoperability of Excel with Google Sheets. The ability to share Excel worksheets with others over the internet and allow collaborative development and use of the workbook is very important. Google seems to have come up with a good solution by allowing me to start with Excel, then go to the Google Sheets world, work with others and then, if needed/desired, upload the Google stuff back into the Excel world.

    Thank you for allow us to contribute to your world and for making ours so much better.

  11. Robert Kohutek says:

    Relationships. Not the interpersonal kind, but between tables. I frequently have to pull small datasets from census-like datasets and link it to other small data from state and federal data. I could probably do this in MS Access, but 1) I don't know how, 2) I have to create dashboards from pivot tables/charts that can be emailed to users who also don't use Access, and 3) the tables are small enough that Excel seems like the right choice.

  12. Bernardo says:

    Analyzing text cells, frequency on words, phrases, sentiment...

  13. Lynn C says:

    Would love to see varying degrees of tips. Like Excel 101, 201, 301.

    • EXCELent Bacon says:

      I love this idea. I think there's a lot of 101 material that would go well on Chandoo, and the ability to filter posts by the level of proficiency that the reader is interested in would be really helpful. I'd love to refer my beginner friends to Chandoo, but it seems like a lot of what's here is 200-level content.

  14. Don says:

    How about a series of Excel uses aimed at senior citizens. This could include medical history records, financial/stock records, and the like. I am at a retirement community and there are many other residents with computers that have Excel. Something that encourages better use of Excel would be welcome.

    To be fair there must also be Excel applications that would start youngsters on the road to awesomeness rather than playing mindless games.

  15. Miguel says:

    Excel and Access interaction
    Regular expressions and excel
    Manipulating text with excel
    🙂

  16. Marsha says:

    Getting Started step by step curriculum

  17. Mark says:

    I would like to see more topics about using powerpivot and the interaction of excel with Microsoft Power BI and examples of the use of DAX functions

  18. Ronald Palmer says:

    Any chance of seeing macro integration between excel and access?

  19. Carl White says:

    Dear Mr. Chandoo, My concern is to use Excel in determining point spreads for American Football that give a better than %60 chance of winning. Also could I use the program "League Table" to do the same thing? Thanks.

  20. Devendra Naidu says:

    I would like to see more of use cases of how excel has helped simplify capturing of records and reporting based on the data captured. Users could also share their solutions for a particular use case and then Chandoo can advice a recommended approach for the same.

  21. Momoh Sylvanus says:

    Dear Mr. Chandoo, can we have a function that can convert numbers into letters and also be able to handle approximation in fraction.

    • Mehmet Gunal OLCER says:

      As far as I know Excel has not any function for this issue. I have a short program with no macro converts numbers to words in English and in Turkish languages. The biggest number it can convert is 999,999,999,999.99. If you contact me I share the program.

  22. Fred Cloudt says:

    I would love to see more about the amazing "new" tooling which we have since Office 2010 like PowerBI, Powerpivot, powerview, DAX etc.

    Thanks.

  23. I would like to see interfaces and layouts and navigation suggestions towards to end user of my excel spreadsheets. Say you have 10 sheets but you want a modern looking Index page and layouts etc.

  24. Rick Paddock says:

    Just to reiterate what's already been said above: PowerPivot, Dax, and Power BI. I think with the emergence of dashboard tools I think it's important to start focusing on this.
    To start with ...
    What's the most efficient way to organise data in Excel to read into Power BI to allow drill down?
    Ways to get around the row limitations (maybe via CSV)?

  25. Volkan Güven says:

    Dear Chandoo,

    I would like to see more about Excel-Powerpoint and Word relationship samples and some reviews about useful third party excel add-ins .

    May be you can suggest or review some hardware for office rats like me 🙂 (ergonomic monitor , mouse, etc...).

    Best Regards

  26. Volkan Güven says:

    Dear Chandoo,

    Also i would like to see some articles about Excel-SAP relationship and formatting the raw extracted excel data which is extracted from SAP.

    Best Regards

  27. Anthony says:

    Addins! Please show how to create SECURE add-ins that can be distributed and/or sold such that the source code is protected and is not visible or hackable...

  28. Jeff says:

    Real life (clear & somewhat simple) VBA examples and explanations.

  29. Karlo says:

    I would like to see more HR related themes such as forecasting turnover depending on variables such as age, sex, position, etc

  30. Gene Life says:

    How to create Kanban board in excel with drag n drop cards.

  31. TT75 says:

    Hi Chandoo..
    love you webpage, your approach as the man to enriching others..great job you do..thank you..
    as the sales manager I would like to see what and how can be analysied / visualised in Excel from sales data.
    Respect,
    S.

  32. Jay says:

    I would be interested in seeing a comparative review and the limitations of other excel alternative softwares such as LibreOffice Calc, WPS Office Sheets, Gnumeric, Spread32.
    For instance I am impressed with spread32's concatenate function's ability to operate on a range and not just individual cell selection.
    I am not sure if it's possible to convert to a table in LibreOffice Calc.

  33. Zachariah KM says:

    When we type an inbuilt function in any cell, Excel pops up on the screen a help about that function.

    My request is to teach us how to make a similar feature for a UDF.

  34. Abdul Kader says:

    I would like to convert and edit PDF table to excel

  35. Anita Kelly says:

    How to create a SIGN IN which needs a username and password to enter my USERFORM

  36. bozsaglam says:

    1) How to handle recursion/recursive events in VBA?
    2) Treeview/Hierarchical data structures in relation with the first question

  37. Khalid NGO says:

    Hi Hui,
    Good day...

    Chandoo.org have covered all most all the topics in detail, and we have learned all the things here.

    But since you have opened the floor, I would like to avail this opportunity to learn more about AGGREGATE function, specially with 2 or more conditions (sum or max), I have seen a lot of example at the forum, specially using AGGREGATE function to avoid Ctrl+Shift+Enter.

    Regards,

  38. Laura Pienkowski says:

    VBA created forms - how to dynamically add check boxes/radio buttons, how to adjust their size based on wording length, how to add OK/Cancel buttons programmatically.

  39. kris maly says:

    I think for Small Businesses

    Using Excel

    Data entry Form
    Storing Data using Excel
    Searching data using Excel

  40. Julian Chen says:

    How to build a fully functional Media Player embedded in an Excel file.

  41. Harry says:

    Protecting worksheets and vba workbooks effectively.

    I mean, anyone with a hex editor can get in; but a guide to making it as hard as possible.

  42. srikandi2000 says:

    Excel web app would be great since everything is "Online" now. Embedding Excel as you can see on (my newly created website) may offer a quick way to share our workbook easily.

  43. Jeff S says:

    Publishing spreadsheets that are (at least mostly) automated for daily/monthly updates:
    - connections to other data sources
    - Power BI/Query
    - methods of publishing/distribution

    Statistical analysis for people with only basic knowledge of statistics. Ex. clustering to find customers who are "similar" in their purchasing patterns. Ex2. analyzing data that's not a Normal distribution.

    Methods of gathering user feedback via XL: Ex. sending a list of customers for review, asking for updates on specific fields (like price level or market segment) based on included data.

  44. Sachin Gupta says:

    How to open PDF file data into excel.

  45. Gary says:

    I would like to see the best options to present Excel created charts and tables in MS PowerPoint without linking to a file, when presentation is emailed out to a group.

  46. Andrew Howard says:

    More Power Pivot and Power Query.

    Fewer videos. I read my RSS feed, but don't have the time to watch videos. Text is also more searchable from my mail client.

  47. Priya says:

    can there be an excel quiz or a workbook? i am a beginner and have to understand where to apply all this excel knowledge! there must be ways(quiz/fun Q & A kind of forum) that could sharpening the excel basics and standard everyday businness templates that i might need.when i need it, it would be easier for me to recall and use it .

    Eg: my dad is having trouble understanding the startup costs for his new business, i could set up a template for him. or have him take your quiz to be confident.

  48. Ahmed says:

    I would like to see full discussion on the use of both (Indirect) and (Address) formulas

  49. Taryn Nefdt says:

    I'd like tutorials on template creation in Excel. I really would like more information on how to create useful Excel templates.

    Thanks Chandoo.

Leave a Reply