• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    formula to sum on criteria

    Hi , See if this OK. Narayan
  2. N

    Test Yourself

    Hi @Chihiro , @GraH - Guido , Have you taken this test ? https://www.sqlbi.com/self-assessment/?test=1 Narayan
  3. N

    Simple Excel problem

    Hi , In a new worksheet , how do you go to a remote cell such as ZZ100000 , without typing this address in the Goto Reference box ? Narayan
  4. N

    More learning for today

    Hi , All those who use Excel at work can make use of these techniques : https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling Narayan
  5. N

    A new Excel trick

    Hi , Came across this today : https://trickexcel.com/2016/10/14/b1/ Narayan
  6. N

    Excel World Champ tests

    Hi , For those who think of Excel as fun. https://techcommunity.microsoft.com/t5/Excel-Blog/ExcelWorldChamp-Round-1-Answers/ba-p/40207 Narayan
  7. N

    Starting Power Pivot

    Hi , I am finding that there is not so much to look out for on the forum ; I spend time learning Power Pivot , or at least I think I am learning ! Today I watched this video : https://www.youtube.com/watch?v=vpavH7P-Nhs Narayan
  8. N

    Useful information

    Hi , Came across this today : https://exceleratorbi.com.au/correctly-install-power-pivot-excel-2010/ Narayan
  9. N

    VBA Tutorial

    Hi , Those who are interested to get into VBA , might find this useful : https://excelmacromastery.com/vba-tutorial-1/ Narayan
  10. N

    A list of good ( and even great ) Excel resources

    Hi , Came across this today : http://spreadsheeto.com/best-excel-blogs/ Narayan
  11. N

    Improve your skills in Power Pivot

    Hi , See if you find this interesting : https://www.sqlbi.com/daxpuzzle/ Narayan
  12. N

    Helpful blog post

    Hi , Those interested in VBA might find this useful : http://excelmacromastery.com/Blog/index.php/vba-class-modules/ Narayan
  13. N

    Excel VBA exercises

    Hi , Came across this wonderful resource : http://www.worldbestlearningcenter.com/index_files/excel_exercise_download.htm Narayan
  14. N

    Something to read

    Hi , See this : https://sites.google.com/site/e90e50fx/home/us-eslicer-to-select-value-fields-for-your-pivot-table-or-powerpivot Narayan
  15. N

    Find the panda in the workbook

    Hi , Based on Chandoo's Easter egg workbook , here is a similar workbook , which does not contain the word PANDA ; of course , you can make it appear by entering a 10 digit number in cell D3. The puzzle is to find out this number. If you can find this number without a hint , that's great ; in...
  16. N

    Something new and useful

    Hi , Some of you may find this useful : http://www.ibm.com/analytics/watson-analytics/index.html Narayan
  17. N

    Something informative

    Hi , Came across this today ; I think the trick about detecting hidden columns is nice. http://wmfexcel.com/2015/08/29/a-trick-to-sum-visible-columns-only-without-vba/ http://wmfexcel.com/2015/08/22/put-a-dynamic-hint-for-showing-or-hiding-rows-or-columns-hidden-by-data-group/ Narayan
  18. N

    VBA - last row of worksheet

    Hi , Came across this today. http://www.vbaexpress.com/forum/content.php?143-The-Last-Row Narayan
  19. N

    Test your basic Excel knowledge

    Hi All , Just came across this very well done Excel quiz , with well thought out questions ; it's a pity there are so few of them ( Purna , can we have something like this on the forum , with say 25 questions ? ) https://www.wiziq.com/online-tests/22057-test-your-excel-knowledge-updated Narayan
  20. N

    Excel shortcuts

    Hi All , Something to download and refer to : http://www.exceltip.com/wp-content/uploads/2015/05/250-Ms-Excel-Keyboard-Shortcuts.pdf The parent site link : http://www.exceltip.com/tips/250-ms-excel-keyboard-shortcuts.html Narayan
  21. N

    Addressing in Excel Tables

    Hi , Came across this today ; might be useful to those who don't know. http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2013/08/08/absolute-structured-referencing-a-nifty-little-trick.aspx Narayan
  22. N

    Excel Dashboard contest at Excel Forum

    Hi All , ExcelForum has declared a Dashboard contest ; details are here : http://www.excelforum.com/2014-excel-dashboard-competition/1042488-2014-excelforum-dashboard-competition.html Narayan
  23. N

    Came Across A New Excel Blog

    Hi All , Came across this today : http://wmfexcel.wordpress.com/ It's a very simple blog but I learnt a lot. Narayan
  24. N

    Amazing Hidden Egg - Named Ranges

    Hi , Just came across this today : http://datapigtechnologies.com/blog/index.php/whats-so-special-about-zoom-39/ Narayan
  25. N

    OFFSET is not always to be avoided

    Hi , Recently there was a problem posed by a member of the ExcelHero group on LinkedIn ; the problem and the full discussion can be accessed here ...